| Marostegui added a comment. |
@Andrew I do see the table on the view for wikidata on labsdb1001 and labsdb1009 for instance on both, the normal db and the _p db:
mysql:root@localhost [wikidatawiki]> show tables like 'wb_terms'; +-----------------------------------+ | Tables_in_wikidatawiki (wb_terms) | +-----------------------------------+ | wb_terms | +-----------------------------------+ 1 row in set (0.00 sec)
mysql:root@localhost [wikidatawiki]> use wikidatawiki_p
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql:root@localhost [wikidatawiki_p]> show tables like 'wb_terms';
+-------------------------------------+
| Tables_in_wikidatawiki_p (wb_terms) |
+-------------------------------------+
| wb_terms |
+-------------------------------------+
1 row in set (0.00 sec)
mysql:root@localhost [wikidatawiki_p]> select * from wb_terms limit 1;
+-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+
| term_row_id | term_entity_id | term_full_entity_id | term_entity_type | term_language | term_type | term_text | term_search_key | term_weight |
+-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+
| 363474 | 50445 | Q50445 | item | en-gb | label | Jungwon-gu | jungwon-gu | 0 |
+-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+
1 row in set (0.00 sec)
mysql:root@localhost [wikidatawiki_p]> show create table wb_terms\G
*************************** 1. row ***************************
View: wb_terms
Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `wb_terms` AS select `wikidatawiki`.`wb_terms`.`term_row_id` AS `term_row_id`,`wikidatawiki`.`wb_terms`.`term_entity_id` AS `term_entity_id`,`wikidatawiki`.`wb_terms`.`term_full_entity_id` AS `term_full_entity_id`,`wikidatawiki`.`wb_terms`.`term_entity_type` AS `term_entity_type`,`wikidatawiki`.`wb_terms`.`term_language` AS `term_language`,`wikidatawiki`.`wb_terms`.`term_type` AS `term_type`,`wikidatawiki`.`wb_terms`.`term_text` AS `term_text`,`wikidatawiki`.`wb_terms`.`term_search_key` AS `term_search_key`,`wikidatawiki`.`wb_terms`.`term_weight` AS `term_weight` from `wikidatawiki`.`wb_terms`
character_set_client: utf8
collation_connection: utf8_general_ci
1 row in set (0.00 sec)Not sure if we are looking at the same thing.
TASK DETAIL
EMAIL PREFERENCES
To: Andrew, Marostegui
Cc: Marostegui, Andrew, bd808, Pasleim, PokestarFan, chasemp, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, IMBLUESKY, GoranSMilovanovic, QZanden, Tbscho, JJMC89, Luke081515, Wikidata-bugs, Gryllida, scfc, Mbch331, Krenair
Cc: Marostegui, Andrew, bd808, Pasleim, PokestarFan, chasemp, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, IMBLUESKY, GoranSMilovanovic, QZanden, Tbscho, JJMC89, Luke081515, Wikidata-bugs, Gryllida, scfc, Mbch331, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
