Last modified: 2012-10-17 04:41:10 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T29639, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 27639 - Transaction timeout when trying to OldLocalFile::upgradeRow()
Transaction timeout when trying to OldLocalFile::upgradeRow()
Status: REOPENED
Product: MediaWiki
Classification: Unclassified
File management (Other open bugs)
unspecified
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
http://fr.wikipedia.org/wiki/File:Sém...
:
Depends on:
Blocks: 28499
  Show dependency treegraph
 
Reported: 2011-02-22 18:42 UTC by Paul Marques Mota
Modified: 2012-10-17 04:41 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Paul Marques Mota 2011-02-22 18:42:29 UTC
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) ».
Comment 1 Paul Marques Mota 2011-02-22 18:46:18 UTC
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
Comment 2 Sam Reed (reedy) 2011-02-22 18:47:05 UTC
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'
Comment 3 Paul Marques Mota 2011-02-22 19:04:52 UTC
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)
Comment 4 Ivan d'Hostingue 2011-02-22 20:21:42 UTC
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.
Comment 5 Bryan Tong Minh 2011-02-23 10:58:51 UTC
Did this always happen for this specific file, or only sometimes?
Comment 6 Sam Reed (reedy) 2011-02-23 11:00:15 UTC
Not sure. Just noticed there's quite a few doing this from multiple wiki's in the DB error logs...
Comment 7 Ivan d'Hostingue 2011-02-23 14:41:14 UTC
(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.
Comment 8 Ivan d'Hostingue 2011-02-23 14:45:52 UTC
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.
Comment 9 Sam Reed (reedy) 2011-04-11 13:03:05 UTC
r85784
Comment 10 Sam Reed (reedy) 2011-04-12 20:30:38 UTC
Reverted in r85917

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links