Solution

  1. Check your application, deployment, or MySQL logs for deadlock errors:

  2. Check your MySQL process list for running processes with the command mysql -e 'show full processlist';

  3. If on Adobe Commerce on cloud infrastructure, check that MySQL slave is enabled. Consult this article: Deploy variables (MYSQL_USE_SLAVE_CONNECTION).

  4. Depending on the errors involved, the solution may present itself, or you may need to include your helpful log information if you need to open a Support Ticket.

NOTE
We are aware that this article may still contain industry-standard software terms that some may find racist, sexist, or oppressive and which may make the reader feel hurt, traumatized, or unwelcome. Adobe is working to remove these terms from our code, documentation, and user experiences.
Previous pageChanges in the database are not reflected on the storefront
Next pageMySQL high-load bottleneck in Adobe Commerce on cloud infrastructure

Commerce