Page MenuHomePhabricator

DBQueryError: Error 1066: Not unique table/alias: 'page' ([db]) Function: SpecialExport::getLinksQuery
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1066: Not unique table/alias: 'page' (db1166)
Function: SpecialExport::getLinks
Query: SELECT  tl_namespace AS `namespace`,tl_title AS `title`  FROM `page`,`page` JOIN `templatelinks` ON ((page_id=tl_from))   WHERE page_namespace = [redacted] AND page_title = '[redacted]'
exception.trace
from /srv/mediawiki/php-1.39.0-wmf.9/includes/libs/rdbms/database/Database.php(1779)
#0 /srv/mediawiki/php-1.39.0-wmf.9/includes/libs/rdbms/database/Database.php(1763): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.39.0-wmf.9/includes/libs/rdbms/database/Database.php(1737): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.39.0-wmf.9/includes/libs/rdbms/database/Database.php(1217): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.39.0-wmf.9/includes/libs/rdbms/database/Database.php(1983): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.39.0-wmf.9/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /srv/mediawiki/php-1.39.0-wmf.9/includes/libs/rdbms/database/DBConnRef.php(279): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/php-1.39.0-wmf.9/includes/specials/SpecialExport.php(604): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 /srv/mediawiki/php-1.39.0-wmf.9/includes/specials/SpecialExport.php(509): SpecialExport->getLinks(array, array, array, array, array)
#8 /srv/mediawiki/php-1.39.0-wmf.9/includes/specials/SpecialExport.php(393): SpecialExport->getTemplates(array, array)
#9 /srv/mediawiki/php-1.39.0-wmf.9/includes/specials/SpecialExport.php(220): SpecialExport->doExport(string, integer, boolean, boolean)
#10 /srv/mediawiki/php-1.39.0-wmf.9/includes/specialpage/SpecialPage.php(672): SpecialExport->execute(NULL)
#11 /srv/mediawiki/php-1.39.0-wmf.9/includes/specialpage/SpecialPageFactory.php(1406): SpecialPage->run(NULL)
#12 /srv/mediawiki/php-1.39.0-wmf.9/includes/MediaWiki.php(316): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#13 /srv/mediawiki/php-1.39.0-wmf.9/includes/MediaWiki.php(912): MediaWiki->performRequest()
#14 /srv/mediawiki/php-1.39.0-wmf.9/includes/MediaWiki.php(566): MediaWiki->main()
#15 /srv/mediawiki/php-1.39.0-wmf.9/index.php(50): MediaWiki->run()
#16 /srv/mediawiki/php-1.39.0-wmf.9/index.php(46): wfIndexMain()
#17 /srv/mediawiki/w/index.php(3): require(string)
#18 {main}
Impact
Notes

From https://www.mediawiki.org/wiki/Special:Export

Maybe similar: T288565: Wikimedia\Rdbms\DBQueryError: Error 1066: Not unique table/alias: 'page'

3 of these since 1.39.0-wmf.9 (T305215) on group1.

Details

Request URL
https://www.mediawiki.org/wiki/Special:Export
Related Changes in Gerrit:

Event Timeline

Ladsgroup added a project: DBA.

Classic it worked in my system :/ Let me take a look.

I really have trouble reproducing it, general usages of https://www.mediawiki.org/wiki/Special:Export seems to work fine which is good, it's not totally broken.. I dig deeper.

Found the problem. Patch coming.

Change 787070 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[mediawiki/core@master] SpecialExport: Add page table once

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

Change 787089 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[mediawiki/core@wmf/1.39.0-wmf.9] SpecialExport: Add page table once

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

Change 787070 merged by jenkins-bot:

[mediawiki/core@master] SpecialExport: Add page table once

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

Change 787089 merged by jenkins-bot:

[mediawiki/core@wmf/1.39.0-wmf.9] SpecialExport: Add page table once

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

Mentioned in SAL (#wikimedia-operations) [2022-04-28T14:55:33Z] <ladsgroup@deploy1002> Synchronized php-1.39.0-wmf.9/includes/specials/SpecialExport.php: Backport: [[gerrit:787089|SpecialExport: Add page table once (T307037)]] (duration: 00m 51s)