cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2.1.8 reindexing deadlock error

SOLVED

Magento 2.1.8 reindexing deadlock error

 

I imported 15k products and 50k customer into Magento site.

 

Magento site version is 2.1.8

and during the run command of reindexing throw following exception in a command line


Category Products indexer process unknown error: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

 

so please suggest me how can i fix this error?

1 REPLY

Re: Magento 2.1.8 reindexing deadlock error

Hello @yagniksphp

try to increase mysql lock wait time and check it.