search

Myddleware / myddleware

Myddleware is the customisable free open-source platform that facilitates data migration and synchonisation between applications.
http://www.myddleware.com
GNU General Public License v3.0
98 stars 50 forks source link

myddleware:synchro ALL not working: The number of maximum instances has been exceeded. #1111

Open JiahuiLuData opened 8 months ago

JiahuiLuData commented 8 months ago

I have my crontab running "myddleware:synchro ALL". It didn't throw any errors out but it just not working. I exported the log file and find records like this whenever I run myddleware:synchro ALL:

// Cronjobs started at Tue, 23 Jan 2024 23:30:02 +0000

Execute cronjobs

[Info] Found 6 jobs

Running "myddleware:synchro ALL"

[Note] cronjob will not be executed. The number of maximum instances has been exceeded.

[Info] myddleware:synchro ALL : Begin 2024-01-23 11:30:03

[Info] myddleware:synchro ALL : End 2024-01-23 11:30:05

I don't know where to see the config for maximum instances. Other jobs such as rerun errors are working fine. Just synchro ALL not working. Can you help me with it?

Thanks

Myddleware commented 8 months ago

Hi @JiahuiLuData , Could you send this query in your database : UPDATE cron_job SET running_instances = 0, max_instances = 10;

This will be improved in the next Myddleware version.

It should solved your problem.

JiahuiLuData commented 8 months ago

That worked! Thanks!

JiahuiLuData commented 8 months ago

Hi Myddleware team, The synchro ALL is not working again. I have checked the myddleware database and the cron_job looks good with the change we made according to your suggestion:

image

And the table cron_result has the continuous running for Synchro All like this:

image

However, the job table doesn't have Synchro ALL records recently. I have the log file for myddleware's crontab running, all others looked fine, just some extra warnings are thrown out during the time period: In NativeFileSessionHandler.php line 49:

Session Storage was not able to create directory "/home/default/html/myddle ware/var/cache/background/sessions".

In NativeFileSessionHandler.php line 49:

Session Storage was not able to create directory "/home/default/html/myddle ware/var/cache/background/sessions".

In NativeFileSessionHandler.php line 49:

Session Storage was not able to create directory "/home/default/html/myddle ware/var/cache/background/sessions".

In NativeFileSessionHandler.php line 49:

Session Storage was not able to create directory "/home/default/html/myddle ware/var/cache/background/sessions".

In NativeFileSessionHandler.php line 49:

Session Storage was not able to create directory "/home/default/html/myddle ware/var/cache/background/sessions".

Can you help me with the troubleshooting? Much appreciated!

Jiahui

Myddleware commented 8 months ago

Hi @JiahuiLuData , Could you give us more detail about the synchro ALL ? Is that not running at all ? Or the job run without reading data ? Or other ? Could you also try to run the command manually by opening a terminal at the Myddleware's root directory and run this command : php bin/conole myddleware:synchro ALL --env=background

Does it run ? If not could you give us what resut you get ? Thanks.