Questions tagged [deadlock]

The tag has no usage guidance.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
2k views

Dealing with “Lock wait timeout exceeded; try restarting transaction” error in Percona Server

I recently upgraded our magento 1.7 database server from MySQL 5.4 to Percona 5.6 in the interest of performance. As expected, the site and general performance of magento has increased vastly, but at ...
2
votes
1answer
464 views

Magento2: During reindex Serialization failure: 1213 Deadlock found when trying to get lock

During php bin/magento indexer:reindex SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: INSERT INTO `...
1
vote
0answers
30 views

Are high AUTO_INCREMENT values in cron_schedule values are problem?

I am debugging a checkout problem, where the shipping address is not saved. This can be reproduced only some times and on production, under unclear circumstances. Checking the logs I found ...
0
votes
1answer
49 views

Magento 1.9.3 Overselling

I have a Magento website, that occasionally sell very requested and popular items with very limited quantity available. In that cases the traffic on the site become 20x/40x the normal traffic. When ...
0
votes
0answers
222 views

DROP TABLE customer_grid_flat hangs - deadlock during customer grid indexing?

We have had an issue with Magento 2.2.5 on an AWS RDS instance (MySQL 5.7): Every then and when, essential Magento Admin functionality is blocked. It is possible to login, but order and customer list ...