Sometimes I found in log file issue:
Ran jobs by schedule. string(32) "Asymmetric transaction rollback." Ran jobs by schedule. Ran jobs by schedule. Ran jobs by schedule.
Anyone know how it is and how to solve this issue?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
To resolve this follow following steps:
Reset and reindex indexes
php bin/magento indexer:reset php bin/magento indexer:reindex
Remove cache and delete/rename /var and /generated (in case of magento 2.2) folders
php bin/magento cache:flush
It may be due to other sql process query having lock on the desired row, use
SHOW FULL PROCESSLIST
in phpmyadmin/ mysql-cli to get all processes and kill the processes if you have to or wait for some time and try again later.(I think you must have set reindex by schedule and cron must be running right now).