- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-24-2023
05:08 AM
10-24-2023
05:08 AM
Error while saving Category in Magento 2.4.6-p1
When I try to save a category I am getting cloudflare timeout error and the category is not getting saved. When I checked the exception log I found this error : SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: UPDATE catalog_category_entity SET attribute_set_id = ?, parent_id = ?, created_at = ?, updated_at = ?, path = ?, position = ?, level = ?, children_count = ? WHERE (entity_id = '1337'). When I restart the mysql service and refresh the same page the category gets saved. How to fix this?
Labels:
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-01-2023
06:26 AM
11-01-2023
06:26 AM
Re: Error while saving Category in Magento 2.4.6-p1
Some other process is locking catalog_category_entity table. Are you sure you are the only one updating categories? Could there be another process or a cron job working with categories?