Author: saibotrash
Description:
from bug 34993
"The missing files should still be floating around on NFS. The metadata in the
DB row right now for the effected files must be incorrect. This would need to
be located and manually fixed. This may warrant a separate shell bug."
Version: unspecified
Severity: major
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=34993
Since there appears to be now way to get the username/comment back, these new changes to the affected files will be reverted by moving current file versions to a lost+found location and moving the archived version (with the sha1 matching the current version img_sha1 value) will be moved back over the current file name.
People should avoiding editing the files in the list above. A notification will be given, linking to the lost+found files (publicly viewable) so the authors can re-upload their files properly.
(In reply to comment #2)
Since there appears to be now way...
That should be "no way", sigh.
Of the 341 files, only about 10 of them are known to have the metadata loss problem. The others had various other classes of bugs that I fixed in the DB already.
Dry run reveals the following affected files:
Klejs_kirke_(Hedensted).JPG
கலவி.JPG
Bundesarchiv_Bild_146-1978-043-13,_Erwin_v._Witzleben.jpg
Astronomystuff6.JPG
Sir_Arthur_Wellesley,_1st_Duke_of_Wellington.png
Straitsman_Ferry.JPG
The_Dorothy.jpg
Costa_Iloca.JPG
Klejtrup_kirke_(Viborg).JPG
Anoop_jacob.jpg
The orphaned files for these will have to displace the current file version (which will be dumped somewhere).
I just cleaned up the above files. From the move output dump (<target> <destination>):
/mnt/upload6/wikipedia/commons/0/0f/Klejs_kirke_(Hedensted).JPG /mnt/upload6/wikipedia/commons/lost+found/Klejs_kirke_(Hedensted).JPG
/mnt/upload6/wikipedia/commons/archive/0/0f/20120210150130!Klejs_kirke_(Hedensted).JPG /mnt/upload6/wikipedia/commons/0/0f/Klejs_kirke_(Hedensted).JPG
/mnt/upload6/wikipedia/commons/3/3b/கலவி.JPG /mnt/upload6/wikipedia/commons/lost+found/கலவி.JPG
/mnt/upload6/wikipedia/commons/archive/3/3b/20120223114448!கலவி.JPG /mnt/upload6/wikipedia/commons/3/3b/கலவி.JPG
/mnt/upload6/wikipedia/commons/6/61/Astronomystuff6.JPG /mnt/upload6/wikipedia/commons/lost+found/Astronomystuff6.JPG
/mnt/upload6/wikipedia/commons/archive/6/61/20120222024521!Astronomystuff6.JPG /mnt/upload6/wikipedia/commons/6/61/Astronomystuff6.JPG
/mnt/upload6/wikipedia/commons/8/83/Sir_Arthur_Wellesley,_1st_Duke_of_Wellington.png /mnt/upload6/wikipedia/commons/lost+found/Sir_Arthur_Wellesley,_1st_Duke_of_Wellington.png
/mnt/upload6/wikipedia/commons/archive/8/83/20120106182846!Sir_Arthur_Wellesley,_1st_Duke_of_Wellington.png /mnt/upload6/wikipedia/commons/8/83/Sir_Arthur_Wellesley,_1st_Duke_of_Wellington.png
/mnt/upload6/wikipedia/commons/a/a0/Straitsman_Ferry.JPG /mnt/upload6/wikipedia/commons/lost+found/Straitsman_Ferry.JPG
/mnt/upload6/wikipedia/commons/archive/a/a0/20120211225510!Straitsman_Ferry.JPG /mnt/upload6/wikipedia/commons/a/a0/Straitsman_Ferry.JPG
/mnt/upload6/wikipedia/commons/b/b2/The_Dorothy.jpg /mnt/upload6/wikipedia/commons/lost+found/The_Dorothy.jpg
/mnt/upload6/wikipedia/commons/archive/b/b2/20120304181824!The_Dorothy.jpg /mnt/upload6/wikipedia/commons/b/b2/The_Dorothy.jpg
/mnt/upload6/wikipedia/commons/c/c7/Costa_Iloca.JPG /mnt/upload6/wikipedia/commons/lost+found/Costa_Iloca.JPG
/mnt/upload6/wikipedia/commons/archive/c/c7/20120228083043!Costa_Iloca.JPG /mnt/upload6/wikipedia/commons/c/c7/Costa_Iloca.JPG
/mnt/upload6/wikipedia/commons/f/f2/Klejtrup_kirke_(Viborg).JPG /mnt/upload6/wikipedia/commons/lost+found/Klejtrup_kirke_(Viborg).JPG
/mnt/upload6/wikipedia/commons/archive/f/f2/20120210150600!Klejtrup_kirke_(Viborg).JPG /mnt/upload6/wikipedia/commons/f/f2/Klejtrup_kirke_(Viborg).JPG
/mnt/upload6/wikipedia/commons/f/f6/Anoop_jacob.jpg /mnt/upload6/wikipedia/commons/lost+found/Anoop_jacob.jpg
/mnt/upload6/wikipedia/commons/archive/f/f6/20120306132222!Anoop_jacob.jpg /mnt/upload6/wikipedia/commons/f/f6/Anoop_jacob.jpg
Add to that:
/mnt/upload6/wikipedia/commons/4/42/Bundesarchiv_Bild_146-1978-043-13,_Erwin_v._Witzleben.jpg /mnt/upload6/wikipedia/commons/lost+found/Bundesarchiv_Bild_146-1978-043-13,_Erwin_v._Witzleben.jpg
/mnt/upload6/wikipedia/commons/archive/4/42/20120305190225!Bundesarchiv_Bild_146-1978-043-13,_Erwin_v._Witzleben.jpg /mnt/upload6/wikipedia/commons/4/42/Bundesarchiv_Bild_146-1978-043-13,_Erwin_v._Witzleben.jpg