After migration from 3.X to 5.X I've been cleaning up a decent amount of database errors and optimizing the forum as much as possible. I still see Cache Event issues occasionally which require a MySQL Bump to resolve, however, the main one now is after we have migrated over to Sphinx Search. Getting a ton of these throughout the day, although search is working fine from what I can tell.
Database error in vBulletin 5.6.0:
Invalid SQL:
UPDATE r3vdb SET starterlastcontent = 1586883498, startertextcount = 285 WHERE starter = 383320;
MySQL Error : index 'r3vdb': concurrent OPTIMIZE (or ALTER etc) is running; UPDATE timed out; please retry
Error Number : 1064
Request Date : Tuesday, April 14th 2020 @ 09:58:18 AM
Error Date : Tuesday, April 14th 2020 @ 09:58:26 AM
Script : https://www.r3vlimited.com/board/create-content/text/
Referrer : https://www.r3vlimited.com/board/for...toration/page8
IP Address : 8.36.116.204
Username : 2mAn
Classname : vBSphinxSearch_Connection
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]\packages\vbsphinxsearch\core.php on line 164
#4 vBSphinxSearch_Core->propagateStarterInheritedFields() called in [path]\packages\vbsphinxsearch\core.php on line 367
#5 vBSphinxSearch_Core->attributeChanged() called in [path]\vb\library\search.php on line 57
#6 vB_Library_Search->attributeChanged() called in [path]\vb\library\node.php on line 5455
#7 vB_Library_Node->updateParentCountsList() called in [path]\vb\library\node.php on line 5399
#8 vB_Library_Node->updateParentCounts() called in [path]\vb\library\content.php on line 1003
#9 vB_Library_Content->afterAdd() called in [path]\vb\library\content\text.php on line 778
#10 vB_Library_Content_Text->add() called in [path]\vb\api\content\text.php on line 172
#11 vB_Api_Content_Text->add() called in [path]\vb\api\wrapper.php on line 201
#12 vB_Api_Wrapper->__call() called in C:\inetpub\wwwroot\R3VLimited.com\board\includes\api\interface\collapsed.php on line 101
#13 Api_Interface_Collapsed->callApi() called in C:\inetpub\wwwroot\R3VLimited.com\board\includes\vb5\frontend\controller\createcontent.php on line 446
#14 vB5_Frontend_Controller_CreateContent->createNewNode() called in C:\inetpub\wwwroot\R3VLimited.com\board\includes\vb5\frontend\controller\createcontent.php on line 296
#15 vB5_Frontend_Controller_CreateContent->actionTextNodeInternal() called in C:\inetpub\wwwroot\R3VLimited.com\board\includes\vb5\frontend\controller\createcontent.php on line 186
#16 vB5_Frontend_Controller_CreateContent->index() called in C:\inetpub\wwwroot\R3VLimited.com\board\index.php on line 74
Database error in vBulletin 5.6.0:
Invalid SQL:
UPDATE r3vdb SET starterlastcontent = 1586883498, startertextcount = 285 WHERE starter = 383320;
MySQL Error : index 'r3vdb': concurrent OPTIMIZE (or ALTER etc) is running; UPDATE timed out; please retry
Error Number : 1064
Request Date : Tuesday, April 14th 2020 @ 09:58:18 AM
Error Date : Tuesday, April 14th 2020 @ 09:58:26 AM
Script : https://www.r3vlimited.com/board/create-content/text/
Referrer : https://www.r3vlimited.com/board/for...toration/page8
IP Address : 8.36.116.204
Username : 2mAn
Classname : vBSphinxSearch_Connection
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]\packages\vbsphinxsearch\core.php on line 164
#4 vBSphinxSearch_Core->propagateStarterInheritedFields() called in [path]\packages\vbsphinxsearch\core.php on line 367
#5 vBSphinxSearch_Core->attributeChanged() called in [path]\vb\library\search.php on line 57
#6 vB_Library_Search->attributeChanged() called in [path]\vb\library\node.php on line 5455
#7 vB_Library_Node->updateParentCountsList() called in [path]\vb\library\node.php on line 5399
#8 vB_Library_Node->updateParentCounts() called in [path]\vb\library\content.php on line 1003
#9 vB_Library_Content->afterAdd() called in [path]\vb\library\content\text.php on line 778
#10 vB_Library_Content_Text->add() called in [path]\vb\api\content\text.php on line 172
#11 vB_Api_Content_Text->add() called in [path]\vb\api\wrapper.php on line 201
#12 vB_Api_Wrapper->__call() called in C:\inetpub\wwwroot\R3VLimited.com\board\includes\api\interface\collapsed.php on line 101
#13 Api_Interface_Collapsed->callApi() called in C:\inetpub\wwwroot\R3VLimited.com\board\includes\vb5\frontend\controller\createcontent.php on line 446
#14 vB5_Frontend_Controller_CreateContent->createNewNode() called in C:\inetpub\wwwroot\R3VLimited.com\board\includes\vb5\frontend\controller\createcontent.php on line 296
#15 vB5_Frontend_Controller_CreateContent->actionTextNodeInternal() called in C:\inetpub\wwwroot\R3VLimited.com\board\includes\vb5\frontend\controller\createcontent.php on line 186
#16 vB5_Frontend_Controller_CreateContent->index() called in C:\inetpub\wwwroot\R3VLimited.com\board\index.php on line 74
Comment