Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
marklcfc Posted October 6, 2023 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
Marc Posted October 6, 2023 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.
marklcfc Posted October 6, 2023 Author Posted October 6, 2023 (edited) They are InnoDB. ibf_core_search_index is quite large in size Edited October 6, 2023 by marklcfc
Miss_B Posted October 6, 2023 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.
Recommended Posts