Last modified: 2014-02-12 23:39:56 UTC
Hi. Just wanted to put a note that I had a database error while trying to restore an article. Here is the message I get : > from within function "Revision::insertOn". Database returned error "1062: Duplicate entry '107364-20165' for key 'PRIMARY' (10.64.16.30)". The page I tried to restore was https://es.wikipedia.org/w/index.php?title=Red_de_computadoras&action=history and the restore process seems to have worked fine, except I've got the error I'm reporting. Regards, Quentin
107364 is the page_id of [[Red_de_computadoras]] 20165 is the first revision (20030725151910) of that page: https://es.wikipedia.org/w/index.php?title=Red_de_computadoras&oldid=20165 The duplicate page_id must have been: rev_page_id (rev_page, rev_id), and thus the $dbw->insert( 'revision', $row, __METHOD__ ); of line 1347. Sidenote: https://meta.wikimedia.org/w/index.php?diff=5317080&oldid=5310095 states that the page had more than 5000 revisions, but only 3774 were restored (there are in total 3808 revisions now) However, I don't see revisions left: mysql> select count(*) from archive where ar_namespace = 0 and ar_title = 'Red_de_computadoras'; +----------+ | count(*) | +----------+ | 0 | +----------+ It may have been an estimation error by mysql EXPLAIN. It also happened in Jan 2012 when deleted by Vituzzu, but there were just 3560 revisions.