Error when saving new permissions

[marklcfc]

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 Stridgen]

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]

They are InnoDB.

ibf_core_search_index is quite large in size

Edited October 6, 2023 by marklcfc

[Miss_B]

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.