Questions tagged [deadlock]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
15 views

Magento 2.4.6: how to setup cron for group:index to run less frequently than every minute?

Cron tasks in Magento are executed every minute and when product import and indexing tasks are executed simultaneously database deadlock occurs. Changing settings in "System > Cron (Scheduled ...
player's user avatar
  • 31
0 votes
1 answer
28 views

Reindex catalog_product_attribute Deadlock found when trying to get lock

For some reason we fetch the following deadlock, when we run php bin/magento indexer:reindex catalog_product_attribute Already tried reindex:reset and also performing a full reindex, but that does not ...
JGeer's user avatar
  • 1,416
1 vote
2 answers
99 views

Magento 2.4.3 - Magento Cron for index

We have some issues and I have been told is because we have our Magento cron set to execute every 1 min. But since our installation is so big with tons of product etc we need to raise it to go less ...
Jan-petter Havna's user avatar
0 votes
0 answers
141 views

Magento 2.4.3 index issue - Deadlock

We are experiencing some major issues with reindex lately. We think it has something to do with the 3rd party module (we can't turn it off) We get deadlock during re-indexing every day. And ofc that ...
Jan-petter Havna's user avatar
0 votes
0 answers
103 views

Magento 2: How to check if order is not created but payment is deducted

I have a situation on which sometimes deadlock occurs during order place. But the order is not getting placed and order payment is done successfully. So to overcome that issue, I am using ...
Arun Sharma's user avatar
  • 1,305
0 votes
0 answers
92 views

Magento 2 - prevent the 1205 Lock wait timeout exceeded issue?

Does any have any idea to prevent the 1205 Lock wait timeout exceeded issue? main.CRITICAL: Saving order 0002347423 failed: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try ...
MK Patel's user avatar
  • 422
2 votes
0 answers
842 views

How to prevent deadlock when updating product attribute?

I have built a seperate module for my ERP and custom import from excel file to update product attribute. These two modules using this Magento function to update product attribute: /* Magento\Catalog\...
jojo's user avatar
  • 179
4 votes
1 answer
2k views

Magento 2 - Cronjob Deadlock issue

I am facing an interesting issue. I have some custom cronjobs. If I run them manually with magerun2 (n98-magerun), they will be executed with success. If I let Magento to schedule it and execute it, ...
Attila Naghi's user avatar
  • 3,963
1 vote
0 answers
287 views

Deadlock error during adding products to cart Magento 2

We have upgraded the Magento website from Magento V2.1.4 to Magento V2.3.3-p1 on End of the March and running well. Recently having problem with Deadlock see error below. LATEST DETECTED DEADLOCK ...
Bojjaiah's user avatar
  • 3,988
1 vote
2 answers
350 views

Magento2 detect database deadlock event

I want to detect database deadlock event in my Magento2 (2.3.2) store. Based on that I want to send email to higher authority persons to let them know about deadlock instantly. Any help would be ...
Pratik Navapara's user avatar
1 vote
0 answers
129 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 ...
Alex's user avatar
  • 13.8k
2 votes
1 answer
2k 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 `...
Sylvester's user avatar
  • 2,204
0 votes
1 answer
80 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 ...
Diego's user avatar
  • 21
0 votes
0 answers
434 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 ...
hey's user avatar
  • 1,137
1 vote
1 answer
2k 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 ...
Nidhishanker Modi's user avatar
3 votes
0 answers
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 ...
Latheesan's user avatar
  • 1,038
5 votes
1 answer
3k 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 ...
MB34's user avatar
  • 771
2 votes
1 answer
210 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 ...
Studiovlist's user avatar
1 vote
2 answers
4k 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: ...
brentwpeterson's user avatar
1 vote
1 answer
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 ...
Mohd Alomar's user avatar
8 votes
1 answer
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($...
john-jh's user avatar
  • 550
5 votes
2 answers
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 ...
kalenjordan's user avatar
  • 3,545