Last modified: 2012-03-23 00:16:37 UTC
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."
Also see http://www.mediawiki.org/wiki/User:Aaron_Schulz/Commons_files_with_no_DB_row
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