cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2.1.9 Reindexing deadlock error

Magento 2.1.9 Reindexing deadlock error

Magento Version : 2.1.9

 

Total Products : 18k

Total Customers : 55k

 

I ran re-indexing using CLI in magento 2.1.9 and during catalog_category_product re-indexing i see this error into "Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction" var/log/exception.log.

 

so, if anyone know than please suggest me how can i fix that and how can i fast indexing using CLI