Gregory Maxwell wrote:
BTW- there are a lot of uploads in our existing spools which are exact duplicates.. Have you been logging dups on delete? It would be interesting to watch.
Of 12,209 files deleted from Commons so far, 176 appear multiple times, mostly just twice each.
The winner so far is a goatse-style image which appears in the history of 23 deleted satellite weather maps. Most others look like images which were reverted (probably mostly from those goatse images).
Should one be curious, you can poke in the filearchive table to look for dupes; fa_storage_key contains the hash + file extension. This ought to be available on the toolserver (though it may need a view created for it).
-- brion vibber (brion @ pobox.com)