Content-Length: 143072 | pFad | https://phabricator.wikimedia.org/T357995

s ⚓ T357995 `Database error` error page when creating account on the beta cluster
Page MenuHomePhabricator

`Database error` error page when creating account on the beta cluster
Closed, ResolvedPublicBUG REPORT

Description

Steps to replicate the issue (include links if applicable):

What happens?:

  • Database error page

What should have happened instead?:

  • The account should be created

Software version (skip for WMF-hosted wikis like Wikipedia):

Other information (browser name/version, screenshots, etc.):

Screenshot from 2024-02-20 16-19-45.png (1×1 px, 425 KB)

Database error
A database query error has occurred. This may indicate a bug in the software.
[ZdTCw6e6bLMqkUfZRp7XFwAAAAE] /wiki/Special:CreateAccount Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1146: Table 'enwiki.globaluser' doesn't exist
Function: MediaWiki\Extension\AntiSpoof\SpoofUser::getConflicts
Query: SELECT su_name AS `value` FROM `spoofuser` JOIN `globaluser` ON ((su_name = gu_name)) WHERE su_normalized = 'v2:TESTE2IO' LIMIT 5

Backtrace:

from /srv/mediawiki/php-master/includes/libs/rdbms/database/Database.php(1203)
#0 /srv/mediawiki/php-master/includes/libs/rdbms/database/Database.php(1187): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-master/includes/libs/rdbms/database/Database.php(1161): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-master/includes/libs/rdbms/database/Database.php(652): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-master/includes/libs/rdbms/database/Database.php(1350): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4 /srv/mediawiki/php-master/includes/libs/rdbms/database/Database.php(1324): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /srv/mediawiki/php-master/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->selectFieldValues(array, string, array, string, array, array)
#6 /srv/mediawiki/php-master/includes/libs/rdbms/database/DBConnRef.php(344): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#7 /srv/mediawiki/php-master/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(759): Wikimedia\Rdbms\DBConnRef->selectFieldValues(array, string, array, string, array, array)
#8 /srv/mediawiki/php-master/extensions/AntiSpoof/includes/SpoofUser.php(114): Wikimedia\Rdbms\SelectQueryBuilder->fetchFieldValues()
#9 /srv/mediawiki/php-master/extensions/CentralAuth/includes/User/CentralAuthAntiSpoofManager.php(84): MediaWiki\Extension\AntiSpoof\SpoofUser->getConflicts()
#10 /srv/mediawiki/php-master/extensions/CentralAuth/includes/CentralAuthPrimaryAuthenticationProvider.php(469): MediaWiki\Extension\CentralAuth\User\CentralAuthAntiSpoofManager->testNewAccount(MediaWiki\User\User, MediaWiki\User\User, boolean, boolean)
#11 /srv/mediawiki/php-master/includes/auth/AuthManager.php(1450): MediaWiki\Extension\CentralAuth\CentralAuthPrimaryAuthenticationProvider->testForAccountCreation(MediaWiki\User\User, MediaWiki\User\User, array)
#12 /srv/mediawiki/php-master/includes/auth/AuthManager.php(1309): MediaWiki\Auth\AuthManager->continueAccountCreation(array)
#13 /srv/mediawiki/php-master/includes/specialpage/AuthManagerSpecialPage.php(394): MediaWiki\Auth\AuthManager->beginAccountCreation(MediaWiki\User\User, array, string)
#14 /srv/mediawiki/php-master/includes/specialpage/AuthManagerSpecialPage.php(524): MediaWiki\SpecialPage\AuthManagerSpecialPage->performAuthenticationStep(string, array)
#15 [internal function]: MediaWiki\SpecialPage\AuthManagerSpecialPage->handleFormSubmit(array, MediaWiki\HTMLForm\CodexHTMLForm)
#16 /srv/mediawiki/php-master/includes/htmlform/HTMLForm.php(794): call_user_func(array, array, MediaWiki\HTMLForm\CodexHTMLForm)
#17 /srv/mediawiki/php-master/includes/specialpage/AuthManagerSpecialPage.php(455): MediaWiki\HTMLForm\HTMLForm->trySubmit()
#18 /srv/mediawiki/php-master/includes/specialpage/LoginSignupSpecialPage.php(336): MediaWiki\SpecialPage\AuthManagerSpecialPage->trySubmit()
#19 /srv/mediawiki/php-master/includes/specialpage/SpecialPage.php(720): MediaWiki\SpecialPage\LoginSignupSpecialPage->execute(NULL)
#20 /srv/mediawiki/php-master/includes/specialpage/SpecialPageFactory.php(1653): MediaWiki\SpecialPage\SpecialPage->run(NULL)
#21 /srv/mediawiki/php-master/includes/actions/ActionEntryPoint.php(504): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, MediaWiki\Context\RequestContext)
#22 /srv/mediawiki/php-master/includes/actions/ActionEntryPoint.php(145): MediaWiki\Actions\ActionEntryPoint->performRequest()
#23 /srv/mediawiki/php-master/includes/MediaWikiEntryPoint.php(199): MediaWiki\Actions\ActionEntryPoint->execute()
#24 /srv/mediawiki/php-master/index.php(58): MediaWiki\MediaWikiEntryPoint->run()
#25 /srv/mediawiki/w/index.php(3): require(string)
#26 {main}

Event Timeline

taavi subscribed.

This is a regression introduced in https://gerrit.wikimedia.org/r/c/mediawiki/extensions/AntiSpoof/+/1003460, as it does not take into account CentralAuthSpoofUser overriding database connection parts of SpoofUser.

Change 1005075 had a related patch set uploaded (by Reedy; author: Reedy):

[mediawiki/extensions/AntiSpoof@master] Revert "Replace wfGetDB() with ICP getReplicaDatabase()"

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

Change 1005075 merged by jenkins-bot:

[mediawiki/extensions/AntiSpoof@master] Revert "Replace wfGetDB() with ICP getReplicaDatabase()"

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

Change 1005076 had a related patch set uploaded (by Reedy; author: Reedy):

[mediawiki/extensions/AntiSpoof@wmf/1.42.0-wmf.19] Revert "Replace wfGetDB() with ICP getReplicaDatabase()"

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

It should switch to virtual domains I think.

Change 1005076 merged by jenkins-bot:

[mediawiki/extensions/AntiSpoof@wmf/1.42.0-wmf.19] Revert "Replace wfGetDB() with ICP getReplicaDatabase()"

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

Mentioned in SAL (#wikimedia-operations) [2024-02-20T16:35:38Z] <reedy@deploy2002> Synchronized php-1.42.0-wmf.19/extensions/AntiSpoof/: T357995 (duration: 11m 02s)

Reedy claimed this task.








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: https://phabricator.wikimedia.org/T357995

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy