1

Suddenly and without reason, I get error via the mail concerns a cron job that could not be executed.

Here is the report :

*[Magento\Framework\DB\Adapter\DeadlockException]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
  SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE FROM `yjuk_cron_schedule` WHERE (status = 'pending') AND (job_code in ('ddg_automation_customer_subscriber_guest_sync', 'ddg_automation_importer', 'ddg_automation_status', 'ddg_automation_abandonedcarts', 'ddg_automation_reviews_and_wishlist', 'ddg_automation_campaign', 'ddg_automation_order_sync', 'ddg_automation_cleaner', 'ddg_automation_catalog_sync', 'ddg_automation_email_templates')) AND (created_at < '2018-08-14 12:03:03')  
  [Zend_Db_Statement_Exception]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE FROM `yjuk_cron_schedule` WHERE (status = 'pending') AND (job_code in ('ddg_automation_customer_subscriber_guest_sync', 'ddg_automation_importer', 'ddg_automation_status', 'ddg_automation_abandonedcarts', 'ddg_automation_reviews_and_wishlist', 'ddg_automation_campaign', 'ddg_automation_order_sync', 'ddg_automation_cleaner', 'ddg_automation_catalog_sync', 'ddg_automation_email_templates')) AND (created_at < '2018-08-14 12:03:03')  
  [PDOException]                                                                                                   
  SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction  
cron:run [--group GROUP] [--bootstrap BOOTSTRAP]*

Do you know why? And how can I solve it?

0

please check this issue https://github.com/magento/magento2/issues/8933 and for quick solution backup and truncate the cron_schedule table

  • i was stuck with this link can u plz help me @M.Elwan – divya sekar Feb 14 at 11:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.