Magento 2.1.8 reindexing deadlock error

[yagniksphp]

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?

[Sunil Patel · Accepted solution]

Hello @yagniksphp

try to increase mysql lock wait time and check it.

[cadencelabs]

Depending on the cause of the Deadlocks, the retry module could be used:

https://www.cadence-labs.com/2018/09/magento-2-deadlock-retry-module/