Page MenuHomePhabricator
Create Task
Maniphest T354894

Wikimedia\Rdbms\DBTransactionStateError: Cannot execute query from MediaWiki\User\UserGroupManager::getUserGroupMemberships while transaction status is ERROR
Closed, DuplicatePublicPRODUCTION ERROR
Actions

Description

Happened when simply viewing Special:NewPagesFeed. No entries show up at all. Tested while logged in and logged out.

Screenshot from 2024-01-11 13-40-37.png (460×1 px, 65 KB)

A similar error also occurs at https://en.wikipedia.org/w/api.php?action=pagetriagestats&format=json&namespace=0&showunreviewed=1&showdeleted=1&showothers=1&show_predicted_issues_copyvio=1&non_autoconfirmed_users=1

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBTransactionStateError: Cannot execute query from MediaWiki\User\UserGroupManager::getUserGroupMemberships while transaction status is ERROR
exception.trace
from /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/TransactionManager.php(207)
#0 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/Database.php(989): Wikimedia\Rdbms\TransactionManager->assertTransactionStatus(Wikimedia\Rdbms\DatabaseMySQL, array, string)
#1 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/Database.php(637): Wikimedia\Rdbms\Database->assertQueryIsCurrentlyAllowed(string, string)
#2 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/Database.php(1347): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#3 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(708): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#6 /srv/mediawiki/php-1.42.0-wmf.12/includes/user/UserGroupManager.php(767): Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#7 /srv/mediawiki/php-1.42.0-wmf.12/includes/user/UserGroupManager.php(733): MediaWiki\User\UserGroupManager->getUserGroupMemberships(MediaWiki\User\User, integer)
#8 /srv/mediawiki/php-1.42.0-wmf.12/includes/user/UserGroupManager.php(321): MediaWiki\User\UserGroupManager->getUserGroups(MediaWiki\User\User, integer)
#9 /srv/mediawiki/php-1.42.0-wmf.12/includes/Permissions/PermissionManager.php(1586): MediaWiki\User\UserGroupManager->getUserEffectiveGroups(MediaWiki\User\User)
#10 /srv/mediawiki/php-1.42.0-wmf.12/includes/Permissions/PermissionManager.php(1537): MediaWiki\Permissions\PermissionManager->getUserPermissions(MediaWiki\User\User)
#11 /srv/mediawiki/php-1.42.0-wmf.12/extensions/FlaggedRevs/includes/backend/FlaggedRevsHooks.php(1289): MediaWiki\Permissions\PermissionManager->userHasRight(MediaWiki\User\User, string)
#12 /srv/mediawiki/php-1.42.0-wmf.12/includes/HookContainer/HookContainer.php(161): FlaggedRevsHooks->onUserLoadAfterLoadFromSession(MediaWiki\User\User)
#13 /srv/mediawiki/php-1.42.0-wmf.12/includes/HookContainer/HookRunner.php(4298): MediaWiki\HookContainer\HookContainer->run(string, array)
#14 /srv/mediawiki/php-1.42.0-wmf.12/includes/user/User.php(432): MediaWiki\HookContainer\HookRunner->onUserLoadAfterLoadFromSession(MediaWiki\User\User)
#15 /srv/mediawiki/php-1.42.0-wmf.12/includes/user/User.php(1613): MediaWiki\User\User->load()
#16 /srv/mediawiki/php-1.42.0-wmf.12/includes/api/ApiMain.php(1975): MediaWiki\User\User->getName()
#17 /srv/mediawiki/php-1.42.0-wmf.12/includes/api/ApiMain.php(916): ApiMain->logRequest(double, Wikimedia\Rdbms\DBQueryError)
#18 /srv/mediawiki/php-1.42.0-wmf.12/includes/api/ApiMain.php(879): ApiMain->executeActionWithErrorHandling()
#19 /srv/mediawiki/php-1.42.0-wmf.12/api.php(95): ApiMain->execute()
#20 /srv/mediawiki/php-1.42.0-wmf.12/api.php(48): wfApiMain()
#21 /srv/mediawiki/w/api.php(3): require(string)
#22 {main}
exception.previous.trace
from /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/Database.php(1200)
#0 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/Database.php(898): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/Database.php(829): Wikimedia\Rdbms\Database->handleErroredQuery(Wikimedia\Rdbms\QueryStatus, Wikimedia\Rdbms\Query, string, double, Wikimedia\Rdbms\CriticalSessionInfo)
#2 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/Database.php(713): Wikimedia\Rdbms\Database->attemptQuery(Wikimedia\Rdbms\Query, string, boolean)
#3 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/Database.php(640): Wikimedia\Rdbms\Database->executeQuery(Wikimedia\Rdbms\Query, string, integer)
#4 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/Database.php(1347): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#5 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->select(array, string, array, string, array, array)
#6 /srv/mediawiki/php-1.42.0-wmf.12/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#7 /srv/mediawiki/php-1.42.0-wmf.12/extensions/PageTriage/includes/Api/ApiPageTriageList.php(508): Wikimedia\Rdbms\DBConnRef->select(array, string, array, string, array, array)
#8 /srv/mediawiki/php-1.42.0-wmf.12/extensions/PageTriage/includes/Api/ApiPageTriageList.php(74): MediaWiki\Extension\PageTriage\Api\ApiPageTriageList::getPageIds(array)
#9 /srv/mediawiki/php-1.42.0-wmf.12/includes/api/ApiMain.php(1931): MediaWiki\Extension\PageTriage\Api\ApiPageTriageList->execute()
#10 /srv/mediawiki/php-1.42.0-wmf.12/includes/api/ApiMain.php(908): ApiMain->executeAction()
#11 /srv/mediawiki/php-1.42.0-wmf.12/includes/api/ApiMain.php(879): ApiMain->executeActionWithErrorHandling()
#12 /srv/mediawiki/php-1.42.0-wmf.12/api.php(95): ApiMain->execute()
#13 /srv/mediawiki/php-1.42.0-wmf.12/api.php(48): wfApiMain()
#14 /srv/mediawiki/w/api.php(3): require(string)
#15 {main}

Details

Request URL
https://en.wikipedia.org/w/api.php?action=pagetriagelist&dir=*&format=*&limit=*&namespace=*&non_autoconfirmed_users=*&offset=*&pageoffset=*&show_predicted_issues_copyvio=*&showdeleted=*&showothers=*&showunreviewed=*
Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Add regression test for database errormediawiki/extensions/PageTriagemaster+32 -0
ApiPageTriageList: disambiguate ptrpt_tag_id in tag querymediawiki/extensions/PageTriagemaster+4 -2
Customize query in gerrit

Related Objects

Event Timeline

MusikAnimal created this task.Jan 11 2024, 6:43 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 11 2024, 6:43 PM
Chlod subscribed.Jan 11 2024, 7:36 PM

Seems like it's happening when the "Copyvio"/"None" possible issue filter is paired with one of the "Were created by" filters (newcomer/learner/etc., except "Autopatrolled users" and "Show all"). This was reported for wmf.12 but it's still happening to me right now (seems like wmf.13 was deployed just minutes ago).

Chlod mentioned this in T354900: Wikimedia\Rdbms\DBQueryError: Error 1052: Column 'ptrpt_tag_id' in where clause is ambiguousFunction: MediaWiki\Extension\PageTriage\Api\ApiPageTriageList::getPageIdsQuery: SELECT COUNT(*) AS `rowcount` FROM (SELECT 1 FRO.Jan 11 2024, 8:30 PM
gerritbot added a comment.Jan 11 2024, 9:54 PM

Change 989955 had a related patch set uploaded (by Chlod Alejandro; author: Chlod Alejandro):

[mediawiki/extensions/PageTriage@master] ApiPageTriageList: disambiguate ptrpt_tag_id in tag query

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

gerritbot added a project: Patch-For-Review.Jan 11 2024, 9:54 PM
gerritbot added a comment.Jan 12 2024, 12:51 AM

Change 989977 had a related patch set uploaded (by Novem Linguae; author: Novem Linguae):

[mediawiki/extensions/PageTriage@master] add regression test

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

gerritbot added a comment.Jan 12 2024, 1:00 AM

Change 989955 merged by jenkins-bot:

[mediawiki/extensions/PageTriage@master] ApiPageTriageList: disambiguate ptrpt_tag_id in tag query

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

Chlod closed this task as a duplicate of T354900: Wikimedia\Rdbms\DBQueryError: Error 1052: Column 'ptrpt_tag_id' in where clause is ambiguousFunction: MediaWiki\Extension\PageTriage\Api\ApiPageTriageList::getPageIdsQuery: SELECT COUNT(*) AS `rowcount` FROM (SELECT 1 FRO.Jan 12 2024, 1:47 AM
ReleaseTaggerBot added a project: MW-1.42-notes (1.42.0-wmf.14; 2024-01-16).Jan 12 2024, 3:00 AM
gerritbot added a comment.Jan 12 2024, 5:53 PM

Change 989977 merged by jenkins-bot:

[mediawiki/extensions/PageTriage@master] Add regression test for database error

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

Maintenance_bot removed a project: Patch-For-Review.Jan 12 2024, 6:30 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits