[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
gerritbot added a comment. Change 357369 abandoned by Rush: Whitelist term_full_entity_id in wb_terms table Reason: if we ever go back to using this it needs a complete overhaul so let's not give the illusion of up to dateness https://gerrit.wikimedia.org/r/357369TASK DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Andrew, gerritbotCc: Marostegui, Andrew, bd808, Pasleim, PokestarFan, chasemp, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Lahi, aborrero, 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
[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
daniel added a comment. Thank you all for sorting this out! @Andrew For the record: yes, wb_terms is wikidata only (and wikidata test). Generally, tables with the wb_ prefix are only for wikibase repos, while the wbc_ prefix is used for tables on wikibase clients. Note that with the SDC project, commons will become a wikibase repo, and get the respective tables.TASK DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Andrew, danielCc: 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
[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
Ladsgroup added a comment. I just logged in and it works as expected, we should close this now. Thank you :)TASK DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Andrew, LadsgroupCc: 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
[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
Andrew added a comment. ok -- I was expecting this table to be present in enwiki. If it's wikidata-specific then we're probably done. @Ladsgroup can you confirm?TASK DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: AndrewCc: 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
[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
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 DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Andrew, MarosteguiCc: 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
[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
Ladsgroup added a comment. It's blocking our workTASK DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: Pasleim, PokestarFan, chasemp, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Tbscho, Lewizho99, JJMC89, Maathavan, anirudh24seven, Izno, Wikidata-bugs, Gryllida, scfc, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
Ladsgroup added a comment. Okay, the population is done and we can pick this up now. One thing to note that, in the file you mentioned above wb_terms is already in full_view mode so I guess there is nothing needs to be done except a round of maintain-view on labsdbs. The data is very public and we don't store in private data in it. I think I can ask #security to take a look though.TASK DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: PokestarFan, chasemp, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Tbscho, Lewizho99, Maathavan, anirudh24seven, Izno, Wikidata-bugs, Gryllida, scfc, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
Ladsgroup added a comment. 92% of the populating the table has been done now and it will finish by Thursday, I think we should pick this task up.TASK DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: PokestarFan, chasemp, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Tbscho, Lewizho99, Maathavan, anirudh24seven, Izno, Wikidata-bugs, Gryllida, scfc, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
daniel added a comment. I'm dubious about exposing this table to labs tools before it is fully populated. This at least needs a warning somewhere...TASK DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Ladsgroup, danielCc: WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Tbscho, Lewizho99, Maathavan, Izno, Wikidata-bugs, Gryllida, scfc, Mbch331, chasemp___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T167114: Open view for term_full_entity_id in wb_terms table in labs
gerritbot added a comment. Change 357369 had a related patch set uploaded (by Ladsgroup; owner: Amir Sarabadani): [operations/software/labsdb-auditor@master] Whitelist term_full_entity_id in wb_terms table https://gerrit.wikimedia.org/r/357369TASK DETAILhttps://phabricator.wikimedia.org/T167114EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: gerritbotCc: WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, GoranSMilovanovic, QZanden, Tbscho, Izno, Wikidata-bugs, Gryllida, scfc, Mbch331, chasemp___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs