https://bugzilla.wikimedia.org/show_bug.cgi?id=32551
Web browser: ---
Bug #: 32551
Summary: Descriptionless files
Product: MediaWiki
Version: 1.18
Platform: All
URL: http://commons.wikimedia.org/w/index.php?title=Commons
:Administrators%27_noticeboard&oldid=62820408#System_p
roblems
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: platoni...@gmail.com
Classification: Unclassified
A number of files appeared on commons on 15th with no description (may or may
not have page entry)
http://commons.wikimedia.org/w/index.php?title=Commons:Administrators%27_noticeboard&oldid=62820408#System_problems
select img_name, img_timestamp, rev_timestamp, page_latest, rev_timestamp -
img_timestamp from image left join page on (page_title=img_name and
page_namespace=6) left join revision on (reV_page = page_id and rev_parent_id =
0) where img_timestamp >= '20111114233531' limit 7;
+------------------------------------------------+----------------+----------------+-------------+-------------------------------+
| img_name | img_timestamp |
rev_timestamp | page_latest | rev_timestamp - img_timestamp |
+------------------------------------------------+----------------+----------------+-------------+-------------------------------+
| La_playAaAa.png | 20111114233642 |
20111120142847 | 62765918 | 5909205 | (description
created later)
| Bruxelles_Java_Masque_Wayang_02_10_2011_06.jpg | 20111114233723 | NULL
| 0 | NULL |
| Raonic_and_Youzhny.jpg | 20111114233732 | NULL
| NULL | NULL |
| Darcy's_gravesite_in_SE_Dijon_(France).jpg | 20111114233911 |
20111120142313 | 62765628 | 5908402 | (description
created later)
| Defeater-lost-ground-album-cover.jpg | 20111114233944 | NULL
| 0 | NULL |
| Jaguar_Sentado.jpg | 20111114234008 | NULL
| NULL | NULL |
| Phil_Bryant.jpg | 20111114234008 | NULL
| NULL | NULL |
+------------------------------------------------+----------------+----------------+-------------+-------------------------------+
The timing matches with the update of external storage servers
https://blog.wikimedia.org/2011/11/18/nobody-notices-when-its-not-broken-new-database-servers-deployed/
I think this is due to the image upload nested transactions, which break the
outer transactions. See
http://thread.gmane.org/gmane.science.linguistics.wikipedia.technical/49500
When the servers were switched, the second half transaction for those files
would have failed and half-rollbacked.
We already suffered this kind of failures in the past, see bug 15430, bug
20744, bug 24978. Seems that each ~12 months we suffer one of those. It should
finally be fixed.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
