Last modified: 2005-06-09 17:48:07 UTC
Warning: mysql_query(): Unable to save result set in /usr/local/apache/common-local/php-1.4/includes/Database.php on line 349 A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "indexShowToplevel". MySQL returned error "1053: Server shutdown in progress (10.0.0.1)".
works for me, could be overloaded database response though.
I just got the same error on the same page. If it's an overload response, can the detection and reporting be improved? Or is it really a database server having to be shutdown urgently?
(In reply to comment #2) The reported IP address was 10.0.0.3, "Served by friedrich.wikimedia.org ...".
Warning: mysql_query(): Unable to save result set in /usr/local/apache/common-local/php-1.4/includes/Database.php on line 349 from within function "indexShowToplevel". MySQL returned error "1053: Server shutdown in progress (10.0.0.24)".
Yes, that's an overload issue. The long queries get killed and the error isn't handled well.
This "error" is returned as an html fragment: <br /> <b>Warning</b>: mysql_query(): Unable to save result set in <b>/usr/local/apache/common-local/php-1.4/includes/Database.php</b> on line <b>349</b><br /> Error in fetchObject(): MySQL server has gone away <p>Backtrace:</p> <ul> <li>GlobalFunctions.php line 513 calls wfbacktrace()</li> <li>Database.php line 505 calls wfdebugdiebacktrace()</li> <li>Database.php line 1466 calls databasemysql::fetchobject()</li> <li>LoadBalancer.php line 188 calls databasemysql::getstatus()</li> <li>LoadBalancer.php line 333 calls loadbalancer::getreaderindex()</li> <li>DatabaseFunctions.php line 52 calls loadbalancer::getconnection()</li> <li>MessageCache.php line 304 calls wfgetdb()</li> <li>MessageCache.php line 249 calls messagecache::getfromcache()</li> <li>GlobalFunctions.php line 435 calls messagecache::get()</li> <li>GlobalFunctions.php line 344 calls wfmsgreal()</li> <li>OutputPage.php line 620 calls wfmsg()</li> <li>Database.php line 386 calls outputpage::databaseerror()</li> <li>Database.php line 333 calls databasemysql::reportqueryerror()</li> <li>Database.php line 698 calls databasemysql::query()</li> <li>Database.php line 625 calls databasemysql::select()</li> <li>SpecialAllpages.php line 78 calls databasemysql::selectfield()</li> <li>SpecialAllpages.php line 29 calls indexshowtoplevel()</li> <li>SpecialPage.php line 305 calls wfspecialallpages()</li> <li>SpecialPage.php line 215 calls specialpage::execute()</li> <li>index.php line 101 calls specialpage::executepath()</li> </ul> This was from http://en.wikibooks.org/wiki/Special:Allpages but a few minutes previously it was returning the more common "(SQL query hidden)" variant without the backtrace. See bug 1109#c11 for another "gone away" error with a backtrace from "action=submit" on sl.wikipedia.org.
