Error connecting to {db_server} as user {db_user}: {error}
Closed, DeclinedPublicPRODUCTION ERROR
Actions

Assigned To

None

Authored By

	DAlangi_WMF
	Jun 10 2024, 1:52 PM

Description

Error

mwversion: 1.43.0-wmf.8
reqId: 0aa9cfde-86ea-4015-ba25-86b07efc8b97
Find reqId in Logstash

normalized_message

Error connecting to {db_server} as user {db_user}: {error}

exception.trace

from /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/database/Database.php(1223)
#0 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/database/DatabaseMySQL.php(136): Wikimedia\Rdbms\Database->newExceptionAfterConnectError(string)
#1 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/database/Database.php(264): Wikimedia\Rdbms\DatabaseMySQL->open(string, string, string, NULL, NULL, string)
#2 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1065): Wikimedia\Rdbms\Database->initConnection()
#3 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/loadbalancer/LoadBalancer.php(924): Wikimedia\Rdbms\LoadBalancer->reallyOpenConnection(integer, Wikimedia\Rdbms\DatabaseDomain, array)
#4 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/loadbalancer/LoadBalancer.php(801): Wikimedia\Rdbms\LoadBalancer->reuseOrOpenConnectionForNewRef(integer, Wikimedia\Rdbms\DatabaseDomain, integer)
#5 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/loadbalancer/LoadBalancer.php(545): Wikimedia\Rdbms\LoadBalancer->getServerConnection(integer, string, integer)
#6 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/loadbalancer/LoadBalancer.php(458): Wikimedia\Rdbms\LoadBalancer->pickReaderIndex(array)
#7 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/loadbalancer/LoadBalancer.php(781): Wikimedia\Rdbms\LoadBalancer->getReaderIndex(string)
#8 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/database/DBConnRef.php(110): Wikimedia\Rdbms\LoadBalancer->getConnectionInternal(integer, array, string, integer)
#9 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/database/DBConnRef.php(124): Wikimedia\Rdbms\DBConnRef->ensureConnection()
#10 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/database/DBConnRef.php(350): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#11 /srv/mediawiki/php-1.43.0-wmf.8/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(746): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#12 /srv/mediawiki/php-1.43.0-wmf.8/includes/Revision/RevisionStore.php(1445): Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#13 /srv/mediawiki/php-1.43.0-wmf.8/includes/Revision/RevisionStore.php(1397): MediaWiki\Revision\RevisionStore->loadSlotRecordsFromDb(integer, integer, MediaWiki\Page\PageStoreRecord)
#14 /srv/mediawiki/php-1.43.0-wmf.8/includes/Revision/RevisionStore.php(1565): MediaWiki\Revision\RevisionStore->loadSlotRecords(integer, integer, MediaWiki\Page\PageStoreRecord)
#15 [internal function]: MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}()
#16 /srv/mediawiki/php-1.43.0-wmf.8/includes/Revision/RevisionSlots.php(170): call_user_func(Closure)
#17 /srv/mediawiki/php-1.43.0-wmf.8/includes/Revision/RevisionSlots.php(109): MediaWiki\Revision\RevisionSlots->getSlots()
#18 /srv/mediawiki/php-1.43.0-wmf.8/includes/Revision/RevisionRecord.php(200): MediaWiki\Revision\RevisionSlots->getSlot(string)
#19 /srv/mediawiki/php-1.43.0-wmf.8/includes/Revision/RevisionRecord.php(158): MediaWiki\Revision\RevisionRecord->getSlot(string, integer, NULL)
#20 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/WikiModule.php(249): MediaWiki\Revision\RevisionRecord->getContent(string, integer)
#21 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/WikiModule.php(201): MediaWiki\ResourceLoader\WikiModule->getContentObj(MediaWiki\Page\PageStoreRecord, MediaWiki\ResourceLoader\Context)
#22 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/WikiModule.php(421): MediaWiki\ResourceLoader\WikiModule->getContent(string, MediaWiki\ResourceLoader\Context)
#23 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/Module.php(849): MediaWiki\ResourceLoader\WikiModule->getStyles(MediaWiki\ResourceLoader\Context)
#24 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/Module.php(808): MediaWiki\ResourceLoader\Module->buildContent(MediaWiki\ResourceLoader\Context)
#25 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/ResourceLoader.php(1268): MediaWiki\ResourceLoader\Module->getModuleContent(MediaWiki\ResourceLoader\Context)
#26 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/ResourceLoader.php(1177): MediaWiki\ResourceLoader\ResourceLoader->addOneModuleResponse(MediaWiki\ResourceLoader\Context, Wikimedia\Minify\IdentityMinifierState, string, MediaWiki\ResourceLoader\SiteStylesModule, array)
#27 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/ResourceLoader.php(1110): MediaWiki\ResourceLoader\ResourceLoader->getOneModuleResponse(MediaWiki\ResourceLoader\Context, string, MediaWiki\ResourceLoader\SiteStylesModule)
#28 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/ResourceLoader.php(825): MediaWiki\ResourceLoader\ResourceLoader->makeModuleResponse(MediaWiki\ResourceLoader\Context, array, array)
#29 /srv/mediawiki/php-1.43.0-wmf.8/includes/ResourceLoader/ResourceLoaderEntryPoint.php(53): MediaWiki\ResourceLoader\ResourceLoader->respond(MediaWiki\ResourceLoader\Context)
#30 /srv/mediawiki/php-1.43.0-wmf.8/includes/MediaWikiEntryPoint.php(200): MediaWiki\ResourceLoader\ResourceLoaderEntryPoint->execute()
#31 /srv/mediawiki/php-1.43.0-wmf.8/load.php(42): MediaWiki\MediaWikiEntryPoint->run()
#32 /srv/mediawiki/w/load.php(3): require(string)
#33 {main}

Impact

Impacts enwikiquote and is triggered when we hit the load.php entrypoint in some cases.

Notes

2 occurrences in the last 24 hours.

Details

Request URL: https://en.wikiquote.org/w/load.php?lang=*&modules=*&only=*&skin=*

Related Objects

Mentioned Here: T146079: s5-master contention caused (?) by refreshlinksprioritized/addUsagesForPage jobs running for all wikis
T168382: Some code is trying to connect to aawiki on the wrong shard, generating 40 errors per minute
T283635: Error connecting to db1136 as user wikiuser: :real_connect(): (HY000/2002): Connection timed out
T328128: Reduce noise in Growth team's Logstash dashboard
T339958: Running of purgeOldData.php failing for labtestwiki

Event Timeline

DAlangi_WMF created this task.Jun 10 2024, 1:52 PM

Restricted Application added a project: MediaWiki-Platform-Team. · View Herald TranscriptJun 10 2024, 1:52 PM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

DAlangi_WMF edited projects, added DBA, MediaWiki-Platform-Team (Radar); removed MediaWiki-ResourceLoader, MediaWiki-Platform-Team.Jun 13 2024, 10:26 AM

This doesn't happen frequently but not exactly sure what could be the course of it.

Quick Phabricator search shows past related cases:

Looks like those type of edge case errors that are ephemeral.

DAlangi_WMF triaged this task as Low priority.Jun 13 2024, 10:31 AM

ABran-WMF moved this task from Triage to Refine on the DBA board.Jun 13 2024, 11:17 AM

ABran-WMF added a subscriber: Ladsgroup.

Krinkle moved this task from Untriaged to Jun 2024 on the Wikimedia-production-error board.Jul 25 2024, 4:06 PM

It is not unsual we get those, 2 errors in 24h is probably not outstanding enough to investigate - especially if the ticket is more than a month old, it is unlikely we'll find the issue.
Thanks for reporting this though!

PS: If you believe this needs to stay open, please reopen!

Error connecting to {db_server} as user {db_user}: {error}Closed, DeclinedPublicPRODUCTION ERRORActions