Resource icon

xF1 Add-on Deadlock Avoidance by Xon 1.0.21

No permission to download
Compatible XF Versions
  1. 1.4
  2. 1.5
Additional Requirements
php +5.5
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 is only for busy forums which sometimes experience deadlocks on the listed conditions. Please test carefully as this add-on may break other add-ons.

This add-on requires php +5.5, and will not work with earlier versions.

  • Race condition for watch thread toggle
  • Deadlock on conversations
  • Deadlock on posts
  • Deadlock on resolving/rejecting Reports

Race condition for watch thread toggle

Fixes a race condition when creating/removing a watch thread state

Deadlock on conversations

Provides a workaround for a XenForo design issue where updating conversation counters can cause deadlocks.
  • rebuilding user conversation counters occurs inside a large transaction, and is deadlock prone.

Deadlock on posts

Provides a workaround for a XenForo design issue where adding/removing posts can cause deadlocks.
  • updating user alert counters occurs inside a large transaction, and is deadlock prone.

Deadlock on resolving/rejecting Reports
Provides a workaround for a XenForo design issue where adding/removing posts can cause deadlocks.
  • Sends report resolve/reject alerts inside the transaction.
Author
AnimeHaxor
Size
18.6 KB
Extension
zip
Downloads
21
Views
913
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from AnimeHaxor

Latest updates

  1. 1.0.21 - Maintenance update

    Remove use of get_lock which is unsupported in galera clustering, and causes errors in Percona...
  2. Bugfix update

    Improve reliability of updating forum's last post so it doesn't sometimes include very old threads
  3. 1.0.19 - Bugfix update

    Fix deleting a post in a thread not updating the forum last post Fix Out of range value for...

Similar resources

Alert Improvements by Xon AnimeHaxor
A collection of minor improvements to the XenForo Alerts system.
0.00 star(s) 0 ratings
Downloads
73
Updated
A collection of improvements to XF's attachment system
0.00 star(s) 0 ratings
Downloads
15
Updated
A collection of improvements to the XenForo Conversation system.
0.00 star(s) 0 ratings
Downloads
37
Updated
A few new conversation permissions (reply based)
0.00 star(s) 0 ratings
Downloads
0
Updated
Adds conversation search to the search system, with options to search by recipient
0.00 star(s) 0 ratings
Downloads
3
Updated
AdBlock Detected

We get it, advertisements are annoying!

Sure, ad-blocking software does a great job at blocking ads, but it also blocks useful features of our website. For the best site experience please disable your AdBlocker.

I've Disabled AdBlock