Getting "dead Lock" Found" Errors In Logs

Multi-Vendor Questions
1

Hey

We are using CSCART Multivendor Ultimate

We are getting Errors in Log ( 3-4 time daily )

Database (error)
error: Deadlock found when trying to get lock; try restarting transaction (1213)
Query: REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('addons', 'addons'), ('addons', 'schemas'), ('addons', 'thooks_C'), ('addons', 'block_content_menu'), ('addons', 'scheme_block'), ('addons', 'block_content_main_products.view'),

------------------------------

Error is in above format,

anyone can help to resolve the issue.

Regards

2

Hey

We are using CSCART Multivendor Ultimate

We are getting Errors in Log ( 3-4 time daily )

Database (error)
error: Deadlock found when trying to get lock; try restarting transaction (1213)
Query: REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('addons', 'addons'), ('addons', 'schemas'), ('addons', 'thooks_C'), ('addons', 'block_content_menu'), ('addons', 'scheme_block'), ('addons', 'block_content_main_products.view'),

------------------------------

Error is in above format,

anyone can help to resolve the issue.

Regards

Hello!

Please change the used engine of the cscart_cache_handlers table to MyISAM instead of InnoDB. You can execute the following query in order to change it:

ALTER TABLE `cscart_cache_handlers`
ENGINE='MyISAM';

This should resolve the issue.

3

Thankyou @cs-cart team

I have changed the Table Engine to MyISAM. Will monitor the logs and give you feedback if it works.

Regards

4

Thankyou @cs-cart team

I have changed the Table Engine to MyISAM. Will monitor the logs and give you feedback if it works.

Regards

You are welcome!