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