Page MenuHomePhabricator

Transaction timeout when trying to OldLocalFile::upgradeRow()
Closed, ResolvedPublic

Description

Author: pmarquesmota

Description:
There's been a bug report of sorts on the french wikipedia:
http://fr.wikipedia.org/wiki/Wikipédia:Questions_techniques/semaine_8_2011#Impossible_d.27acc.C3.A9der_.C3.A0_une_page

Trying to access [[Fichier:Sémhur.svg]] on fr.wp results in the following error:
Une erreur de syntaxe de la requête dans la base de données est survenue. Ceci peut indiquer un bogue dans le logiciel. La dernière requête traitée par la base de données était :

(Requête SQL cachée)

depuis la fonction « OldLocalFile::upgradeRow ». La base de données a renvoyé l’erreur « 1205 : Lock wait timeout exceeded; Try restarting transaction (10.0.6.31) ».


Version: unspecified
Severity: normal
URL: http://fr.wikipedia.org/wiki/File:Sémhur.svg?uselang=en

Details

Reference
bz27639

Event Timeline

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

pmarquesmota wrote:

Using the HTTPSEverywhere extension with firefox, I have a 502 Proxy Error accessing https://secure.wikimedia.org/wikipedia/fr/wiki/Fichier:S%C3%A9mhur.svg:

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /wikipedia/fr/wiki/Fichier:Sémhur.svg.

Reason: Error reading from remote server

Tue Feb 22 18:41:28 UTC 2011 srv208 frwiki OldLocalFile::upgradeRow 10.0.6.32 1205 Lock wait timeout exceeded; try restarting transaction (10.0.6.32) UPDATE oldimage SET oi_width = '2000',oi_height = '1898',oi_bits = '0',oi_media_type = 'DRAWING',oi_major_mime = 'image',oi_minor_mime = 'svg+xml',oi_metadata = 'a:3:{s:5:\"width\";i:2000;s:6:\"height\";i:1898;s:7:\"version\";i:2;}',oi_sha1 = 'h1dn0eg1ktzhy6p7f7wjk7179xn7cbe' WHERE oi_name = 'Railway_stations_on_departure_from_Paris_map-fr.svg' AND oi_archive_name = '20110117222802!Railway_stations_on_departure_from_Paris_map-fr.svg'

pmarquesmota wrote:

See also user contributions from Sémhur:
http://fr.wikipedia.org/wiki/Spécial:Contributions/Sémhur?uselang=en

14:16, 21 February 2011 (diff | hist) Fichier:Sémhur.svg ‎ (a importé une nouvelle version de « Fichier:Sémhur.svg » : Troyes - grands quartiers 2001 - map-fr.svg) (top)

semhur wrote:

About this last contrib, I've done it "in hard" (I don't know if it's an english expression ;), uploading directly at this address : http://fr.wikipedia.org/w/index.php?title=Spécial:Téléverser&wpDestFile=Sémhur.svg&wpForReUpload=1

This picture isn't very important : it's just a repository for my work of wikigraphist. There are a lot of "old local file" in the History section. You can see another example here : http://fr.wikipedia.org/wiki/Fichier:Sémhur2.svg. May be one of this old versions was corrupted.

Bryan.TongMinh wrote:

Did this always happen for this specific file, or only sometimes?

Not sure. Just noticed there's quite a few doing this from multiple wiki's in the DB error logs...

semhur wrote:

(In reply to comment #5)

Did this always happen for this specific file, or only sometimes?

Yes, it seems to always do that for this file.

semhur wrote:

May be the bug exists for the files with more than X (50?) history local files. If I tried to navigate in the file history of http://fr.wikipedia.org/wiki/Fichier:Sémhur2.svg, I've got sometimes the same problem.

Krinkle claimed this task.
Krinkle subscribed.

In the last 30 days of Wikimedia production logs, no matches for Lock wait timeout exceeded with either "OldLocalFile" or "oi_major_mime". Presumed fixed.