Page MenuHomePhabricator
Create Task
Maniphest T400907

Table 'securepoll_questions' doesn't exist (MediaWiki\Extension\SecurePoll\Store\DBStore::getQuestionInfo)
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Description

Error
  • service.version: 1.45.0-wmf.12
  • timestamp: 2025-07-31T14:30:32.062Z
  • labels.phpversion: 8.1.33
  • trace.id: 1baff651-43e9-45c0-aaa9-b8e4a9d9b0b7
  • Find trace.id in Logstash
labels.normalized_message
Error 1146: Table 'wikimania2016wiki.securepoll_questions' doesn't exist
Function: MediaWiki\Extension\SecurePoll\Store\DBStore::getQuestionInfo
Query: SELECT  *  FROM `securepoll_questions` JOIN `securepoll_options` ON ((op_question=qu_entity))   WHERE qu_election = 'X'  ORDER BY qu_index,qu_entity
FrameLocationCall
from/srv/mediawiki/php-1.45.0-wmf.12/includes/debug/MWDebug.php(386)
#0[internal function]MediaWiki\Exception\MWExceptionHandler::handleError(int, string, string, int)
#1/srv/mediawiki/php-1.45.0-wmf.12/includes/debug/MWDebug.php(386)trigger_error(string, int)
#2/srv/mediawiki/php-1.45.0-wmf.12/includes/db/MWLBFactory.php(403)MediaWiki\Debug\MWDebug::sendRawDeprecated(string, bool, string)
#3/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/TransactionManager.php(191)MWLBFactory::logDeprecation(string)
#4/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1019)Wikimedia\Rdbms\TransactionManager->assertTransactionStatus(Wikimedia\Rdbms\DatabaseMySQL, array, string)
#5/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(635)Wikimedia\Rdbms\Database->assertQueryIsCurrentlyAllowed(string, string)
#6/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(2368)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#7/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(2535)Wikimedia\Rdbms\Database->commit(string, string)
#8/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1680)Wikimedia\Rdbms\Database->flushSnapshot(string)
#9/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/lbfactory/LBFactory.php(363)Wikimedia\Rdbms\LoadBalancer->flushReplicaSnapshots(string)
#10/srv/mediawiki/php-1.45.0-wmf.12/includes/exception/MWExceptionHandler.php(172)Wikimedia\Rdbms\LBFactory->rollbackPrimaryChanges(string)
#11/srv/mediawiki/php-1.45.0-wmf.12/includes/exception/MWExceptionHandler.php(197)MediaWiki\Exception\MWExceptionHandler::rollbackPrimaryChanges()
#12/srv/mediawiki/php-1.45.0-wmf.12/includes/exception/MWExceptionHandler.php(237)MediaWiki\Exception\MWExceptionHandler::rollbackPrimaryChangesAndLog(Wikimedia\Rdbms\DBQueryError, string)
#13/srv/mediawiki/php-1.45.0-wmf.12/includes/MediaWikiEntryPoint.php(218)MediaWiki\Exception\MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError, string)
#14/srv/mediawiki/php-1.45.0-wmf.12/includes/actions/ActionEntryPoint.php(79)MediaWiki\MediaWikiEntryPoint->handleTopLevelError(Wikimedia\Rdbms\DBQueryError)
#15/srv/mediawiki/php-1.45.0-wmf.12/includes/MediaWikiEntryPoint.php(204)MediaWiki\Actions\ActionEntryPoint->handleTopLevelError(Wikimedia\Rdbms\DBQueryError)
#16/srv/mediawiki/php-1.45.0-wmf.12/index.php(58)MediaWiki\MediaWikiEntryPoint->run()
#17/srv/mediawiki/w/index.php(3)require(string)
#18{main}
Notes

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

Details

Request URL
https://wikimania2016.wikimedia.org/w/index.php?limit=*&sort=*&title=*
Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
Upstream check for jump poll to Election::getQuestions()SD0001mediawiki/extensions/SecurePollmaster+7 -9
ListPage: avoid lookup of questions and options table for jump pollsSD0001mediawiki/extensions/SecurePollmaster+6 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

brennen created this task.Jul 31 2025, 2:56 PM
Restricted Application added a project: Trust and Safety Product Team. · View Herald TranscriptJul 31 2025, 2:56 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
brennen updated the task description. (Show Details)Jul 31 2025, 2:56 PM
Novem_Linguae mentioned this in T395928: Delete non-essential SecurePoll tables.Jul 31 2025, 3:05 PM
Novem_Linguae subscribed.

https://wikimania2016.wikimedia.org/w/index.php?limit=*&sort=*&title=* is a really odd request URL.

Is this the same error? https://wikimania2016.wikimedia.org/wiki/Special:SecurePoll/list/59

image.png (1,966×645 px, 144 KB)

Krinkle renamed this task from Table 'wikimania2016wiki.securepoll_questions' doesn't exist to Table 'securepoll_questions' doesn't exist (MediaWiki\Extension\SecurePoll\Store\DBStore).Jul 31 2025, 3:06 PM
Krinkle renamed this task from Table 'securepoll_questions' doesn't exist (MediaWiki\Extension\SecurePoll\Store\DBStore) to Table 'securepoll_questions' doesn't exist (MediaWiki\Extension\SecurePoll\Store\DBStore::getQuestionInfo).Jul 31 2025, 3:09 PM
Krinkle updated the task description. (Show Details)
Krinkle subscribed.Jul 31 2025, 3:11 PM
In T400907#11050511, @Novem_Linguae wrote:

https://wikimania2016.wikimedia.org/w/index.php?limit=*&sort=*&title=* is a really odd request URL.

Is this the same error? https://wikimania2016.wikimedia.org/wiki/Special:SecurePoll/list/59

image.png (1,966×645 px, 144 KB)

Yes. That reqId logs the same error.

Error 1146 from MediaWiki\Extension\SecurePoll\Store\DBStore::getQuestionInfo
Table 'wikimania2016wiki.securepoll_questions' doesn't exist
SELECT  *  FROM `securepoll_questions` JOIN `securepoll_options` ON ((op_question=qu_entity))   WHERE …XXX…
gerritbot added a comment.Jul 31 2025, 6:23 PM

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

[mediawiki/extensions/SecurePoll@master] ListPage: avoid lookup of questions and options table for jump polls

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

gerritbot added a project: Patch-For-Review.Jul 31 2025, 6:23 PM
Ladsgroup subscribed.Jul 31 2025, 8:39 PM
SD0001 added a parent task: T395928: Delete non-essential SecurePoll tables.Aug 1 2025, 6:44 AM
• hector.arroyo subscribed.Aug 1 2025, 8:53 AM
gerritbot added a comment.Aug 1 2025, 1:15 PM

Change #1174787 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@master] ListPage: avoid lookup of questions and options table for jump polls

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

Maintenance_bot removed a project: Patch-For-Review.Aug 1 2025, 1:31 PM
ReleaseTaggerBot added a project: MW-1.45-notes (1.45.0-wmf.13; 2025-08-05).Aug 1 2025, 2:00 PM
brennen moved this task from Backlog to Logs/Train on the User-brennen board.Aug 1 2025, 5:09 PM
SD0001 closed this task as Resolved.Aug 6 2025, 8:14 AM
SD0001 claimed this task.
SD0001 subscribed.

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

Dreamy_Jazz reopened this task as Open.Aug 6 2025, 8:19 AM
Dreamy_Jazz subscribed.

I'm still seeing this on some group0 wikis. For example, in this logstash entry which I generated by visiting https://cn.m.wikimedia.org/wiki/Special:SecurePoll/translate/51

Dreamy_Jazz moved this task from Inbox to Tracking work by others on the Trust and Safety Product Team board.Aug 6 2025, 8:24 AM
SD0001 added a comment.Aug 6 2025, 9:29 AM

Hmm, it doesn't happen for Special:SecurePoll/list. So the above fix worked. The error occurring on Special:SecurePoll/translate seems to be another issue, that isn't occurring on other group0 wikis (c.f. https://www.mediawiki.org/wiki/Special:SecurePoll/translate/390).

Dreamy_Jazz added a comment.EditedAug 6 2025, 9:30 AM

Sure. If you wanted to create a new task for that other issue, feel free. I thought these were the same because the SQL error was similar. Thanks for working on fixing these!

gerritbot added a comment.Aug 12 2025, 7:01 PM

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

[mediawiki/extensions/SecurePoll@master] Upstream check for jump poll to Election::getQuestions()

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

gerritbot added a project: Patch-For-Review.Aug 12 2025, 7:01 PM
gerritbot added a comment.Aug 13 2025, 5:25 PM

Change #1178064 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@master] Upstream check for jump poll to Election::getQuestions()

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

Maintenance_bot removed a project: Patch-For-Review.Aug 13 2025, 5:31 PM
ReleaseTaggerBot edited projects, added: MW-1.45-notes (1.45.0-wmf.15; 2025-08-19); removed: MW-1.45-notes (1.45.0-wmf.13; 2025-08-05).Aug 13 2025, 6:00 PM
Novem_Linguae added a comment.Aug 19 2025, 4:57 AM

https://cn.m.wikimedia.org/wiki/Special:SecurePoll/translate/51 is throwing an exception for me today on Monday. If we check again on Thursday evening (after the train) and this exception has gone away, then this ticket can be marked resolved.

I searched the dblists for cnwiki and couldn't find that database name. So not sure exactly what group cnwiki is in (group0, group1, group2).

SD0001 closed this task as Resolved.Aug 19 2025, 1:58 PM

cnwikimedia is on group0 which got the patch today (Tuesday). The link is no longer throwing, so I think we're good to close this now.

Dreamy_Jazz added a comment.Aug 19 2025, 1:59 PM
In T400907#11098443, @SD0001 wrote:

cnwikimedia is on group0 which got the patch today (Tuesday). The link is no longer throwing, so I think we're good to close this now.

Thanks!

OKryva-WMF added a project: Essential-Work.Oct 3 2025, 3:53 PM
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