Jump to content

Recommended Posts

Posted

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

Could contain: File, Webpage, Page, Text

Posted

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.

Posted

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. 

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...