Fast forward to today. All of a sudden I am getting over 100 emails over night and about another 100+ during the day stating that my database has disappeared. No idea why the idea has started back up, or what is causing it out of the blue?
This is what I am getting in the email below (each email I get follows the same template but links to a different url on the site):
Database error in vBulletin 5.6.1:
Invalid SQL:
/** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
('getSearchResults_22023dc7065e796ef1ade38ecf125da 8','perms_changed'),
('getSearchResults_22023dc7065e796ef1ade38ecf125da 8','vB_ChannelStructure_chg'),
('getSearchResults_22023dc7065e796ef1ade38ecf125da 8','vB_SearchResults_chg_0'),
('getSearchResults_22023dc7065e796ef1ade38ecf125da 8','nodeChg_98617');
MySQL Error : Lock wait timeout exceeded; try restarting transaction
Error Number : 1205
Request Date : Monday, December 7th 2020 @ 01:56:10 AM
Error Date : Monday, December 7th 2020 @ 01:57:02 AM
Script : https://www.camarov6.com/forum/techn...seal?p=1361235
Referrer :
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 561
#3 vB_Database->query_write() called in [path]/vb/db/mysql/querydefs.php on line 7323
#4 vB_dB_MYSQL_QueryDefs->saveDbCache() called in [path]/vb/db/query/method.php on line 175
#5 vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 293
#6 vB_dB_Assertor->assertQuery() called in [path]/vb/cache/db.php on line 387
#7 vB_Cache_Db->shutdown() called in [path]/vb/shutdown.php on line 93
#8 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 483
#9 vB::shutdown() called in on line
Obviously I can't be getting over 200 emails a day regarding this and I don't want it to impact performance of the site either- but nothing has been updated on the backend with vbulletin since it was resolved back in April I think it was? What could be causing this issue and how can I go about resolving it?
Devami...