marklcfc Posted October 6, 2023 Share Posted October 6, 2023 I created a new member group and tried multiple times to save permissions but it was hanging, eventually ending with this error below. After this error, I went back and tried again and it saved properly. But thought it was worth mentioning Link to comment Share on other sites More sharing options...
Marc Posted October 6, 2023 Share Posted October 6, 2023 You would need to contact your hosting company on this as it's a deadlock on tables in the database. I would say its worth checking tables to ensure they are all INNODB for a start, as it locks differently. Link to comment Share on other sites More sharing options...
marklcfc Posted October 6, 2023 Author Share Posted October 6, 2023 (edited) They are InnoDB. ibf_core_search_index is quite large in size Edited October 6, 2023 by marklcfc Link to comment Share on other sites More sharing options...
Miss_B Posted October 6, 2023 Share Posted October 6, 2023 Have a look at this article on the MySql site about deadlocks. It will help you understand them. https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html 14 minutes ago, marklcfc said: They are InnoDB. ibf_core_search_index is quite large in size In InnoDB it is possible that any write transaction can cause a deadlock, even in perfectly normal situations. The larger a table is, the larger it writes, and long transaction blocks will often increase the chances of deadlocks occurring. Another reason for deadlock in a database table can be missing indexes. Link to comment Share on other sites More sharing options...
Recommended Posts