cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2 Error for Cron Job in CPanel

Magento 2 Error for Cron Job in CPanel

Hi, I've setup Cron jobs in CPanel but i am getting an error message. I've used shared hosting so i don't have access to SSH. The only way i can reindex my products is through Cron. I've tried changing frequency of jobs from per min to every five mintues etc but no luck.

Anybody have any idea what this means?

 

Error is given below:

 

[Magento\Framework\DB\Adapter\DeadlockException]
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `mg3z_cron_schedule` SET `job_code` = ?, `status` = ?, `messages` = ?, `created_at` = '2017-10-21 13:44:03', `scheduled_at` = '2017-10-21 13:46:00', `executed_at` = ?, `finished_at` = ? WHERE (schedule_id='73208')
[Zend_Db_Statement_Exception]
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `mg3z_cron_schedule` SET `job_code` = ?, `status` = ?, `messages` = ?, `created_at` = '2017-10-21 13:44:03', `scheduled_at` = '2017-10-21 13:46:00', `executed_at` = ?, `finished_at` = ? WHERE (schedule_id='73208')

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

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

 

 

 

1 REPLY

Re: Magento 2 Error for Cron Job in CPanel

Hi,
This error weirdly appeared this night on a production website online for almost a year.

I tried to reindex with SSH command, but no change.

 

Did you fix this ?