I started getting these errors again. Had not seen them for some time.
See improvement request:
https://tracker.vbulletin.com/vbulletin5/issues/VBV-19851
Database error in vBulletin 5.6.4:
Invalid SQL:
/** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
('node_96452_lvl1data','nodeChg_96452'),
('node_96443_lvl1data','nodeChg_96443'),
('node_96195_lvl1data','nodeChg_96195'),
('node_95965_lvl1data','nodeChg_95965'),
('node_95931_lvl1data','nodeChg_95931'),
('node_95903_lvl1data','nodeChg_95903'),
('node_95894_lvl1data','nodeChg_95894'),
('node_95813_lvl1data','nodeChg_95813'),
('node_95759_lvl1data','nodeChg_95759'),
('node_95512_lvl1data','nodeChg_95512'),
...
('node_64522_lvl1data','nodeChg_64522'),
('node_64444_lvl1data','nodeChg_64444'),
('node_64435_lvl1data','nodeChg_64435'),
('node_64249_lvl1data','nodeChg_64249'),
('node_64229_lvl1data','nodeChg_64229');
MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Wednesday, February 24th 2021 @ 02:23:18 PM
Error Date : Wednesday, February 24th 2021 @ 02:23:19 PM
Script :
Referrer :
IP Address : 64.91.XXX.XX
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1214
#1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
#2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 568
#3 vB_Database->query_write() called in phar://[path]/vb/vb.phar/db/mysql/querydefs.php on line 7447
#4 vB_dB_MYSQL_QueryDefs->saveDbCache() called in phar://[path]/vb/vb.phar/db/query/method.php on line 68
#5 vB_dB_Query_Method->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293
#6 vB_dB_Assertor->assertQuery() called in phar://[path]/vb/vb.phar/cache/db.php on line 387
#7 vB_Cache_Db->shutdown() called in phar://[path]/vb/vb.phar/shutdown.php on line 93
#8 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 479
#9 vB::shutdown() called in on line
See improvement request:
https://tracker.vbulletin.com/vbulletin5/issues/VBV-19851
Database error in vBulletin 5.6.4:
Invalid SQL:
/** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
('node_96452_lvl1data','nodeChg_96452'),
('node_96443_lvl1data','nodeChg_96443'),
('node_96195_lvl1data','nodeChg_96195'),
('node_95965_lvl1data','nodeChg_95965'),
('node_95931_lvl1data','nodeChg_95931'),
('node_95903_lvl1data','nodeChg_95903'),
('node_95894_lvl1data','nodeChg_95894'),
('node_95813_lvl1data','nodeChg_95813'),
('node_95759_lvl1data','nodeChg_95759'),
('node_95512_lvl1data','nodeChg_95512'),
...
('node_64522_lvl1data','nodeChg_64522'),
('node_64444_lvl1data','nodeChg_64444'),
('node_64435_lvl1data','nodeChg_64435'),
('node_64249_lvl1data','nodeChg_64249'),
('node_64229_lvl1data','nodeChg_64229');
MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Wednesday, February 24th 2021 @ 02:23:18 PM
Error Date : Wednesday, February 24th 2021 @ 02:23:19 PM
Script :
Referrer :
IP Address : 64.91.XXX.XX
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1214
#1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
#2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 568
#3 vB_Database->query_write() called in phar://[path]/vb/vb.phar/db/mysql/querydefs.php on line 7447
#4 vB_dB_MYSQL_QueryDefs->saveDbCache() called in phar://[path]/vb/vb.phar/db/query/method.php on line 68
#5 vB_dB_Query_Method->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293
#6 vB_dB_Assertor->assertQuery() called in phar://[path]/vb/vb.phar/cache/db.php on line 387
#7 vB_Cache_Db->shutdown() called in phar://[path]/vb/vb.phar/shutdown.php on line 93
#8 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 479
#9 vB::shutdown() called in on line
Comment