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
