Page MenuHomePhabricator

UrlShortener throws DBConnectionError exception on wikitech
Closed, ResolvedPublicPRODUCTION ERROR

Description

Steps to replicate
Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBConnectionError: Cannot access the database: could not connect to any replica DB server
exception.trace
from /srv/mediawiki/php-1.41.0-wmf.16/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1227)
#0 /srv/mediawiki/php-1.41.0-wmf.16/includes/libs/rdbms/loadbalancer/LoadBalancer.php(834): Wikimedia\Rdbms\LoadBalancer->reportConnectionError(string)
#1 /srv/mediawiki/php-1.41.0-wmf.16/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\LoadBalancer->getConnectionInternal(integer, array, string, integer)
#2 /srv/mediawiki/php-1.41.0-wmf.16/includes/libs/rdbms/database/DBConnRef.php(117): Wikimedia\Rdbms\DBConnRef->ensureConnection()
#3 /srv/mediawiki/php-1.41.0-wmf.16/includes/libs/rdbms/database/DBConnRef.php(359): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#4 /srv/mediawiki/php-1.41.0-wmf.16/extensions/UrlShortener/includes/UrlShortenerUtils.php(83): Wikimedia\Rdbms\DBConnRef->selectRow(string, array, array, string)
#5 /srv/mediawiki/php-1.41.0-wmf.16/extensions/UrlShortener/includes/ApiShortenUrl.php(37): MediaWiki\Extension\UrlShortener\UrlShortenerUtils::maybeCreateShortCode(string, User)
#6 /srv/mediawiki/php-1.41.0-wmf.16/includes/api/ApiMain.php(1915): MediaWiki\Extension\UrlShortener\ApiShortenUrl->execute()
#7 /srv/mediawiki/php-1.41.0-wmf.16/includes/api/ApiMain.php(892): ApiMain->executeAction()
#8 /srv/mediawiki/php-1.41.0-wmf.16/includes/api/ApiMain.php(863): ApiMain->executeActionWithErrorHandling()
#9 /srv/mediawiki/php-1.41.0-wmf.16/api.php(95): ApiMain->execute()
#10 /srv/mediawiki/php-1.41.0-wmf.16/api.php(48): wfApiMain()
#11 /srv/mediawiki/w/api.php(3): require(string)
#12 {main}
Impact
Notes

Event Timeline

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

This is the "wikitech is hosted on different hardware than the rest of the wikis" thing biting us again. We will need to fix those when Wikitech will become a SUL wiki but for now let's just disable the extension there, people can use Meta's interface anyways.

Change 936752 had a related patch set uploaded (by Majavah; author: Majavah):

[operations/mediawiki-config@master] Disable UrlShortener on wikitech

https://gerrit.wikimedia.org/r/936752

Change 936752 merged by jenkins-bot:

[operations/mediawiki-config@master] Disable UrlShortener on wikitech

https://gerrit.wikimedia.org/r/936752

Mentioned in SAL (#wikimedia-operations) [2023-07-10T15:59:17Z] <taavi@deploy1002> Started scap: Backport for [[gerrit:936751|wikitech: Update codfw1dev LDAP server hostname]], [[gerrit:936752|Disable UrlShortener on wikitech (T341470)]]

Mentioned in SAL (#wikimedia-operations) [2023-07-10T16:00:46Z] <taavi@deploy1002> taavi: Backport for [[gerrit:936751|wikitech: Update codfw1dev LDAP server hostname]], [[gerrit:936752|Disable UrlShortener on wikitech (T341470)]] synced to the testservers: mwdebug2001.codfw.wmnet, mwdebug2002.codfw.wmnet, mwdebug1002.eqiad.wmnet, mwdebug1001.eqiad.wmnet

Mentioned in SAL (#wikimedia-operations) [2023-07-10T16:07:05Z] <taavi@deploy1002> Finished scap: Backport for [[gerrit:936751|wikitech: Update codfw1dev LDAP server hostname]], [[gerrit:936752|Disable UrlShortener on wikitech (T341470)]] (duration: 07m 47s)

taavi claimed this task.