Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError from line 1203 of /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/Database.php: Error 1146: Table 'testwiki.ce_question_answers' doesn't exist
Closed, DuplicatePublic1 Estimated Story PointsPRODUCTION ERROR

Description

Error

mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki has failed its last two runs since train rollout

  • service.version: 1.43.0-wmf.5
message
Wikimedia\Rdbms\DBQueryError from line 1203 of /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/Database.php: Error 1146: Table 'testwiki.ce_question_answers' doesn't exist
trace
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: Aggregating old participant answers...
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: Wikimedia\Rdbms\DBQueryError from line 1203 of /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/Database.php: Error 1146: Table 'testwiki.ce_question_answers' doesn't exist
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: Function: MediaWiki\Extension\CampaignEvents\Maintenance\AggregateParticipantAnswers::aggregateAnswers
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: Query: SELECT  MAX(ceqa_id)  FROM `ce_question_answers`     LIMIT 1
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #0 /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/Database.php(1187): Wikimedia\Rdbms\Database->getQueryException('Table 'testwiki...', 1146, 'SELECT  MAX(ceq...', 'MediaWiki\\Exten...')
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #1 /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/Database.php(1161): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Table 'testwiki...', 1146, 'SELECT  MAX(ceq...', 'MediaWiki\\Exten...')
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #2 /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/Database.php(652): Wikimedia\Rdbms\Database->reportQueryError('Table 'testwiki...', 1146, 'SELECT  MAX(ceq...', 'MediaWiki\\Exten...', false)
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #3 /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/Database.php(1350): Wikimedia\Rdbms\Database->query(Object(Wikimedia\Rdbms\Query), 'MediaWiki\\Exten...')
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #4 /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/Database.php(1301): Wikimedia\Rdbms\Database->select(Array, 'MAX(ceqa_id)', Array, 'MediaWiki\\Exten...', Array, Array)
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #5 /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/DBConnRef.php(126): Wikimedia\Rdbms\Database->selectField(Array, 'MAX(ceqa_id)', Array, 'MediaWiki\\Exten...', Array, Array)
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #6 /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/DBConnRef.php(345): Wikimedia\Rdbms\DBConnRef->__call('selectField', Array)
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #7 /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(748): Wikimedia\Rdbms\DBConnRef->selectField(Array, 'MAX(ceqa_id)', Array, 'MediaWiki\\Exten...', Array, Array)
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #8 /srv/mediawiki/php-1.43.0-wmf.5/extensions/CampaignEvents/maintenance/AggregateParticipantAnswers.php(93): Wikimedia\Rdbms\SelectQueryBuilder->fetchField()
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #9 /srv/mediawiki/php-1.43.0-wmf.5/extensions/CampaignEvents/maintenance/AggregateParticipantAnswers.php(71): MediaWiki\Extension\CampaignEvents\Maintenance\AggregateParticipantAnswers->aggregateAnswers()
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #10 /srv/mediawiki/php-1.43.0-wmf.5/maintenance/includes/MaintenanceRunner.php(696): MediaWiki\Extension\CampaignEvents\Maintenance\AggregateParticipantAnswers->execute()
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #11 /srv/mediawiki/php-1.43.0-wmf.5/maintenance/run.php(51): MediaWiki\Maintenance\MaintenanceRunner->run()
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #12 /srv/mediawiki/multiversion/MWScript.php(158): require_once('/srv/mediawiki/...')
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: #13 {main}
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: Traceback (most recent call last):
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]:   File "/usr/local/bin/mw-cli-wrapper", line 61, in <module>
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]:     subprocess.run(cmd, check=True, shell=True)
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]:   File "/usr/lib/python3.7/subprocess.py", line 487, in run
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]:     output=stdout, stderr=stderr)
May 14 09:00:49 mwmaint1002 mediawiki_job_campaignevents-aggregateparticipantanswers-testwiki[27785]: subprocess.CalledProcessError: Command '/usr/local/bin/mwscript extensions/CampaignEvents/maintenance/AggregateParticipantAnswers.php --wiki testwiki' returned non-zero exit status 1.
Impact

CampaignEvents aggregation job is not run on testwiki, so no big impact, but I don't think we want that issue to propagate to other wikis.

Notes

The job started failing matching deployment of T361399: 1.43.0-wmf.5 deployment blockers

Details

MediaWiki Version
1.43.0-wmf.5

Event Timeline

Clement_Goubert created this task.
Clement_Goubert renamed this task from Aggregation job failure due to missing table for testwiki to Wikimedia\Rdbms\DBQueryError from line 1203 of /srv/mediawiki/php-1.43.0-wmf.5/includes/libs/rdbms/database/Database.php: Error 1146: Table 'testwiki.ce_question_answers' doesn't exist.May 14 2024, 10:00 AM
hashar raised the priority of this task from High to Unbreak Now!.May 14 2024, 10:02 AM

Train blockers are Unbreak Now! priority.

ifried subscribed.