Page MenuHomePhabricator

Table 'hewiki.templatelinks' doesn't exist
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
normalized_message
Error 1146 from GrowthExperiments\NewcomerTasks\AddLink\LinkRecommendationStore::getNumberOfExcludedTemplatesOnPage, {error} {sql1line} {db_server}
exception.trace
from /srv/mediawiki/php-1.45.0-wmf.5/includes/libs/rdbms/database/Database.php(1213)
#0 /srv/mediawiki/php-1.45.0-wmf.5/includes/libs/rdbms/database/Database.php(1190): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#1 /srv/mediawiki/php-1.45.0-wmf.5/includes/libs/rdbms/database/Database.php(647): Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#2 /srv/mediawiki/php-1.45.0-wmf.5/includes/libs/rdbms/database/Database.php(1367): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#3 /srv/mediawiki/php-1.45.0-wmf.5/includes/libs/rdbms/database/Database.php(1428): Wikimedia\Rdbms\Database->select(array, array, array, string)
#4 /srv/mediawiki/php-1.45.0-wmf.5/includes/libs/rdbms/database/DBConnRef.php(127): Wikimedia\Rdbms\Database->selectRowCount(array, string, array, string, array, array)
#5 /srv/mediawiki/php-1.45.0-wmf.5/includes/libs/rdbms/database/DBConnRef.php(381): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/php-1.45.0-wmf.5/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(825): Wikimedia\Rdbms\DBConnRef->selectRowCount(array, string, array, string, array, array)
#7 /srv/mediawiki/php-1.45.0-wmf.5/extensions/GrowthExperiments/includes/NewcomerTasks/AddLink/LinkRecommendationStore.php(571): Wikimedia\Rdbms\SelectQueryBuilder->fetchRowCount()
#8 /srv/mediawiki/php-1.45.0-wmf.5/extensions/GrowthExperiments/includes/NewcomerTasks/AddLink/LinkRecommendationUpdater.php(283): GrowthExperiments\NewcomerTasks\AddLink\LinkRecommendationStore->getNumberOfExcludedTemplatesOnPage(int, array)
#9 /srv/mediawiki/php-1.45.0-wmf.5/extensions/GrowthExperiments/includes/NewcomerTasks/AddLink/LinkRecommendationUpdater.php(108): GrowthExperiments\NewcomerTasks\AddLink\LinkRecommendationUpdater->evaluateTitle(MediaWiki\Page\PageIdentityValue, MediaWiki\Revision\RevisionStoreRecord, bool)
#10 /srv/mediawiki/php-1.45.0-wmf.5/extensions/GrowthExperiments/maintenance/refreshLinkRecommendations.php(353): GrowthExperiments\NewcomerTasks\AddLink\LinkRecommendationUpdater->processCandidate(MediaWiki\Page\PageIdentityValue, bool)
#11 /srv/mediawiki/php-1.45.0-wmf.5/extensions/GrowthExperiments/maintenance/refreshLinkRecommendations.php(440): GrowthExperiments\Maintenance\RefreshLinkRecommendations->processCandidate(MediaWiki\Page\PageIdentityValue, bool)
#12 /srv/mediawiki/php-1.45.0-wmf.5/extensions/GrowthExperiments/maintenance/refreshLinkRecommendations.php(148): GrowthExperiments\Maintenance\RefreshLinkRecommendations->refreshViaOresTopics(bool)
#13 /srv/mediawiki/php-1.45.0-wmf.5/maintenance/includes/MaintenanceRunner.php(691): GrowthExperiments\Maintenance\RefreshLinkRecommendations->execute()
#14 /srv/mediawiki/php-1.45.0-wmf.5/maintenance/run.php(51): MediaWiki\Maintenance\MaintenanceRunner->run()
#15 /srv/mediawiki/multiversion/MWScript.php(221): require_once(string)
#16 {main}
Impact
Notes

Event Timeline

Urbanecm_WMF raised the priority of this task from High to Unbreak Now!.

I see train is on group1 only => promoting to train blocker.

Change #1156326 had a related patch set uploaded (by Urbanecm; author: Urbanecm):

[mediawiki/extensions/GrowthExperiments@master] Revert "fix(Add Link): Respect excluded categories and templates when refreshing"

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

Change #1156336 had a related patch set uploaded (by Urbanecm; author: Urbanecm):

[mediawiki/extensions/GrowthExperiments@master] LinkRecommendationStore: Query templatelinks on the main DB

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

Change #1156326 abandoned by Urbanecm:

[mediawiki/extensions/GrowthExperiments@master] Revert "fix(Add Link): Respect excluded categories and templates when refreshing"

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

Change #1156378 had a related patch set uploaded (by Urbanecm; author: Urbanecm):

[mediawiki/extensions/GrowthExperiments@wmf/1.45.0-wmf.5] LinkRecommendationStore: Query templatelinks on the main DB

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

Change #1156378 merged by jenkins-bot:

[mediawiki/extensions/GrowthExperiments@wmf/1.45.0-wmf.5] LinkRecommendationStore: Query templatelinks on the main DB

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

Mentioned in SAL (#wikimedia-operations) [2025-06-12T15:05:52Z] <urbanecm@deploy1003> Started scap sync-world: Backport for [[gerrit:1156378|LinkRecommendationStore: Query templatelinks on the main DB (T396680)]]

Change #1156336 merged by jenkins-bot:

[mediawiki/extensions/GrowthExperiments@master] LinkRecommendationStore: Query templatelinks on the main DB

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

Mentioned in SAL (#wikimedia-operations) [2025-06-12T15:08:02Z] <urbanecm@deploy1003> urbanecm: Backport for [[gerrit:1156378|LinkRecommendationStore: Query templatelinks on the main DB (T396680)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2025-06-12T15:23:58Z] <urbanecm@deploy1003> Finished scap sync-world: Backport for [[gerrit:1156378|LinkRecommendationStore: Query templatelinks on the main DB (T396680)]] (duration: 18m 06s)