Page MenuHomePhabricator

commonswiki globalimagelinks table slow
Closed, ResolvedPublic

Description

A simple SQL query that used to run in seconds now hangs around until it fails with a server timeout.

First noticed on 2014-02-17, but may have appeared earlier.

Example query:

SELECT globalimagelinks.* FROM globalimagelinks,page,categorylinks WHERE gil_to=page_title AND cl_from=page_id AND page_namespace=6 AND cl_to IN ('Media_from_Beeld_en_Geluid_Wiki');

Maybe a dropped index somewhere? Or related to the recent nfs fails?


Version: unspecified
Severity: major

Details

Reference
bz61480

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:01 AM
bzimport set Reference to bz61480.
bzimport added a subscriber: Unknown Object (MLST).

Update: The query now completed, in 32 minutes. This is still much (!) longer than it used to take.

Huh. Now it works. Did someone fix it?

Well, it's broken somewhere else now:

PHP Warning: mysqli::mysqli(): (HY000/2003): Can't connect to MySQL server on 'commonswiki.labsdb' (110)

Update: database connection works when script run from shell or webserver; dies with above error when run via jsub.

Now all works as it should. Self-healing Labs FTW!