Page MenuHomePhabricator

View 'thwiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Closed, ResolvedPublic

Description

For some reasons even simple queries like select * from thwiki_p.page limit 10; does not work. Verified through replica under my labs account and quarry: https://quarry.wmflabs.org/query/23037

Event Timeline

@Ghuron: Where is the initial place where you found this? :) (I'm wondering which project tag this task should get, so the task will appear on a workboard.)

@Aklapper I've found it in my labs project mw2sparql (it was bgwiki_p initially 07:34 UTC today) but since that I'm repoducing this in quarry (see link above). Sounds like operation issue with db replicas

Kizule subscribed.

I can reproduce this problem only for thwiki_p.page: https://quarry.wmflabs.org/query/31779

I tryed with srwiki, it works without problems: https://quarry.wmflabs.org/query/31781

This also happens on zhwiki_p.page.

@Bstorm Mind looking into this? It's affecting some heavily accessed tables like dewiki.page.

This is related to T86338
I just have to rebuild those views today.

Done. That should have fixed this.

Fixed for all dbs mentioned above

[@Aklapper everything related to replicas/labs db/tools db is related to Data-Services. @Zoranzoki21 like in that case users can support their claims with a Quarry query link, but in most cases the tool is only used to visualize the behavior of labsdbs.]