Page MenuHomePhabricator
Create Task
Maniphest T292666

Special:Undelete: Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry for key 'PRIMARY' ...
Open, LowPublicPRODUCTION ERROR
Actions

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry '1007398126' for key 'PRIMARY' (db1163)
Function: MediaWiki\Revision\RevisionStore::insertRevisionRowOn
Query: INSERT INTO `revision` (rev_page,rev_parent_id,rev_minor_e
exception.trace
from /srv/mediawiki/php-1.38.0-wmf.2/includes/libs/rdbms/database/Database.php(1809)
#0 /srv/mediawiki/php-1.38.0-wmf.2/includes/libs/rdbms/database/Database.php(1793): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.38.0-wmf.2/includes/libs/rdbms/database/Database.php(1768): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.38.0-wmf.2/includes/libs/rdbms/database/Database.php(1327): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.38.0-wmf.2/includes/libs/rdbms/database/Database.php(2540): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.38.0-wmf.2/includes/libs/rdbms/database/Database.php(2520): Wikimedia\Rdbms\Database->doInsert(string, array, string)
#5 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionStore.php(787): Wikimedia\Rdbms\Database->insert(string, array, string)
#6 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionStore.php(638): MediaWiki\Revision\RevisionStore->insertRevisionRowOn(Wikimedia\Rdbms\DatabaseMysqli, MediaWiki\Revision\RevisionArchiveRecord, integer)
#7 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionStore.php(492): MediaWiki\Revision\RevisionStore->insertRevisionInternal(MediaWiki\Revision\RevisionArchiveRecord, Wikimedia\Rdbms\DatabaseMysqli, MediaWiki\User\UserIdentityValue, CommentStoreComment, WikiPage, integer, integer)
#8 /srv/mediawiki/php-1.38.0-wmf.2/includes/libs/rdbms/database/Database.php(4782): MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}(Wikimedia\Rdbms\DatabaseMysqli, string)
#9 /srv/mediawiki/php-1.38.0-wmf.2/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)
#10 /srv/mediawiki/php-1.38.0-wmf.2/includes/libs/rdbms/database/DBConnRef.php(668): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#11 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionStore.php(494): Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure)
#12 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/UndeletePage.php(398): MediaWiki\Revision\RevisionStore->insertRevisionOn(MediaWiki\Revision\RevisionArchiveRecord, Wikimedia\Rdbms\DBConnRef)
#13 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/UndeletePage.php(155): MediaWiki\Page\UndeletePage->undeleteRevisions(array, boolean, string)
#14 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/PageArchive.php(414): MediaWiki\Page\UndeletePage->undelete(array, string, array, boolean, NULL)
#15 /srv/mediawiki/php-1.38.0-wmf.2/includes/specials/SpecialUndelete.php(1358): PageArchive->undeleteAsUser(array, User, string, array, boolean)
#16 /srv/mediawiki/php-1.38.0-wmf.2/includes/specials/SpecialUndelete.php(324): SpecialUndelete->undelete()
#17 /srv/mediawiki/php-1.38.0-wmf.2/includes/specialpage/SpecialPage.php(647): SpecialUndelete->execute(NULL)
#18 /srv/mediawiki/php-1.38.0-wmf.2/includes/specialpage/SpecialPageFactory.php(1371): SpecialPage->run(NULL)
#19 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(314): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#20 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(925): MediaWiki->performRequest()
#21 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(559): MediaWiki->main()
#22 /srv/mediawiki/php-1.38.0-wmf.2/index.php(53): MediaWiki->run()
#23 /srv/mediawiki/php-1.38.0-wmf.2/index.php(46): wfIndexMain()
#24 /srv/mediawiki/w/index.php(3): require(string)
#25 {main}
Impact

A single instance of this in 1.38.0-wmf.2.

Notes

Feels like a duplicate action possibly taken either by the same user or by multiple users.

Should be caught and presented to user in a useful fashion, assuming that's the case.

Details

Request URL
https://en.wikipedia.org/w/index.php?title=*&action=submit

Related Objects

Event Timeline

brennen created this task.Oct 6 2021, 6:42 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 6 2021, 6:42 PM
brennen moved this task from Untriaged to Oct 2021 on the Wikimedia-production-error board.Oct 6 2021, 6:51 PM
Zabe added subscribers: Daimona, Zabe.Oct 6 2021, 10:03 PM

Probably related to recent refactoring by @Daimona.

Daimona added a comment.Oct 6 2021, 11:08 PM
In T292666#7406973, @Zabe wrote:

Probably related to recent refactoring by @Daimona.

I don't think so: the only patches included in wmf.2 are r715565, r715567 and r715578, none of which changes any backend logic, and all of them are backwards-compatible. Moreover, I can see that similar errors were already happening before the refactoring: I can find 7 of them in the last 3 months, for instance this one was in July:

Error 1062: Duplicate entry '1662247' for key 'PRIMARY' (db2105)
Function: MediaWiki\Revision\RevisionStore::insertRevisionRowOn
Query: INSERT INTO `revision` (rev_page,rev_parent_id,rev_minor_edit,rev_timestamp,rev_deleted,rev_len,rev_sha1,rev_id) VALUES ( ...
from /srv/mediawiki/php-1.37.0-wmf.15/includes/libs/rdbms/database/Database.php(1760)
#0 /srv/mediawiki/php-1.37.0-wmf.15/includes/libs/rdbms/database/Database.php(1744): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.37.0-wmf.15/includes/libs/rdbms/database/Database.php(1719): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.37.0-wmf.15/includes/libs/rdbms/database/Database.php(1283): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.37.0-wmf.15/includes/libs/rdbms/database/Database.php(2406): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.37.0-wmf.15/includes/libs/rdbms/database/Database.php(2386): Wikimedia\Rdbms\Database->doInsert(string, array, string)
#5 /srv/mediawiki/php-1.37.0-wmf.15/includes/Revision/RevisionStore.php(782): Wikimedia\Rdbms\Database->insert(string, array, string)
#6 /srv/mediawiki/php-1.37.0-wmf.15/includes/Revision/RevisionStore.php(633): MediaWiki\Revision\RevisionStore->insertRevisionRowOn(Wikimedia\Rdbms\DatabaseMysqli, MediaWiki\Revision\RevisionArchiveRecord, integer)
#7 /srv/mediawiki/php-1.37.0-wmf.15/includes/Revision/RevisionStore.php(487): MediaWiki\Revision\RevisionStore->insertRevisionInternal(MediaWiki\Revision\RevisionArchiveRecord, Wikimedia\Rdbms\DatabaseMysqli, MediaWiki\User\UserIdentityValue, CommentStoreComment, Title, integer, integer)
#8 /srv/mediawiki/php-1.37.0-wmf.15/includes/libs/rdbms/database/Database.php(4656): MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}(Wikimedia\Rdbms\DatabaseMysqli, string)
#9 /srv/mediawiki/php-1.37.0-wmf.15/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)
#10 /srv/mediawiki/php-1.37.0-wmf.15/includes/libs/rdbms/database/DBConnRef.php(649): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#11 /srv/mediawiki/php-1.37.0-wmf.15/includes/Revision/RevisionStore.php(489): Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure)
#12 /srv/mediawiki/php-1.37.0-wmf.15/includes/page/PageArchive.php(737): MediaWiki\Revision\RevisionStore->insertRevisionOn(MediaWiki\Revision\RevisionArchiveRecord, Wikimedia\Rdbms\DBConnRef)
#13 /srv/mediawiki/php-1.37.0-wmf.15/includes/page/PageArchive.php(486): PageArchive->undeleteRevisions(array, boolean, string)
#14 /srv/mediawiki/php-1.37.0-wmf.15/includes/specials/SpecialUndelete.php(1333): PageArchive->undeleteAsUser(array, User, string, array, boolean)
#15 /srv/mediawiki/php-1.37.0-wmf.15/includes/specials/SpecialUndelete.php(324): SpecialUndelete->undelete()
#16 /srv/mediawiki/php-1.37.0-wmf.15/includes/specialpage/SpecialPage.php(646): SpecialUndelete->execute(NULL)
#17 /srv/mediawiki/php-1.37.0-wmf.15/includes/specialpage/SpecialPageFactory.php(1363): SpecialPage->run(NULL)
#18 /srv/mediawiki/php-1.37.0-wmf.15/includes/MediaWiki.php(314): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#19 /srv/mediawiki/php-1.37.0-wmf.15/includes/MediaWiki.php(925): MediaWiki->performRequest()
#20 /srv/mediawiki/php-1.37.0-wmf.15/includes/MediaWiki.php(559): MediaWiki->main()
#21 /srv/mediawiki/php-1.37.0-wmf.15/index.php(53): MediaWiki->run()
#22 /srv/mediawiki/php-1.37.0-wmf.15/index.php(46): wfIndexMain()
#23 /srv/mediawiki/w/index.php(3): require(string)
#24 {main}

It's the same error AFAICS.

I haven't investigated why it happens, but my first thought would be a race condition (i.e. users A and B try to undelete a page at the same time, and one of the two requests already moved some rows from archive to revision).

brennen moved this task from Backlog to Logs/Train on the User-brennen board.Oct 7 2021, 10:29 PM
Krinkle updated the task description. (Show Details)Jul 7 2022, 10:46 PM
Krinkle updated the task description. (Show Details)
Krinkle edited projects, added: Unowned-production-error; removed: Platform Engineering.Aug 18 2023, 7:41 PM
brennen unsubscribed.Sep 11 2023, 7:23 PM
Krinkle moved this task from Oct 2021 to Older on the Wikimedia-production-error board.Feb 22 2024, 4:42 PM
Krinkle added a project: MediaWiki-Core-Revision-backend.Apr 3 2025, 8:50 AM
Krinkle subscribed.

Still seen. Logstash "mediawiki-warnings" dashboard, last 90 days,

message:"Duplicate entry" AND message:insertRevisionRowOn
[c44f97d6-b804-40df-8d0d-c48c702d3417] arwiki  /w/index.php?action=submit
Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry '69773607' for key 'PRIMARY'
Function: MediaWiki\Revision\RevisionStore::insertRevisionRowOn
Query: INSERT INTO `revision` (rev_page,rev_parent_id,rev_actor,rev_minor_edit,rev_timestamp,rev_deleted,rev_len,rev_sha1,rev_id,rev_comment_id) VALUES (9917645,🎩🎩🎩,69773607,🎩)
[e3e188f4-9987-4d98-a445-5355169dce06] zhwiki /w/index.php?action=submit
Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry '21379459' for key 'PRIMARY'
Function: MediaWiki\Revision\RevisionStore::insertRevisionRowOn
Query: INSERT INTO `revision` (rev_page,rev_parent_id,rev_actor,rev_minor_edit,rev_timestamp,rev_deleted,rev_len,rev_sha1,rev_id,rev_comment_id) VALUES (8808744,🎩🎩🎩,21379459,🎩)
[ab370af5-0a86-42e7-a77d-c62f8549dc5f] eswiki /w/index.php?action=submit
Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry '154808' for key 'PRIMARY'
Function: MediaWiki\Revision\RevisionStore::insertRevisionRowOn
Query: INSERT INTO `revision` (rev_page,rev_parent_id,rev_actor,rev_minor_edit,rev_timestamp,rev_deleted,rev_len,rev_sha1,rev_id,rev_comment_id) VALUES (986009,🎩🎩🎩,154808,🎩)
Krinkle edited projects, added: MediaWiki-API-Platform-Team; removed: Unowned-production-error.Apr 3 2025, 8:51 AM

Tagging MWI for MediaWiki-Page-deletion per mw:Maintainers.

HCoplin-WMF triaged this task as Low priority.Apr 7 2025, 3:24 PM
HCoplin-WMF subscribed.

Thanks for the tag, @Krinkle ! The root cause of this is possibly related to page locking here: https://phabricator.wikimedia.org/T385809

Due to the limited frequency, we are marking priority as low.

HCoplin-WMF moved this task from Incoming (Needs Triage) to Bugs & Chores on the MediaWiki-API-Platform-Team board.Apr 7 2025, 5:53 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits