Add-ons Deadlock Avoidance by Xon 1.0.21

[XenBot]

XenBot submitted a new resource:

Deadlock Avoidance by Xon - Workarounds for sporadic deadlocks on busy forums

XenForo's Datawriters have a _postSaveAfterTransaction() method. This method is intended to run after a database transaction is finished, but if a DataWriter is called from with-in another DataWriter, this does not happen.

This incurs the risk that various notification actions will pull in large queries into the transaction, which increasing the risk of deadlocks on a busy forum.

This is a formally private add-on which has been in use for about a month before being released.

This add-on...

Read more about this resource...

 

[XenBot]

XenBot updated Deadlock Avoidance by Xon with a new update entry:

Deadlock Avoidance by Xon 1.0.21

• Remove use of get_lock which is unsupported in galera clustering, and causes errors in Percona XtraDB Cluster.

Read the rest of this update entry...