Page MenuHomePhabricator

PurgePrivateVoteData::execute: Table 'securepoll_votes' doesn't exist
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
message
Error 1146 from MediaWiki\Extension\SecurePoll\Maintenance\PurgePrivateVoteData::execute, Table 'zuwikibooks.securepoll_votes' doesn't exist SELECT  vote_id  FROM `securepoll_votes`    WHERE vote_election IN (X, Y, Z, ...)  AND ((vote_ip != '' OR vote_xff != '' OR vote_ua != '')) AND (vote_id >= 0)  ORDER BY vote_id LIMIT 200
trace
from /srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1213)
#0 /srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1190): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#1 /srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(647): Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#2 /srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1367): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#3 /srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/DBConnRef.php(127): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(762): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#6 /srv/mediawiki/php-1.45.0-wmf.12/extensions/SecurePoll/maintenance/PurgePrivateVoteData.php(101): Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#7 /srv/mediawiki/php-1.45.0-wmf.12/extensions/SecurePoll/cli/purgePrivateVoteData.php(31): MediaWiki\Extension\SecurePoll\Maintenance\PurgePrivateVoteData->execute()
#8 /srv/mediawiki/php-1.45.0-wmf.12/maintenance/includes/MaintenanceRunner.php(691): PurgePrivateVoteDataDeprecated->execute()
#9 /srv/mediawiki/php-1.45.0-wmf.12/maintenance/run.php(51): MediaWiki\Maintenance\MaintenanceRunner->run()
#10 /srv/mediawiki/multiversion/MWScript.php(221): require_once(string)
#11 {main}
Notes

Similar to T400831, probably fallout from T395928: Delete non-essential SecurePoll tables.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Dreamy_Jazz renamed this task from PurgePrivateVoteData::execute: Table 'x.securepoll_votes' doesn't exist to PurgePrivateVoteData::execute: Table 'securepoll_votes' doesn't exist.Jul 31 2025, 9:24 PM

Change #1174978 had a related patch set uploaded (by SD0001; author: SD0001):

[mediawiki/extensions/SecurePoll@master] PurgePrivateVoteData: bail out if securepoll_votes doesn't exist

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

Change #1174978 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@master] PurgePrivateVoteData: bail out if securepoll_votes doesn't exist

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

Should have been deployed on group0 wikis today (the tables were deleted only on group0 wikis).

SD0001 claimed this task.