Page MenuHomePhabricator

Table 'securepoll_votes' doesn't exist (MediaWiki\Extension\SecurePoll\Pages\ListPage)
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
  • service.version: 1.45.0-wmf.12
  • timestamp: 2025-07-30T15:49:47.761Z
  • labels.phpversion: 8.1.33
  • trace.id: 38a32672-fca3-4fa8-80ba-5247ba4848c4
  • Find trace.id in Logstash
labels.normalized_message
Error 1146: Table 'angwikibooks.securepoll_votes' doesn't exist
Function: MediaWiki\Extension\SecurePoll\Pages\ListPage::execute
Query: SELECT DISTINCT vote_voter  FROM `securepoll_votes`    WHERE
FrameLocationCall
from/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1232)
#0/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1216)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1190)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(647)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1367)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/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)
#5/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/DBConnRef.php(351)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6/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)
#7/srv/mediawiki/php-1.45.0-wmf.12/extensions/SecurePoll/includes/Pages/ListPage.php(79)Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#8/srv/mediawiki/php-1.45.0-wmf.12/extensions/SecurePoll/includes/SpecialSecurePoll.php(70)MediaWiki\Extension\SecurePoll\Pages\ListPage->execute(array)
#9/srv/mediawiki/php-1.45.0-wmf.12/includes/specialpage/SpecialPage.php(725)MediaWiki\Extension\SecurePoll\SpecialSecurePoll->execute(string)
#10/srv/mediawiki/php-1.45.0-wmf.12/includes/specialpage/SpecialPageFactory.php(1724)MediaWiki\SpecialPage\SpecialPage->run(string)
#11/srv/mediawiki/php-1.45.0-wmf.12/includes/actions/ActionEntryPoint.php(499)MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, MediaWiki\Context\RequestContext)
#12/srv/mediawiki/php-1.45.0-wmf.12/includes/actions/ActionEntryPoint.php(143)MediaWiki\Actions\ActionEntryPoint->performRequest()
#13/srv/mediawiki/php-1.45.0-wmf.12/includes/MediaWikiEntryPoint.php(198)MediaWiki\Actions\ActionEntryPoint->execute()
#14/srv/mediawiki/php-1.45.0-wmf.12/index.php(58)MediaWiki\MediaWikiEntryPoint->run()
#15/srv/mediawiki/w/index.php(3)require(string)
#16{main}
Notes

Seeing this and related deprecation warnings (PHP Deprecated: Caller from MediaWiki\Exception\MWExceptionHandler::rollbackPrimaryChanges ignored an error originally raised from MediaWiki\Extension\SecurePoll\Pages\ListPage::execute) for various wikis in 1.45.0-wmf.12 (T396373).

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

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

[mediawiki/extensions/SecurePoll@master] ListPage: don't try to list votes for jump polls

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

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

[mediawiki/extensions/SecurePoll@master] ListPage: don't try to list votes for jump polls

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

Change #1174533 abandoned by SD0001:

[mediawiki/extensions/SecurePoll@master] ListPage: don't try to list votes for jump polls

Reason:

dupe of Ibc8d7b80c4f52b69d4e72ef1795324290199e8c3

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

Change #1174531 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@master] ListPage: don't try to list votes for jump polls

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

Change #1174556 had a related patch set uploaded (by Dreamy Jazz; author: SD0001):

[mediawiki/extensions/SecurePoll@wmf/1.45.0-wmf.12] ListPage: don't try to list votes for jump polls

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

Change #1174557 had a related patch set uploaded (by Dreamy Jazz; author: SD0001):

[mediawiki/extensions/SecurePoll@wmf/1.45.0-wmf.11] ListPage: don't try to list votes for jump polls

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

Change #1174556 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@wmf/1.45.0-wmf.12] ListPage: don't try to list votes for jump polls

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

Change #1174557 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@wmf/1.45.0-wmf.11] ListPage: don't try to list votes for jump polls

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

Mentioned in SAL (#wikimedia-operations) [2025-07-30T21:18:12Z] <dreamyjazz@deploy1003> Started scap sync-world: Backport for [[gerrit:1174556|ListPage: don't try to list votes for jump polls (T400831 T75915 T398126)]], [[gerrit:1174557|ListPage: don't try to list votes for jump polls (T400831 T75915 T398126)]]

SD0001 claimed this task.

Mentioned in SAL (#wikimedia-operations) [2025-07-30T21:46:17Z] <dreamyjazz@deploy1003> dreamyjazz: Backport for [[gerrit:1174556|ListPage: don't try to list votes for jump polls (T400831 T75915 T398126)]], [[gerrit:1174557|ListPage: don't try to list votes for jump polls (T400831 T75915 T398126)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2025-07-30T22:00:52Z] <dreamyjazz@deploy1003> Finished scap sync-world: Backport for [[gerrit:1174556|ListPage: don't try to list votes for jump polls (T400831 T75915 T398126)]], [[gerrit:1174557|ListPage: don't try to list votes for jump polls (T400831 T75915 T398126)]] (duration: 42m 40s)

Krinkle renamed this task from Wikimedia\Rdbms\DBQueryError: Error 1146: Table '[wiki].securepoll_votes' doesn't existFunction: MediaWiki\Extension\SecurePoll\Pages\ListPage::executeQuery: SELECT DISTINCT vote_voter FROM `securepoll_votes` WHERE to Table 'securepoll_votes' doesn't exist (MediaWiki\Extension\SecurePoll\Pages\ListPage).Jul 31 2025, 3:06 PM