Page MenuHomePhabricator

Flow\Data\Storage\RevisionStorage::insert: Duplicate entry '...' for key 'flow_revision_unique_parent'
Closed, DuplicatePublicPRODUCTION ERROR

Description

Error
normalized_message
Error 1062 from Flow\Data\Storage\RevisionStorage::insert, {error} {sql1line} {db_server}
exception.trace
from /srv/mediawiki/php-1.37.0-wmf.19/includes/libs/rdbms/database/Database.php(1775)
#0 /srv/mediawiki/php-1.37.0-wmf.19/includes/libs/rdbms/database/Database.php(1753): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/php-1.37.0-wmf.19/includes/libs/rdbms/database/Database.php(1312): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/php-1.37.0-wmf.19/includes/libs/rdbms/database/Database.php(2433): Wikimedia\Rdbms\Database->query(string, string, integer)
#3 /srv/mediawiki/php-1.37.0-wmf.19/includes/libs/rdbms/database/Database.php(2413): Wikimedia\Rdbms\Database->doInsert(string, array, string)
#4 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/Data/Storage/RevisionStorage.php(392): Wikimedia\Rdbms\Database->insert(string, array, string)
#5 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/Data/ObjectManager.php(248): Flow\Data\Storage\RevisionStorage->insert(array)
#6 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/Data/ObjectManager.php(173): Flow\Data\ObjectManager->insert(array, array)
#7 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/Data/ObjectManager.php(146): Flow\Data\ObjectManager->multiPut(array, array)
#8 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/Data/ManagerGroup.php(81): Flow\Data\ObjectManager->put(Flow\Model\PostRevision, array)
#9 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/Block/TopicBlock.php(457): Flow\Data\ManagerGroup->put(Flow\Model\PostRevision, array)
#10 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/SubmissionHandler.php(164): Flow\Block\TopicBlock->commit()
#11 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/WorkflowLoader.php(66): Flow\SubmissionHandler->commit(Flow\Model\Workflow, array)
#12 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/Api/ApiFlowBasePost.php(35): Flow\WorkflowLoader->commit(array)
#13 /srv/mediawiki/php-1.37.0-wmf.19/extensions/Flow/includes/Api/ApiFlow.php(108): Flow\Api\ApiFlowBasePost->execute()
#14 /srv/mediawiki/php-1.37.0-wmf.19/includes/api/ApiMain.php(1842): Flow\Api\ApiFlow->execute()
#15 /srv/mediawiki/php-1.37.0-wmf.19/includes/api/ApiMain.php(821): ApiMain->executeAction()
#16 /srv/mediawiki/php-1.37.0-wmf.19/includes/api/ApiMain.php(792): ApiMain->executeActionWithErrorHandling()
#17 /srv/mediawiki/php-1.37.0-wmf.19/api.php(90): ApiMain->execute()
#18 /srv/mediawiki/php-1.37.0-wmf.19/api.php(45): wfApiMain()
#19 /srv/mediawiki/w/api.php(3): require(string)
#20 {main}
Impact

The Flow operation that involved inserting this row will fail (in the specific case linked here, it was a topic locking). Depending on the exact way it fails, the user might not realize it happens, leading to data loss.

7 occurances in recorded Logstash history (so something like once every 10 days), all with a lock-topic or restore-topic operation.

Notes

Details

Request URL
https://zh.wikipedia.org/w/api.php

Event Timeline

Moving to Needs Discussion since I'm unsure of the impact (from what I can tell, this error only occurred once in the last month)

Tgr renamed this task from Error 1062 from Flow\Data\Storage\RevisionStorage::insert, {error} {sql1line} {db_server} to Flow\Data\Storage\RevisionStorage::insert: Duplicate entry '...' for key 'flow_revision_unique_parent' .Aug 23 2021, 11:15 PM
Tgr merged a task: Restricted Task.
Tgr added a subscriber: Stang.