Questions tagged [deadlock]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
0answers
114 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 `...
0
votes
1answer
43 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
136 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 ...
0
votes
1answer
815 views

Show Process list Magento, queries are set to “sleep”

I am running one magento 1.9.2.4 instance, When I open my website and check process list using Show Processlist in mysql it shows multiple of queries set to "sleep". I am only opening one static ...
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 ...
5
votes
1answer
2k views

Defeating SQL Deadlocks?

We programtically login users automatically to Magento 1.4.0.1; yes, I know it's old, we can't update because of core hacks by another developer. Each user has the same password as we use our ERP to ...
2
votes
1answer
171 views

Deadlock on checkout, works after clear log in database

Hope you guys can help me out, I've a webshop on magento 1.9.0.1 that is giving me problems recently. When a customer wants to order and he clicks on "Process order" it sometimes take up to 30 ...
1
vote
2answers
3k views

MySQL deadlock on catalogsearch_query

I am getting deadlocks on this table catalogsearch_query. The table has approx 500k rows. The site is averaging about 2000 concurrent users. Edit: To clarify concurrent users I mean the following: ...
1
vote
1answer
2k views

Updating the product stock quantity in a safe way

There is a problem that got me confused about updating the stock quantity in a safe way. A simple scenario, suppose I have 10 of product X in warehouse and there is zero orders so, also in Magento ...
8
votes
1answer
2k views

Why does magento re-index pricing on each checkout?

If you look within Mage_CatalogInventory_Model_Observer::reindexQuoteInventory() it calls the following line: Mage::getResourceSingleton('catalog/product_indexer_price')->reindexProductIds($...
5
votes
2answers
1k views

How to prevent lock wait timeout from blocking orders?

Got a lock wait timeout originating in Mage_Sales_Model_Order::_afterSave(): https://github.com/LokeyCoding/magento-mirror/blob/magento-1.8/app/code/core/Mage/Sales/Model/Order.php#L2152 Looks like ...