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]
