Last modified: 2014-06-05 22:34:17 UTC
Jcb asked on irc to undelete some files. Me and odder both responded, I was faster at the first three, but the last one (https://commons.wikimedia.org/w/index.php?title=Special:Log&page=File%3AMaison+Morisset%2C+Sainte-Famille%2C+%C3%AEle+d%27Orl%C3%A9ans%2C+Qu%C3%A9bec+07.jpg) Odder was faster. I got this nice error. No layout or anything so it seems to come straight from php: """" A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: INSERT INTO `image` (img_name,img_size,img_width,img_height,img_metadata,img_bits,img_media_type,img_major_mime,img_minor_mime,img_description,img_user,img_user_text,img_timestamp,img_sha1) VALUES ('Maison_Morisset,_Sainte-Famille,_île_d\'Orléans,_Québec_07.jpg','183210','1092','768','a:1:{s:22:\"MEDIAWIKI_EXIF_VERSION\";i:2;}','8','BITMAP','image','jpeg','User created page with UploadWizard','57323','Benoit Rochon','20130103190436','429oa40hdi65he0dn1192er17m05fia') Function: LocalFileRestoreBatch::execute Error: 1213 Deadlock found when trying to get lock; try restarting transaction (10.64.32.29) """ Looks like odder and me triggered a race condition here.
Ah, looks like I had another one: """ A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: INSERT INTO `image` (img_name,img_size,img_width,img_height,img_metadata,img_bits,img_media_type,img_major_mime,img_minor_mime,img_description,img_user,img_user_text,img_timestamp,img_sha1) VALUES ('Maison_Morisset,_Sainte-Famille,_île_d\'Orléans,_Québec_05.jpg','258148','1090','782','a:1:{s:22:\"MEDIAWIKI_EXIF_VERSION\";i:2;}','8','BITMAP','image','jpeg','User created page with UploadWizard','57323','Benoit Rochon','20130103190430','o5qoold6r84zreonlw45thopk3tospz') Function: LocalFileRestoreBatch::execute Error: 1213 Deadlock found when trying to get lock; try restarting transaction (10.64.32.29) """
Also see bug 33292
So, now work was lost (the files were undeleted) just you ran into the error message, right, Maarten? The raw message isn't the nicest but let's just leave this as a normal priority for now.
Maarten: Could you answer comment 3?
(In reply to comment #3) > So, now work was lost (the files were undeleted) just you ran into the error > message, right, Maarten? The raw message isn't the nicest but let's just > leave > this as a normal priority for now. Only admins can undelete files and that doesn't happen a lot, let alone two admins trying to delete the same file at the same time. Normal is just fine.
Probably fixed in https://gerrit.wikimedia.org/r/#/c/136343/
Also https://gerrit.wikimedia.org/r/#/c/134502/
