Page MenuHomePhabricator

ModifyEntity.php database error
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error

Request URL: www.wikidata.org/w/api.php
Request ID: XS9FoQpAEMMAABVu@dUAAAAB

message
[{exception_id}] {exception_url}   Wikimedia\Rdbms\DBQueryError from line 1605 of /srv/mediawiki/php-1.34.0-wmf.14/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema upd

[XS9FoQpAEMMAABVu@dUAAAAB] /w/api.php Wikimedia\Rdbms\DBQueryError from line 1605 of /srv/mediawiki/php-1.34.0-wmf.14/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT page_latest FROM `page` WHERE page_id = 'xxx' AND page_namespace = '0' AND page_title = 'xxx' LIMIT 1 FOR UPDATE Function: WikiPage::lockAndGetLatest Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.48.26)
trace
#0 /srv/mediawiki/php-1.34.0-wmf.14/includes/libs/rdbms/database/Database.php(1573): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/php-1.34.0-wmf.14/includes/libs/rdbms/database/Database.php(1162): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/php-1.34.0-wmf.14/includes/libs/rdbms/database/Database.php(1801): Wikimedia\Rdbms\Database->query(string, string)
#3 /srv/mediawiki/php-1.34.0-wmf.14/includes/libs/rdbms/database/Database.php(1627): Wikimedia\Rdbms\Database->select(string, string, array, string, array, array)
#4 /srv/mediawiki/php-1.34.0-wmf.14/includes/page/WikiPage.php(2992): Wikimedia\Rdbms\Database->selectField(string, string, array, string, array)
#5 /srv/mediawiki/php-1.34.0-wmf.14/includes/Storage/PageUpdater.php(967): WikiPage->lockAndGetLatest()
#6 /srv/mediawiki/php-1.34.0-wmf.14/includes/Storage/PageUpdater.php(756): MediaWiki\Storage\PageUpdater->doModify(CommentStoreComment, User, integer)
#7 /srv/mediawiki/php-1.34.0-wmf.14/extensions/Wikibase/repo/includes/Store/Sql/WikiPageEntityStore.php(383): MediaWiki\Storage\PageUpdater->saveRevision(CommentStoreComment, integer)
#8 /srv/mediawiki/php-1.34.0-wmf.14/extensions/Wikibase/repo/includes/Store/Sql/WikiPageEntityStore.php(248): Wikibase\Repo\Store\WikiPageEntityStore->saveEntityContent(Wikibase\ItemContent, string, User, integer, integer)
#9 /srv/mediawiki/php-1.34.0-wmf.14/extensions/Wikibase/lib/includes/Store/TypeDispatchingEntityStore.php(88): Wikibase\Repo\Store\WikiPageEntityStore->saveEntity(Wikibase\DataModel\Entity\Item, string, User, integer, integer)
#10 /srv/mediawiki/php-1.34.0-wmf.14/extensions/Wikibase/repo/includes/EditEntity/StatsdSaveTimeRecordingEntityStore.php(49): Wikibase\Lib\Store\TypeDispatchingEntityStore->saveEntity(Wikibase\DataModel\Entity\Item, string, User, integer, integer)
#11 /srv/mediawiki/php-1.34.0-wmf.14/extensions/Wikibase/repo/includes/EditEntity/MediawikiEditEntity.php(725): Wikibase\Repo\EditEntity\StatsdSaveTimeRecordingEntityStore->saveEntity(Wikibase\DataModel\Entity\Item, string, User, integer, integer)
#12 /srv/mediawiki/php-1.34.0-wmf.14/extensions/Wikibase/repo/includes/EditEntity/StatsdSaveTimeRecordingEditEntity.php(73): Wikibase\Repo\EditEntity\MediawikiEditEntity->attemptSave(Wikibase\DataModel\Entity\Item, string, integer, string, boolean)
#13 /srv/mediawiki/php-1.34.0-wmf.14/extensions/Wikibase/repo/includes/Api/EntitySavingHelper.php(351): Wikibase\Repo\EditEntity\StatsdSaveTimeRecordingEditEntity->attemptSave(Wikibase\DataModel\Entity\Item, string, integer, string)
#14 /srv/mediawiki/php-1.34.0-wmf.14/extensions/Wikibase/repo/includes/Api/ModifyEntity.php(310): Wikibase\Repo\Api\EntitySavingHelper->attemptSaveEntity(Wikibase\DataModel\Entity\Item, string)
#15 /srv/mediawiki/php-1.34.0-wmf.14/includes/api/ApiMain.php(1583): Wikibase\Repo\Api\ModifyEntity->execute()
#16 /srv/mediawiki/php-1.34.0-wmf.14/includes/api/ApiMain.php(531): ApiMain->executeAction()
#17 /srv/mediawiki/php-1.34.0-wmf.14/includes/api/ApiMain.php(502): ApiMain->executeActionWithErrorHandling()
#18 /srv/mediawiki/php-1.34.0-wmf.14/api.php(86): ApiMain->execute()
#19 /srv/mediawiki/w/api.php(3): include(string)
#20 {main}

Impact

To be determined.

Notes

Seems to date back at least 30 days.

Event Timeline

alaa_wmde changed the subtype of this task from "Task" to "Bug Report".Aug 12 2019, 12:58 PM

For starters, to investigate: find out in what situations (what API endpoint, what kind of edit request) those errors have happened in the last ~30 days.
Time to spend on investigation: 4 hours.

mmodell changed the subtype of this task from "Bug Report" to "Production Error".Aug 28 2019, 11:05 PM

I suggest closing this. DBQueryError on wikidata only happened twice in the last 7 days with unrelated cases: https://logstash.wikimedia.org/goto/377e383afb5da0a215980a1568bc7eb8

alaa_wmde subscribed.

Check again next week and close if no similar errors were found in logs

Addshore claimed this task.

We had lots of other DBQueryErrors on wikidata in the past weeks due to terms store.
But I don't see much relating to this ticket, so closing.