I'm experiencing the following error multiple times per day:
I'm running VB5.4.5 on a VPS; PHP version 7.2.11; MySQL
The Forum was migrated from VB4.2.5. At the time of migration the MySQL version was 5.6.34. These types of errors began immediately after taking the Forum live. As a result, I had my ISP move the database to MySQL version
Code:
/** saveDbCache */REPLACE INTO vb_cacheevent (cacheid, event) values ('getSearchResults_8694f35f08bcfadeaf4f978b93d6f52a','perms_changed'), ('getSearchResults_8694f35f08bcfadeaf4f978b93d6f52a','vB_ChannelStructure_chg'), ('getSearchResults_8694f35f08bcfadeaf4f978b93d6f52a','vB_SearchResults_chg_0'), ('getSearchResults_8694f35f08bcfadeaf4f978b93d6f52a','nodeChg_11641'), ('vBAtchmnts_309032','nodeChg_309032'), ('vBAtchmnts_309040','nodeChg_309040'), ('node_309032_lvl3data','nodeChg_309032'), ('node_309040_lvl3data','nodeChg_309040'), ('node_309032_lvl1data','nodeChg_309032'), ('node_309040_lvl1data','nodeChg_309040'), ('vBUserRep_63230','fUserContentChg_63230'), ('vBUserRep_63230','userChg_63230'), ('node_641272_lvl1data','nodeChg_641272'), ('node_641787_lvl1data','nodeChg_641787'), ('node_641578_lvl1data','nodeChg_641578'), ('node_641572_lvl1data','nodeChg_641572'), ('node_641495_lvl1data','nodeChg_641495'), ('node_641447_lvl1data','nodeChg_641447'), ('node_641609_lvl1data','nodeChg_641609'), ('node_641376_lvl1data','nodeChg_641376'), ('node_641353_lvl1data','nodeChg_641353'), ('node_641293_lvl1data','nodeChg_641293'), ('node_641288_lvl1data','nodeChg_641288'), ('vbPre_conversation114.98.38.11641',''); MySQL Error : Lock wait timeout exceeded; try restarting transaction Error Number : 1205 Request Date : Thursday, January 10th 2019 @ 07:06:14 AM Error Date : Thursday, January 10th 2019 @ 07:07:07 AM Script : https://organforum.com/forums/forum/organ-building-repair-restoration/electronic-organs/11641-music-mate-portable-suitcase-organ Referrer : IP Address : 180.76.15.152 Username : Guest Classname : vB_Database_MySQLi MySQL Version : Stack Trace: #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1203 #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201 #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 557 #3 vB_Database->query_write() called in [path]/vb/db/mysql/querydefs.php on line 7328 #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 301 #6 vB_dB_Assertor->assertQuery() called in [path]/vb/cache/db.php on line 390 #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 486 #9 vB::shutdown() called in on line
5.7.24-log
The Forum was migrated from VB4.2.5. At the time of migration the MySQL version was 5.6.34. These types of errors began immediately after taking the Forum live. As a result, I had my ISP move the database to MySQL version
5.7.24 for better performance. That had no affect on the frequency of the errors. Before the error occurs, the Forum response becomes very sluggish to the point of becoming unusable. Clearing the cache in AdminCP or truncating the cacheevent table restores performance and quiets the errors for a time. If no action is taken, the errors increase in frequency, eventually preventing pages from loading at all.
I can take the queries that error out and run them remotely and they execute in fractions of a second without errors. This also restores performance.
I realize this appears to be a server performance issue, but the fact that it has occurred on two different servers running different versions of MySQL has me scratching my head.
innodb_lock_wait_timeout = 50. Engine is innodb. Row format is Dynamic. Memcache is not an option.I can take the queries that error out and run them remotely and they execute in fractions of a second without errors. This also restores performance.
I realize this appears to be a server performance issue, but the fact that it has occurred on two different servers running different versions of MySQL has me scratching my head.
Any ideas on how to fix this?
Comment