quarry is unable to access enwiki_p.page table
Closed, ResolvedPublicBUG REPORT
Actions

Assigned To

Authored By

	Xaosflux
	May 31 2022, 12:13 AM

Description

List of steps to reproduce (step by step, including full links if applicable):

Use quarry <quarry.wmcloud.org> on database enwiki_p
Attempt to access the page table, e.g.
SELECT * FROM page LIMIT 10

What happens?:

query fails with error: "View 'enwiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"

What should have happened instead?:

The query should return. (This does work on other databases, such as eswiki_p)

Software version (if not a Wikimedia wiki), browser information, screenshots, other information, etc.:

Related Objects

Mentioned In: T309590: page table query error on s4 and s6 labs
T309569: HTTP 500 - View 'enwiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
T217364: Intermittent 1356 "references invalid table(s) or column(s)" errors with "page" view on enwiki.web.db.svc.eqiad.wmflabs
T157670: Periodically run refreshLinks.php on production sites.
Mentioned Here: T309567: huwiki_p.page query error
T60674: Drop page.page_restrictions column from Wikimedia wikis

Event Timeline

Xaosflux created this task.May 31 2022, 12:13 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 31 2022, 12:13 AM

Pppery mentioned this in T157670: Periodically run refreshLinks.php on production sites..May 31 2022, 12:31 AM

I'm also experience problems with 2 bots on en.wiki which haven't issued their regularly scheduled reports and receiving "overflow" messages when I try to look at page histories earlier today. Are these connected?

Update:Okay, so now it's 4 bots which have failed to issue their regularly scheduled reports.

Probably caused by T60674: Drop page.page_restrictions column from Wikimedia wikis

Pppery unsubscribed.May 31 2022, 12:48 AM

In T309570#7968876, @Pppery wrote:

Probably caused by T60674: Drop page.page_restrictions column from Wikimedia wikis

Perhaps an unintended side affect? I get the error on the entire table, not just that column.

Xaosflux edited projects, added Wikimedia-production-error; removed Quarry.May 31 2022, 1:05 AM

Xaosflux added a project: Quarry.

Pppery unsubscribed.May 31 2022, 1:29 AM

tstarling added a subscriber: Ladsgroup.May 31 2022, 1:36 AM

seems extremely similar to T309567, is there a parent outage?

Xaosflux mentioned this in T217364: Intermittent 1356 "references invalid table(s) or column(s)" errors with "page" view on enwiki.web.db.svc.eqiad.wmflabs.May 31 2022, 1:43 AM

Xaosflux mentioned this in T309569: HTTP 500 - View 'enwiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them.

Ran the maintain-views again on s1 clouddbs. It should be fixed now.

Izno merged a task: T309569: HTTP 500 - View 'enwiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them.May 31 2022, 3:19 AM

Izno added subscribers: Novem_Linguae, JJMC89.

Looks like everything is fixed now. Thank you for getting right on this bug report!

Snaevar mentioned this in T309590: page table query error on s4 and s6 labs.May 31 2022, 8:59 AM

Krinkle moved this task from Untriaged to May 2022 on the Wikimedia-production-error board.Jun 23 2022, 4:03 PM

quarry is unable to access enwiki_p.page tableClosed, ResolvedPublicBUG REPORTActions

Description

Related Objects

Event Timeline

quarry is unable to access enwiki_p.page table
Closed, ResolvedPublicBUG REPORT
Actions