Marostegui added a comment. |
In T183341#3851033, @Ladsgroup wrote:I see lots of database errors like this in logstash:
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 = '47348009' AND page_namespace = '0' AND page_title = 'Q46210030' LIMIT 1 FOR UPDATE Function: WikiPage::lockAndGetLatest Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.48.25)#0 /srv/mediawiki/php-1.31.0-wmf.12/includes/libs/rdbms/database/Database.php(991): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #1 /srv/mediawiki/php-1.31.0-wmf.12/includes/libs/rdbms/database/Database.php(1374): Wikimedia\Rdbms\Database->query(string, string) #2 /srv/mediawiki/php-1.31.0-wmf.12/includes/libs/rdbms/database/Database.php(1200): Wikimedia\Rdbms\Database->select(string, string, array, string, array, array) #3 /srv/mediawiki/php-1.31.0-wmf.12/includes/page/WikiPage.php(2994): Wikimedia\Rdbms\Database->selectField(string, string, array, string, array) #4 /srv/mediawiki/php-1.31.0-wmf.12/includes/page/WikiPage.php(1741): WikiPage->lockAndGetLatest() #5 /srv/mediawiki/php-1.31.0-wmf.12/includes/page/WikiPage.php(1659): WikiPage->doModify(Wikibase\ItemContent, integer, User, string, array) #6 /srv/mediawiki/php-1.31.0-wmf.12/extensions/Wikibase/repo/includes/Store/Sql/WikiPageEntityStore.php(292): WikiPage->doEditContent(Wikibase\ItemContent, string, integer, integer, User) #7 /srv/mediawiki/php-1.31.0-wmf.12/extensions/Wikibase/repo/includes/Store/Sql/WikiPageEntityStore.php(189): Wikibase\Repo\Store\WikiPageEntityStore->saveEntityContent(Wikibase\ItemContent, string, User, integer, integer) #8 /srv/mediawiki/php-1.31.0-wmf.12/extensions/Wikibase/repo/includes/EditEntity.php(712): Wikibase\Repo\Store\WikiPageEntityStore->saveEntity(Wikibase\DataModel\Entity\Item, string, User, integer, integer) #9 /srv/mediawiki/php-1.31.0-wmf.12/extensions/Wikibase/repo/includes/Api/EntitySavingHelper.php(351): Wikibase\EditEntity->attemptSave(Wikibase\DataModel\Entity\Item, string, integer, string) #10 /srv/mediawiki/php-1.31.0-wmf.12/extensions/Wikibase/repo/includes/Api/CreateClaim.php(102): Wikibase\Repo\Api\EntitySavingHelper->attemptSaveEntity(Wikibase\DataModel\Entity\Item, string) #11 /srv/mediawiki/php-1.31.0-wmf.12/includes/api/ApiMain.php(1582): Wikibase\Repo\Api\CreateClaim->execute() #12 /srv/mediawiki/php-1.31.0-wmf.12/includes/api/ApiMain.php(544): ApiMain->executeAction() #13 /srv/mediawiki/php-1.31.0-wmf.12/includes/api/ApiMain.php(515): ApiMain->executeActionWithErrorHandling() #14 /srv/mediawiki/php-1.31.0-wmf.12/api.php(94): ApiMain->execute() #15 /srv/mediawiki/w/api.php(3): include(string) #16 {main}In SAL, I see depooling of some s5 hosts and the lag doesn't sound well. I think DBAs need to take a look
That lag was from a depooled host.
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
Cc: Marostegui, Ladsgroup, Aklapper, Billinghurst, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
Cc: Marostegui, Ladsgroup, Aklapper, Billinghurst, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs