Database error in search module

[David Karol]

Occurring in 'Recent Discussions' module, in side bar, at site. I woke up to the database error is after ~15 hours of traffic on vB 5 live site, after no changes to the search module.

Error Invalid SQL: SELECT node.nodeid FROM node as node JOIN sr_closure AS closure USE INDEX (child) ON node.nodeid = closure.child WHERE node.contenttypeid = '30' AND closure.parent IN ('18','19','20','25','30','21','26','23','24','27','28') AND node.nodeid <> closure.parent AND node.inlist = 1 AND node.contenttypeid <> '22' ORDER BY node.created DESC,node.nodeid ASC LIMIT 500 /**getSearchResults**/;

I don't see any issues in mysql/error.log

[David Karol]

Now this will show on the home page, site is down with typical users seeing "database error"

Error :API Error
Controller: search
Method: getInitialResults
Error(s):
array (
0 => 'Error Invalid SQL:

REPLACE INTO sr_searchlog
(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,json,resu lts,results_count)
VALUES
(\'0\',\'3\',\'ip\',\'4951d4e12d3ada164eab0ad75096e353\',\'displayorder\',\'a sc\',\'0.0021591186523438\',\'1462739803\',\'0\',\'{"type":"vBForum_Channel","sort": {"displayorder":"ASC"},"channel":"2","depth":"1"}\',\'14,15,17,16\',\'4\');' ,
1 =>
array (
0 => 'exception_trace',
1 => '## */core/vb/database.php(1247) Exception Thrown
#0 */core/vb/database/mysqli.php(176): vB_Database->halt()
#1 */core/vb/database.php(506): vB_Database_MySQLi->execute_query(true, Object(mysqli))
#2 */core/packages/vbdbsearch/db/mysql/querydefs.php(664): vB_Database->query_write(\'\\n\\t\\t\\tREPLACE INT...\')
#3 */core/vb/db/query/method.php(175): vBDBSearch_dB_MYSQL_QueryDefs->cacheResults(Array, Object(vB_Database_MySQLi), false, false)
#4 */core/vb/db/assertor.php(283): vB_dB_Query_Method->execSQL()
#5 */core/vb/search/core.php(283): vB_dB_Assertor->assertQuery(\'vBDBSearch:cach...\', Array)
#6 */core/vb/api/search.php(163): vB_Search_Core->cacheResults(Array, Object(vB_Search_Criteria), 0.0021591186523438, 0)
#7 */core/vb/api/search.php(127): vB_Api_Search->getSearchResultsCriteria(Object(vB_Search_Criteria), 0)
#8 */core/vb/api/search.php(215): vB_Api_Search->getSearchResult(\'{"channel":"2",...\', 0)
#9 [internal function]: vB_Api_Search->getInitialResults(Array, \'999\', \'1\', \'0\')
#10 */core/vb/api/wrapper.php(129): call_user_func_array(Array, Array)
#11 [internal function]: vB_Api_Wrapper->__call(\'getInitialResul...\', Array)
#12 [internal function]: vB_Api_Wrapper->getInitialResults(Array, \'999\', \'1\', \'0\')
#13 */includes/api/interface/collapsed.php(201): call_user_func_array(Array, Array)
#14 */includes/vb5/template/runtime.php(506): Api_Interface_Collapsed->callApi(\'search\', \'getInitialResul...\', Array, false, true)
#15 */core/cache/template/template20263.php(144): vB5_Template_Runtime:arseData(\'search\', \'getInitialResul...\', Array, \'999\', \'1\', \'0\')
#16 */includes/vb5/template.php(330): include(\'/home/x/www/s...\')
#17 */includes/vb5/template/cache.php(134): vB5_Template->render(false)
#18 */includes/vb5/template.php(346): vB5_Template_Cache->replacePlaceholders(\'\\r\\n\\t\\r\\n\\t\\r\\n\\t\\r\\n\\t\\r\\n\\t...\')
#19 */includes/vb5/template/cache.php(134): vB5_Template->render(false)
#20 */includes/vb5/template.php(346): vB5_Template_Cache->replacePlaceholders(\'<!-- ##template...\')
#21 */includes/vb5/frontend/controller/page.php(245): vB5_Template->render()
#22 [internal function]: vB5_Frontend_Controller_Page->index(13, 13, 13, \'$pagenum\', 163, \'Sound Forums Ne...\', 1, \'/external?type=...\', \'Above The Fold\', 1)
#23 */index.php(86): call_user_func_array(Array, Array)
#24 {main}',
),
)

on line 510 in */includes/vb5/template/runtime.php
Step 0: showErrorPage() called on line 215 in */includes/vb5/applicationabstract.php
Step 1: handleException() called
Exception API Error
Controller: search
Method: getInitialResults
Error(s):
array (
0 =>
array (
0 => 'invalid_search_resultid',
),
)

on line 510 in */includes/vb5/template/runtime.php

[David Karol]

Restarting mysql service resolved front page issue. Search module database error still persists.

[Mark.B]

The site is in debug mode...does the error persist if you take out of debug mode?

[David Karol]

Mark,

To get out of debug mode, is the only setting located in /core/includes/config.php?
Debug mode still persists with

$config['Misc']['debug'] = true;

commented out.

Note that the site has continuously been in debug mode for the past day.

[David Karol]

Could this have been related to /tmp being out of space. For some reason, the available space there was 1MB. After rebooting the server, this is back to normal, and no database error occurs.