Page MenuHomePhabricator

issue with accessing wbc_entity_usage from tools-db
Closed, ResolvedPublic

Description

No access to wbc_entity_usage in tools-db DB:

use enwiki_p;
select * from wbc_entity_usage limit 5;
ERROR 1356 (HY000): View 'enwiki_p.wbc_entity_usage' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Related Objects

Event Timeline

Possibly related to T144010?

select view_definition from information_schema.views where table_schema='enwiki_p' and table_name='wbc_entity_usage';

select `enwiki`.`wbc_entity_usage`.`eu_row_id` AS `eu_row_id`,`enwiki`.`wbc_entity_usage`.`eu_entity_id` AS `eu_entity_id`,`enwiki`.`wbc_entity_usage`.`eu_aspect` AS `eu_aspect`,`enwiki`.`wbc_entity_usage`.`eu_page_id` AS `eu_page_id`,`enwiki`.`wbc_entity_usage`.`eu_touched` AS `eu_touched` from `enwiki`.`wbc_entity_usage`
Marostegui edited projects, added Data-Services; removed DBA.

That is related to T144010 indeed.
The cloud-services-team need to re-create the views.

Should be good now.

select `enwiki`.`wbc_entity_usage`.`eu_row_id` AS `eu_row_id`,`enwiki`.`wbc_entity_usage`.`eu_entity_id` AS `eu_entity_id`,`enwiki`.`wbc_entity_usage`.`eu_aspect` AS `eu_aspect`,`enwiki`.`wbc_entity_usage`.`eu_page_id` AS `eu_page_id` from `enwiki`.`wbc_entity_usage`
Bstorm claimed this task.