Last modified: 2014-02-18 15:31:53 UTC
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?
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!
