Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1066: Not unique table/alias: 'templatelinks' when using "Include templates" on Special:Export
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
labels.normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1066: Not unique table/alias: 'templatelinks'
Function: MediaWiki\Specials\SpecialExport::getLinks
Query: SELECT  tl_target_id,lt_namespace,lt_title,lt_namespace AS `namespace`,lt_title AS `t
error.stack_trace
from /srv/mediawiki/php-1.43.0-wmf.4/includes/libs/rdbms/database/Database.php(1203)
#0 /srv/mediawiki/php-1.43.0-wmf.4/includes/libs/rdbms/database/Database.php(1187): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.43.0-wmf.4/includes/libs/rdbms/database/Database.php(1161): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.43.0-wmf.4/includes/libs/rdbms/database/Database.php(652): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.43.0-wmf.4/includes/libs/rdbms/database/Database.php(1350): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4 /srv/mediawiki/php-1.43.0-wmf.4/includes/libs/rdbms/database/DBConnRef.php(126): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /srv/mediawiki/php-1.43.0-wmf.4/includes/libs/rdbms/database/DBConnRef.php(358): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/php-1.43.0-wmf.4/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(730): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 /srv/mediawiki/php-1.43.0-wmf.4/includes/specials/SpecialExport.php(606): Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#8 /srv/mediawiki/php-1.43.0-wmf.4/includes/specials/SpecialExport.php(517): MediaWiki\Specials\SpecialExport->getLinks(array, array, Wikimedia\Rdbms\SelectQueryBuilder)
#9 /srv/mediawiki/php-1.43.0-wmf.4/includes/specials/SpecialExport.php(403): MediaWiki\Specials\SpecialExport->getTemplates(array, array)
#10 /srv/mediawiki/php-1.43.0-wmf.4/includes/specials/SpecialExport.php(230): MediaWiki\Specials\SpecialExport->doExport(string, integer, boolean, boolean)
#11 /srv/mediawiki/php-1.43.0-wmf.4/includes/specialpage/SpecialPage.php(719): MediaWiki\Specials\SpecialExport->execute(NULL)
#12 /srv/mediawiki/php-1.43.0-wmf.4/includes/specialpage/SpecialPageFactory.php(1672): MediaWiki\SpecialPage\SpecialPage->run(NULL)
#13 /srv/mediawiki/php-1.43.0-wmf.4/includes/actions/ActionEntryPoint.php(502): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, MediaWiki\Context\RequestContext)
#14 /srv/mediawiki/php-1.43.0-wmf.4/includes/actions/ActionEntryPoint.php(145): MediaWiki\Actions\ActionEntryPoint->performRequest()
#15 /srv/mediawiki/php-1.43.0-wmf.4/includes/MediaWikiEntryPoint.php(199): MediaWiki\Actions\ActionEntryPoint->execute()
#16 /srv/mediawiki/php-1.43.0-wmf.4/index.php(58): MediaWiki\MediaWikiEntryPoint->run()
#17 /srv/mediawiki/w/index.php(3): require(string)
#18 {main}
Notes
  • Started to pick up when 1.43.0-wmf.4 rolled out to group1 wikis
  • New error in 1.43.0-wmf.4
  • Happening across group1 wikis

Event Timeline

It is related, Special:Export works, at the moment the feature "Include templates" is broken due to the change.

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

[mediawiki/core@master] specials: Fix "include templates" query builder for Special:Export

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

Change #1029637 merged by jenkins-bot:

[mediawiki/core@master] specials: Fix "include templates" query builder for Special:Export

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

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

[mediawiki/core@wmf/1.43.0-wmf.4] specials: Fix "include templates" query builder for Special:Export

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

• matmarex renamed this task from Wikimedia\Rdbms\DBQueryError: Error 1066: Not unique table/alias: 'templatelinks' to Wikimedia\Rdbms\DBQueryError: Error 1066: Not unique table/alias: 'templatelinks' when using "Include templates" on Special:Export.May 10 2024, 9:49 AM

Change #1029564 merged by jenkins-bot:

[mediawiki/core@wmf/1.43.0-wmf.4] specials: Fix "include templates" query builder for Special:Export

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

Mentioned in SAL (#wikimedia-operations) [2024-05-13T13:29:44Z] <logmsgbot> lucaswerkmeister-wmde@deploy1002 Started scap: Backport for [[gerrit:1029564|specials: Fix "include templates" query builder for Special:Export (T364554)]], [[gerrit:rOMWC103030846065|ArticleTarget: Fix return of getVisualDiffGeneratorPromise (T364635)]]

Mentioned in SAL (#wikimedia-operations) [2024-05-13T13:32:09Z] <logmsgbot> lucaswerkmeister-wmde@deploy1002 umherirrender and lucaswerkmeister-wmde and matmarex: Backport for [[gerrit:1029564|specials: Fix "include templates" query builder for Special:Export (T364554)]], [[gerrit:rOMWC103030846065|ArticleTarget: Fix return of getVisualDiffGeneratorPromise (T364635)]] synced to the testservers (https://wikitech.wikimedia.org/wiki/Mwdebug)

Mentioned in SAL (#wikimedia-operations) [2024-05-13T13:45:48Z] <logmsgbot> lucaswerkmeister-wmde@deploy1002 Finished scap: Backport for [[gerrit:1029564|specials: Fix "include templates" query builder for Special:Export (T364554)]], [[gerrit:rOMWC103030846065|ArticleTarget: Fix return of getVisualDiffGeneratorPromise (T364635)]] (duration: 16m 04s)

No more occurrences since the deployment :) (last logstash match May 13, 2024 @ 13:44:56.895)

image.png (662×234 px, 13 KB)