Wikimedia\Rdbms\DBLanguageError: Wikimedia\Rdbms\Platform\SQLPlatform::selectSQLText got ambiguous USE INDEX (MediaWiki\Extension\Collection\Specials\SpecialCollection::addCategory)
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Assigned To

Authored By

	thcipriani
	Sep 15 2022, 3:18 PM

Description

Error

mwversion: 1.40.0-wmf.1
reqId: c36fe3ec-81b3-4e57-9cec-0467a5643cdc
Find reqId in Logstash

normalized_message

[{reqId}] {exception_url}   Wikimedia\Rdbms\DBLanguageError: Wikimedia\Rdbms\Platform\SQLPlatform::selectSQLText got ambiguous USE INDEX (MediaWiki\Extension\Collection\Specials\SpecialCollection::addCategory)

exception.trace

from /srv/mediawiki/php-1.40.0-wmf.1/includes/libs/rdbms/platform/SQLPlatform.php(639)
#0 /srv/mediawiki/php-1.40.0-wmf.1/includes/libs/rdbms/database/Database.php(3839): Wikimedia\Rdbms\Platform\SQLPlatform->selectSQLText(array, array, array, string, array, array)
#1 /srv/mediawiki/php-1.40.0-wmf.1/includes/libs/rdbms/database/DatabaseMysqlBase.php(1254): Wikimedia\Rdbms\Database->selectSQLText(array, array, array, string, array, array)
#2 /srv/mediawiki/php-1.40.0-wmf.1/includes/libs/rdbms/database/Database.php(1701): Wikimedia\Rdbms\DatabaseMysqlBase->selectSQLText(array, array, array, string, array, array)
#3 /srv/mediawiki/php-1.40.0-wmf.1/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->select(array, array, array, string, array)
#4 /srv/mediawiki/php-1.40.0-wmf.1/includes/libs/rdbms/database/DBConnRef.php(325): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /srv/mediawiki/php-1.40.0-wmf.1/extensions/Collection/includes/Specials/SpecialCollection.php(795): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array)
#6 /srv/mediawiki/php-1.40.0-wmf.1/extensions/Collection/includes/Specials/SpecialCollection.php(210): MediaWiki\Extension\Collection\Specials\SpecialCollection::addCategory(Title)
#7 /srv/mediawiki/php-1.40.0-wmf.1/includes/specialpage/SpecialPage.php(701): MediaWiki\Extension\Collection\Specials\SpecialCollection->execute(NULL)
#8 /srv/mediawiki/php-1.40.0-wmf.1/includes/specialpage/SpecialPageFactory.php(1428): SpecialPage->run(NULL)
#9 /srv/mediawiki/php-1.40.0-wmf.1/includes/MediaWiki.php(316): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#10 /srv/mediawiki/php-1.40.0-wmf.1/includes/MediaWiki.php(904): MediaWiki->performRequest()
#11 /srv/mediawiki/php-1.40.0-wmf.1/includes/MediaWiki.php(562): MediaWiki->main()
#12 /srv/mediawiki/php-1.40.0-wmf.1/index.php(50): MediaWiki->run()
#13 /srv/mediawiki/php-1.40.0-wmf.1/index.php(46): wfIndexMain()
#14 /srv/mediawiki/w/index.php(3): require(string)
#15 {main}

Notes

Started with 1.39.0-wmf.28 when we rolled to group 2
Frequent when compared to other errors
Happening 4 times an hour
Most errors happening in wikivoyage (some on commons and wikipedia wikis)

Details

Request URL: https://en.wikivoyage.org/w/index.php?bookcmd=*&cattitle=*&title=*

	Subject	Repo	Branch	Lines +/-
	Remove USE INDEX statement for add category feature on Special:Book	mediawiki/extensions/Collection	REL1_39	+0 -1
	Remove USE INDEX statement for add category feature on Special:Book	mediawiki/extensions/Collection	master	+0 -1

Customize query in gerrit

Event Timeline

thcipriani created this task.Sep 15 2022, 3:18 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 15 2022, 3:18 PM

thcipriani moved this task from Untriaged to Sep 2022 on the Wikimedia-production-error board.Sep 15 2022, 3:18 PM

Change 832704 had a related patch set uploaded (by Umherirrender; author: Umherirrender):

[mediawiki/extensions/Collection@master] Remove USE INDEX statement for add category feature on Special:Book

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

gerritbot added a project: Patch-For-Review.Sep 16 2022, 8:14 PM

It is a new error in 1.39.0-wmf.28 and cannot be part of the log before - https://gerrit.wikimedia.org/r/c/mediawiki/core/+/823709

It is shown when visit Special:Book first (which enable the book mode) and on a category page click on "add this category to book"

I have just removed it

Umherirrender claimed this task.Sep 16 2022, 8:16 PM

Change 832704 merged by jenkins-bot:

[mediawiki/extensions/Collection@master] Remove USE INDEX statement for add category feature on Special:Book

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

Umherirrender closed this task as Resolved.Sep 16 2022, 8:39 PM

Umherirrender triaged this task as Low priority.

Umherirrender removed a project: Patch-For-Review.

ReleaseTaggerBot added a project: MW-1.40-notes (1.40.0-wmf.2; 2022-09-19).Sep 16 2022, 9:00 PM

Change 832681 had a related patch set uploaded (by Umherirrender; author: Umherirrender):

[mediawiki/extensions/Collection@REL1_39] Remove USE INDEX statement for add category feature on Special:Book

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

gerritbot added a project: Patch-For-Review.Sep 16 2022, 9:16 PM

Change 832681 merged by jenkins-bot: