Page MenuHomePhabricator

http://en.wikipedia.org/wiki/Special:Allpages not working
Closed, DeclinedPublic

Description

Author: guriluzi82-bugzillawikimediaorg2005

Description:
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)".


Version: unspecified
Severity: normal

Details

Reference
bz2159

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 8:28 PM
bzimport set Reference to bz2159.
bzimport added a subscriber: Unknown Object (MLST).

works for me, could be overloaded database response though.

zigger wrote:

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?

zigger wrote:

(In reply to comment #2)
The reported IP address was 10.0.0.3, "Served by friedrich.wikimedia.org ...".

avarab wrote:

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.

zigger wrote:

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.