Error
- mwversion: 1.37.0-wmf.19
- reqId: 6913cb75-7e3c-4143-bbc0-f0620333965c
- Find reqId in Logstash
- Find normalized_message in Logstash
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.