Magento – Magento 2.2.3 Cron job won’t run. Status is missed. One is stuck in running. How to fix

cronmagento-cronmagento2

I am having an issue with my Magento 2.2.3 using PHP 7.1 My cron jobs are set as follows:

9,24,38,52 * * * * /usr/local/bin/php /home/website/public_html/update/cron.php >> /home/stebbins/public_html/var/log/update.cron.log

1,25,39,55 * * * * /usr/local/bin/php /home/website/public_html/bin/magento cron:run | grep -v "Ran jobs by schedule" >> /home/stebbins/public_html/var/log/magento.cron.log

0,9,39,49 * * * * /usr/local/bin/php /home/website/public_html/bin/magento setup:cron:run >> /home/stebbins/public_html/var/log/setup.cron.log

When I run the group crons via CLI it says they ran as scheduled, but nearly all appear as status "Missed" and "Too late for schedule". There are also 6 instances of the order export job with status of "running". Please see the screen shots below this message for the cPanel cron settings, cron_schedule table, and Magento admin cron settings.

I think this is due to the crons being "stuck", for lack of a better term and I've been reading the documentation at https://devdocs.magento.com/guides/v2.2/config-guide/cli/config-cli-subcommands-cron.html . I am having a really hard time getting this fixed and I'm spinning my wheels, so, I'm posting here to hopefully get an answer.

Should I manually delete all the "running" jobs from the cron_schedule table?
Is there a CLI command for Linux for this?
Am I just barking up the wrong tree and do you have a better fix?

Thanks so much in advance!

—Screen shots below—

Best Answer

Should I manually delete all the "running" jobs from the cron_schedule table?

Yes, execute query "delete from cron_scheduled where status = 'running'"

Is there a CLI command for linux for this?

mysql ... -e "delete from cron_scheduled where status = 'running'" :)

Am I just barking up the wrong tree and do you have a better fix?

Upgrade to Magento 2.2.6

Also, why you do not run cron every minute?

Related Solutions

Magento – Cron Job Magento 2.2 fail – Class ‘IntlDateFormatter’ not found in

Check whether you have mcrypt module or not

php -m | grep mcrypt

If not present, install it

sudo apt-get install php7.0-mcrypt

Enable the module

sudo phpenmod mcrypt

Restart Apache and php-fpm

sudo service apache2 restart

sudo service php-fpm restart

There are chances that it may not work if you have two php installed in the system. One with Apace/php-fpm and one through CLI. In order to be sure that mcrypt is enabled. Creat a file testmcrypt.php in your root and with below code.

<?php
phpinfo();

Run the file your browser and check if you can see the mcrypt module in the page.

Magento – Most Cron Jobs show as missed

As you mentioned you have setup Magento in new VPS server.

so maybe you missed to set up cron in crontab please check crontab -l from root directory via ssh.

Did you see cron setup there? if not then please use crontab -e to setup cron in crontab and paste below code there.

#~ MAGENTO START
* * * * * /usr/bin/php /var/www/html/magento2/bin/magento cron:run | grep -v Ran jobs by schedule >> /var/www/html/magento2/var/log/magento.cron.log
* * * * * /usr/bin/php /var/www/html/magento2/update/cron.php >> /var/www/html/magento2/var/log/update.cron.log
* * * * * /usr/bin/php /var/www/html/magento2/bin/magento setup:cron:run >> /var/www/html/magento2/var/log/setup.cron.log
#~ MAGENTO END

for more details follow below link

https://devdocs.magento.com/guides/v2.2/config-guide/cli/config-cli-subcommands-cron.html

I think you should install free magento2 extension to check your cron status if not installed where you can track your cron

https://www.wyomind.com/cron-scheduler-magento.html

Related Topic