cancel
Showing results for 
Search instead for 
Did you mean: 

Cron serialization failure

Cron serialization failure

Hi - I'm still new to Magento 2, and after we got our cron jobs all set up, we started getting weird emails like this:

 

Subject: Cron <*****@vps43217> /opt/cpanel/ea-php71/root/usr/bin/php /home/irondu5/staging.ironduck.com/Magento/bin/magento cron:run | grep -v "Ran jobs by schedule" >> /home/*****/staging.*****.com/Magento/var/log/magento.cron.log

 

  [Magento\Framework\DB\Adapter\DeadlockException] SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE FROM `mgst_cron_schedule` WHERE (status = 'success') AND (job_code in ('indexer_reindex_all_invalid', 'indexer_update_all_views', 'indexer_clean_all_changelogs')) AND (created_at < '2018-11-28 08:50:03') 

 

[Zend_Db_Statement_Exception]                                   

  SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE FROM `mgst_cron_schedule` WHERE (status = 'success') AND (job_code in ('indexer_reindex_all_invalid', 'indexer_update_all_views', 'indexer_clean_all_changelogs')) AND (created_at < '2018-11-28 08:50:03') 

                                                                                                                 

  [PDOException]                                                                                                  

  SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction 

 

cron:run [--group GROUP] [--bootstrap BOOTSTRAP]

 

Does anyone have a solution for this?

 

Thanks so much,

Britt