Page MenuHomePhabricator
Create Task
Maniphest T231162

DBQueryError from ExternalStoreDB::fetchBlob: Table 'enwiki.blobs' doesn't exist
Closed, ResolvedPublic
Actions

Description

After 45831e6 was merged, https://en.wikipedia.beta.wmflabs.org/wiki/Main_Page started to say:

Original exception: [XWKYxqwQBHcAAHEcZAYAAAAO] /wiki/Main_Page Wikimedia\Rdbms\DBQueryError from line 1587 of /srv/mediawiki/php-master/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: SELECT blob_text FROM `blobs` WHERE blob_id = '111937' LIMIT 1 
Function: ExternalStoreDB::fetchBlob
Error: 1146 Table 'enwiki.blobs' doesn't exist (172.16.5.170:3306)

After reverting 45831e6 on beta, all started to work.

Details

ProjectBranchLines +/-Subject
mediawiki/coremaster+84 -18externalstore: deprecate getLBInfo() dependency in ExternalStoreDB
mediawiki/coremaster+176 -169Revert "rdbms: make LoadBalancer::reallyOpenConnection() handle setting DBO_TRX"
Customize query in gerrit

Related Objects

Event Timeline

Urbanecm triaged this task as Unbreak Now! priority.Aug 25 2019, 2:20 PM
Urbanecm created this task.
Restricted Application added subscribers: Liuxinyu970226, Aklapper. · View Herald TranscriptAug 25 2019, 2:20 PM
Urbanecm removed the point value for this task.Aug 25 2019, 2:20 PM
Stashbot added a comment.Aug 25 2019, 4:33 PM

Mentioned in SAL (#wikimedia-cloud) [2019-08-25T16:33:34Z] <Urbanecm> Revert 45831e6 locally on beta cluster to test possible root cause of T231162

Urbanecm renamed this task from Beta cluster is down to Table 'enwiki.blobs' doesn't exist thrown on beta after 45831e6.Aug 25 2019, 4:38 PM
Urbanecm updated the task description. (Show Details)
gerritbot added a comment.Aug 25 2019, 4:39 PM

Change 532248 had a related patch set uploaded (by Urbanecm; owner: Urbanecm):
[mediawiki/core@master] Revert "rdbms: make LoadBalancer::reallyOpenConnection() handle setting DBO_TRX"

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

gerritbot added a project: Patch-For-Review.Aug 25 2019, 4:39 PM
Krinkle assigned this task to aaron.Aug 25 2019, 4:40 PM
Krinkle lowered the priority of this task from Unbreak Now! to Low.
Krinkle edited projects, added MediaWiki-libs-Rdbms, Performance-Team; removed Beta-Cluster-Infrastructure.
Restricted Application added a project: Platform Engineering. · View Herald TranscriptAug 25 2019, 4:40 PM
Rxy removed aaron as the assignee of this task.Aug 25 2019, 4:40 PM
Rxy raised the priority of this task from Low to Unbreak Now!.
Rxy added a project: MediaWiki-General.
Rxy added a subscriber: aaron.
Krinkle added a subscriber: Krinkle.Aug 25 2019, 4:41 PM

Immediate issue is resolved in master and beta (prod was not yet affected). Assigning to patch author as low-prio to solve in a re-submission.

Krinkle assigned this task to aaron.Aug 25 2019, 4:41 PM
Krinkle lowered the priority of this task from Unbreak Now! to Low.
Krinkle removed projects: MediaWiki-General, Platform Engineering.
Urbanecm added a comment.Aug 25 2019, 4:41 PM

I assume that was an edit conflict :)

Krinkle renamed this task from Table 'enwiki.blobs' doesn't exist thrown on beta after 45831e6 to DBQueryError from ExternalStoreDB::fetchBlob: Table 'enwiki.blobs' doesn't exist.Aug 25 2019, 4:41 PM
Krinkle removed a project: Patch-For-Review.
Stashbot added a comment.Aug 25 2019, 4:43 PM

Mentioned in SAL (#wikimedia-releng) [2019-08-25T16:43:28Z] <Urbanecm> Revert 'Revert 45831e6 locally on beta cluster to test possible root cause of T231162'

gerritbot added a comment.Aug 25 2019, 5:09 PM

Change 532248 merged by jenkins-bot:
[mediawiki/core@master] Revert "rdbms: make LoadBalancer::reallyOpenConnection() handle setting DBO_TRX"

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

ReleaseTaggerBot added a project: MW-1.34-notes (1.34.0-wmf.20; 2019-08-27).Aug 25 2019, 6:00 PM
kchapman moved this task from Inbox, needs triage to Doing (old) on the Performance-Team board.Aug 26 2019, 8:15 PM
gerritbot added a comment.Aug 27 2019, 7:47 AM

Change 532551 had a related patch set uploaded (by Aaron Schulz; owner: Aaron Schulz):
[mediawiki/core@master] externalstore: deprecate getLBInfo() dependency in ExternalStoreDB

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

gerritbot added a project: Patch-For-Review.Aug 27 2019, 7:47 AM
Krinkle edited projects, added MediaWiki-Core-Revision-backend; removed MediaWiki-libs-Rdbms.Aug 29 2019, 10:36 AM
Krinkle moved this task from Untriaged to ExternalStore on the MediaWiki-Core-Revision-backend board.
aaron added a project: Platform Team Workboards (Clinic Duty Team).Sep 5 2019, 6:06 PM
• mobrovac moved this task from Inbox to External Code Review Completed on the Platform Team Workboards (Clinic Duty Team) board.Sep 10 2019, 11:35 AM
gerritbot added a comment.Sep 10 2019, 11:59 AM

Change 532551 merged by jenkins-bot:
[mediawiki/core@master] externalstore: deprecate getLBInfo() dependency in ExternalStoreDB

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

ReleaseTaggerBot edited projects, added MW-1.34-notes (1.34.0-wmf.22; 2019-09-10); removed MW-1.34-notes (1.34.0-wmf.20; 2019-08-27).Sep 10 2019, 12:00 PM
Maintenance_bot removed a project: Patch-For-Review.Sep 10 2019, 12:10 PM
aaron closed this task as Resolved.Sep 12 2019, 7:24 AM
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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