Wierd, this is definitely updating the forum last post counters as expected on my forums. It is possible the SQL has some MySQL-ism's which don't work on all versions of MySQL, or my logic is just broken.
- Tweak SQL to ensure forum last post stats updates as expected.
- Note; by design the last post may not update all the time, but on average isn't noticeable on a active forum.
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Сгенерирована пользователем: SKREAMEX, Вчера, в 22:19
Трассировка стэка
#0 /library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /library/XenForo/Model/Conversation.php(1050): Zend_Db_Adapter_Abstract->query('\r\n\t\t\t\t\t\tUPDATE ...', Array)
#3 /library/XenForo/DataWriter/ConversationMaster.php(357): XenForo_Model_Conversation->addConversationReplyToRecipients(Array, Array, Array)
#4 /library/XenForo/DataWriter.php(1423): XenForo_DataWriter_ConversationMaster->_postSave()
#5 /library/SV/DeadlockAvoidance/XenForo/DataWriter/ConversationMaster.php(11): XenForo_DataWriter->save()
#6 /library/XenForo/DataWriter/ConversationMessage.php(185): SV_DeadlockAvoidance_XenForo_DataWriter_ConversationMaster->save()
#7 /library/XenForo/DataWriter.php(1423): XenForo_DataWriter_ConversationMessage->_postSave()
#8 /library/SV/DeadlockAvoidance/XenForo/DataWriter/ConversationMessage.php(11): XenForo_DataWriter->save()
#9 /library/XenForo/ControllerPublic/Conversation.php(1441): SV_DeadlockAvoidance_XenForo_DataWriter_ConversationMessage->save()
#10 /library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Conversation->actionInsertReply()
#11 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /index.php(13): XenForo_FrontController->run()
#13 {main}
your addon is very good and reduces a big amount of deadlocks, but can you make a paid addon with this fix or give advice about solving this problem?@grisha2217 this add-on doesn't change when addConversationReplyToRecipients is called as such it can deadlock sometimes which is just an XF1.x design issue. Due to other commitments, I'm not actively developing this add-on.
This add-on shouldn't be required in XF2.x.
- Fix deleting a post in a thread not updating the forum last post
- Fix Out of range value for column 'discussion_count' error
- Improve reliability of updating forum's last post so it doesn't sometimes include very old threads
I've got most of those add-ons plus this one without an issue. That said, troubleshooting non-delivered alerts is a pain.
- Remove use of get_lock which is unsupported in galera clustering, and causes errors in Percona XtraDB Cluster.
Xon updated Deadlock Avoidance by Xon with a new update entry:
1.0.21 - Maintenance update
Read the rest of this update entry...
This add-on isn't needed for XF2, if something is running alerts inside a transaction then it a bug.Is there a Release for 2.1.x ?
Use the Redis cache backend, and the issue with MySQL deadlocks will go away. Please post in correct add-on thread for any actual troubleshootingMy Problem, i have deadlocks with
2 or 3 times in 24 hrs.User Activity by Xon
Displays user activity below content. Supported content: Threads Conversations Reports NixFifty's Tickets NixFifty's Calendar It is recommended (but not required) that Redis Cache add-on be installed and configured as the cache provider...xenforo.com
We use essential cookies to make this site work, and optional cookies to enhance your experience.