Awhile back I had an issue with my site being slow and my database going away. I was getting hundreds of emails regarding the issue. At the time, through a ticket (ID#2320324) it was discovered that "With the developer's help, it appears that your Latest Articles module on the front page is causing the issue. I set the date range to look back 45 days for newest articles. This shouldn't change the current display but your last articles were in the first week of April so they will drop off soon."



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...