Last modified: 2012-11-02 23:20:11 UTC
The following page is maintained by a bot[1]: https://commons.wikimedia.org/wiki/Commons:Auto-protected_files/wikipedia/zh As usual with these kind of pages that tend to get a huge history, I periodically move them to a subpage (/Archive_1, /Archive_2, ..) so that next time the bot edits a new page is created. Usually directly after the move I also delete such subpage, as theres no need to keep it live. For this Commons:Auto-protected_files/wikipedia/zh this would've been the first clean up. I accidentally deleted it directly instead of moving it. So the plan was to undelete it and then move it. However during undeletion (POST request to Special:Undelete) I got the following: 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 `revision` (rev_id,rev_page,rev_text_id,rev_comment,rev_minor_edit,rev_user,rev_user_text,rev_timestamp,rev_deleted,rev_len,rev_parent_id,rev_sha1) VALUES ('61103209','18649456','60077341','[[COM:AES|←]]Created page with \'-\'','0','607047','Krinkle','20111016202912','0','1','0','') Function: Revision::insertOn Error: 1062 Duplicate entry '18649456-61103209' for key 'PRIMARY' (10.0.6.41) [1] Every 10 minutes the bot checks which images are used on the zh.wikipedia Main Page, and lists them on that commons page, which as cascading protection enabled. To basically forward the cascading protection to Commons since most files there are embedded from Commons, and cascading protection only applies locally (which is usually good, but in case of Main pages we want to forward it as well, but that's feature request, other bug)
Created attachment 10210 [details] Screenshot
When I try to submit it again from [1] I get the following on [2]: >> Error undeleting page > > Undelete failed; someone else may have undeleted the page first. > > Undeletion will not be performed if it will result in the top page or file revision being partially deleted. In such cases, you must uncheck or unhide the newest deleted revision. -- Krinkle [1] https://commons.wikimedia.org/wiki/Special:Undelete/Commons:Auto-protected_files/wikipedia/zh [2] https://commons.wikimedia.org/w/index.php?title=Special:Undelete&action=submit
Also note that 2 actions were logged eventhough neither succeeded: https://commons.wikimedia.org/wiki/Special:Log/Krinkle?offset=20120312000000 12:08, 10 March 2012 Krinkle (talk | contribs | block) restored page Commons:Auto-protected files/wikipedia/zh (6,924 revisions restored: Restore in preparation for a move to an archive, 7,000 revisions is to much to maintain. Clean start) 12:02, 10 March 2012 Krinkle (talk | contribs | block) moved protection settings from "Commons:Auto-protected files/wikipedia/zh" to "Commons:Auto-protected files/wikipedia/zh/Archive 1" (Commons:Auto-protected files/wikipedia/zh moved to Commons:Auto-protected files/wikipedia/zh/Archive 1) 12:02, 10 March 2012 Krinkle (talk | contribs | block) moved page Commons:Auto-protected files/wikipedia/zh to Commons:Auto-protected files/wikipedia/zh/Archive 1 without leaving a redirect
Okay, after re-trying I eventually succeeded in undeleting the page and moving it to "Commons:Auto-protected_files/wikipedia/zh/Archive_1". I couldn't delete it however due to the 5,000 revision limit for pages that are deleted. The reason I succeeded in accidentally deleting the page in the first place was because the page only had about 3,200 revisions in the revision table (the other 6924-3200=3724 were from the page that was previously at this title).
So can this be closed or do you want to repurpose the bug so that it doesn't happen again?
Krinkle: Could you answer comment 5 please?
Yes, this can be closed now. The related solvable bug is bug 35287.