Page MenuHomePhabricator
Create Task
Maniphest T380288

Uncaught Wikimedia\Rdbms\DBQueryError: "Table 'testwiki.ce_event_wikis' doesn't exist" on event pages and CampaignEvents special pages
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Description

Error

See https://test.wikipedia.org/wiki/Event:T347608 or https://test.wikipedia.org/wiki/Special:EventDetails/1.

message
[d0599488-5e07-4a25-ba1b-b601138ec097] /wiki/Event:T347608 Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1146: Table 'testwiki.ce_event_wikis' doesn't exist
Function: MediaWiki\Extension\CampaignEvents\Event\Store\EventWikisStore::getEventWikisMulti
Query: SELECT ceew_event_id,ceew_wiki FROM `ce_event_wikis` WHERE ceew_event_id = 163
trace
from /srv/mediawiki/php-1.44.0-wmf.4/includes/libs/rdbms/database/Database.php(1195)
#0 /srv/mediawiki/php-1.44.0-wmf.4/includes/libs/rdbms/database/Database.php(1179): Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1 /srv/mediawiki/php-1.44.0-wmf.4/includes/libs/rdbms/database/Database.php(1153): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2 /srv/mediawiki/php-1.44.0-wmf.4/includes/libs/rdbms/database/Database.php(647): Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3 /srv/mediawiki/php-1.44.0-wmf.4/includes/libs/rdbms/database/Database.php(1342): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4 /srv/mediawiki/php-1.44.0-wmf.4/includes/libs/rdbms/database/DBConnRef.php(127): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /srv/mediawiki/php-1.44.0-wmf.4/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/php-1.44.0-wmf.4/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(745): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 /srv/mediawiki/php-1.44.0-wmf.4/extensions/CampaignEvents/src/Event/Store/EventWikisStore.php(52): Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#8 /srv/mediawiki/php-1.44.0-wmf.4/extensions/CampaignEvents/src/Event/Store/EventWikisStore.php(36): MediaWiki\Extension\CampaignEvents\Event\Store\EventWikisStore->getEventWikisMulti(array)
#9 /srv/mediawiki/php-1.44.0-wmf.4/extensions/CampaignEvents/src/Event/Store/EventStore.php(137): MediaWiki\Extension\CampaignEvents\Event\Store\EventWikisStore->getEventWikis(int)
#10 /srv/mediawiki/php-1.44.0-wmf.4/extensions/CampaignEvents/src/Event/PageEventLookup.php(75): MediaWiki\Extension\CampaignEvents\Event\Store\EventStore->getEventByPage(MediaWiki\Extension\CampaignEvents\MWEntity\MWPageProxy, int)
#11 /srv/mediawiki/php-1.44.0-wmf.4/extensions/CampaignEvents/src/EventPage/EventPageDecorator.php(161): MediaWiki\Extension\CampaignEvents\Event\PageEventLookup->getRegistrationForLocalPage(WikiPage)
#12 /srv/mediawiki/php-1.44.0-wmf.4/extensions/CampaignEvents/src/Hooks/Handlers/ArticleViewHeaderHandler.php(35): MediaWiki\Extension\CampaignEvents\EventPage\EventPageDecorator->decoratePage(WikiPage)
#13 /srv/mediawiki/php-1.44.0-wmf.4/includes/HookContainer/HookContainer.php(159): MediaWiki\Extension\CampaignEvents\Hooks\Handlers\ArticleViewHeaderHandler->onArticleViewHeader(Article, null, bool)
#14 /srv/mediawiki/php-1.44.0-wmf.4/includes/HookContainer/HookRunner.php(876): MediaWiki\HookContainer\HookContainer->run(string, array)
#15 /srv/mediawiki/php-1.44.0-wmf.4/includes/page/Article.php(701): MediaWiki\HookContainer\HookRunner->onArticleViewHeader(Article, null, bool)
#16 /srv/mediawiki/php-1.44.0-wmf.4/includes/page/Article.php(547): Article->generateContentOutput(MediaWiki\User\User, MediaWiki\Parser\ParserOptions, int, MediaWiki\Output\OutputPage, array)
#17 /srv/mediawiki/php-1.44.0-wmf.4/includes/actions/ViewAction.php(78): Article->view()
#18 /srv/mediawiki/php-1.44.0-wmf.4/includes/actions/ActionEntryPoint.php(733): ViewAction->show()
#19 /srv/mediawiki/php-1.44.0-wmf.4/includes/actions/ActionEntryPoint.php(510): MediaWiki\Actions\ActionEntryPoint->performAction(Article, MediaWiki\Title\Title)
#20 /srv/mediawiki/php-1.44.0-wmf.4/includes/actions/ActionEntryPoint.php(146): MediaWiki\Actions\ActionEntryPoint->performRequest()
#21 /srv/mediawiki/php-1.44.0-wmf.4/includes/MediaWikiEntryPoint.php(200): MediaWiki\Actions\ActionEntryPoint->execute()
#22 /srv/mediawiki/php-1.44.0-wmf.4/index.php(58): MediaWiki\MediaWikiEntryPoint->run()
#23 /srv/mediawiki/w/index.php(3): require(string)
#24 {main}
Impact

Anything event-related is not accessible.

Notes

The new table is being created in T379294, but it doesn't exist in production as of 2024-11-19.

Details

Request URL
https://test.wikipedia.org/wiki/Event:T347608
Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Prevent ce_event_wikis query when feature flag is offmediawiki/extensions/CampaignEventswmf/1.44.0-wmf.4+24 -6
Prevent ce_event_wikis query when feature flag is offmediawiki/extensions/CampaignEventsmaster+24 -6
Customize query in gerrit

Related Objects
Search...

Event Timeline

Daimona created this task.Nov 19 2024, 3:56 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 19 2024, 3:56 PM
Daimona claimed this task.Nov 19 2024, 3:56 PM
Daimona triaged this task as Unbreak Now! priority.
Daimona added a parent task: T375663: 1.44.0-wmf.4 deployment blockers.
Daimona edited projects, added Connection-Team (Connection-Current-Sprint); removed Connection-Team.
gerritbot added a comment.Nov 19 2024, 4:05 PM

Change #1092867 had a related patch set uploaded (by Daimona Eaytoy; author: Daimona Eaytoy):

[mediawiki/extensions/CampaignEvents@master] Prevent ce_event_wikis query when feature flag is off

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

gerritbot added a project: Patch-For-Review.Nov 19 2024, 4:05 PM
Daimona moved this task from Upcoming / refining 💡 to Code Review 💬 on the Connection-Team (Connection-Current-Sprint) board.Nov 19 2024, 4:05 PM
gerritbot added a comment.Nov 19 2024, 4:42 PM

Change #1092867 merged by jenkins-bot:

[mediawiki/extensions/CampaignEvents@master] Prevent ce_event_wikis query when feature flag is off

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

gerritbot added a comment.Nov 19 2024, 5:00 PM

Change #1092875 had a related patch set uploaded (by Daimona Eaytoy; author: Daimona Eaytoy):

[mediawiki/extensions/CampaignEvents@wmf/1.44.0-wmf.4] Prevent ce_event_wikis query when feature flag is off

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

ReleaseTaggerBot added a project: MW-1.44-notes (1.44.0-wmf.5; 2024-11-25).Nov 19 2024, 5:00 PM
Aklapper mentioned this in T379294: Create new DB table for storing wikis of event.Nov 19 2024, 5:27 PM
Daimona updated the task description. (Show Details)Nov 19 2024, 5:33 PM
gerritbot added a comment.Nov 19 2024, 5:37 PM

Change #1092875 merged by jenkins-bot:

[mediawiki/extensions/CampaignEvents@wmf/1.44.0-wmf.4] Prevent ce_event_wikis query when feature flag is off

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

Stashbot added a comment.Nov 19 2024, 5:41 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-19T17:41:54Z] <brennen@deploy2002> Started scap sync-world: Backport for [[gerrit:1092875|Prevent ce_event_wikis query when feature flag is off (T380288)]]

Stashbot added a comment.Nov 19 2024, 5:47 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-19T17:47:34Z] <brennen@deploy2002> daimona, brennen: Backport for [[gerrit:1092875|Prevent ce_event_wikis query when feature flag is off (T380288)]] synced to the testservers (https://wikitech.wikimedia.org/wiki/Mwdebug)

Stashbot added a comment.Nov 19 2024, 5:57 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-19T17:57:04Z] <brennen@deploy2002> Finished scap sync-world: Backport for [[gerrit:1092875|Prevent ce_event_wikis query when feature flag is off (T380288)]] (duration: 15m 10s)

ReleaseTaggerBot edited projects, added MW-1.44-notes (1.44.0-wmf.4; 2024-11-19); removed MW-1.44-notes (1.44.0-wmf.5; 2024-11-25).Nov 19 2024, 6:00 PM
Daimona closed this task as Resolved.Nov 19 2024, 6:07 PM
Daimona moved this task from Code Review 💬 to Done 🏁 on the Connection-Team (Connection-Current-Sprint) board.

Fixed now, as verified in https://test.wikipedia.org/wiki/Event:T347608 and https://test.wikipedia.org/wiki/Special:EventDetails/1.

Maintenance_bot removed a project: Patch-For-Review.Nov 19 2024, 6:30 PM
Aklapper added a comment.Nov 19 2024, 9:24 PM

Thanks!

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