[Wikidata-bugs] [Maniphest] [Commented On] T165246: Add term_full_entity_id column to wb_terms table on testwikidatawiki

Tue, 16 May 2017 04:08:59 -0700

Marostegui added a comment.

Deployed on db1069 (sanitarium) and replicated to labsdb1001 and labsdb1003

root@neodymium:/home/marostegui/git/software/dbtools#  mysql --skip-ssl -hdb1069 -P3313 testwikidatawiki -e "show create table wb_terms\G" |egrep "term_full_entity_id|term_search_full"
  `term_full_entity_id` varbinary(32) DEFAULT NULL,
  KEY `term_full_entity` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))


Deployed on db1095 (sanitarium2) and replicated to labsdb1009, labsdb1010 and labsdb1011.



root@neodymium:/home/marostegui/git/software/dbtools#  mysql --skip-ssl -hdb1095 testwikidatawiki -e "show create table wb_terms\G" |egrep "term_full_entity_id|term_search_full"
  `term_full_entity_id` varbinary(32) DEFAULT NULL,
  KEY `term_full_entity` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))



Deployed on dbstore1002



root@neodymium:/home/marostegui/git/software/dbtools#  mysql --skip-ssl -hdbstore1002 testwikidatawiki -e "show create table wb_terms\G" |egrep "term_full_entity_id|term_search_full"
  `term_full_entity_id` varbinary(32) DEFAULT NULL,
  KEY `term_full_entity` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))



Deployed on dbstore1001



root@neodymium:/home/marostegui/git/software/dbtools#  mysql --skip-ssl -hdbstore1001 testwikidatawiki -e "show create table wb_terms\G" |egrep "term_full_entity_id|term_search_full"
  `term_full_entity_id` varbinary(32) DEFAULT NULL,
  KEY `term_full_entity` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))



Going for production slaves now.

TASK DETAIL
https://phabricator.wikimedia.org/T165246

EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui
Cc: Stashbot, Marostegui, jcrespo, aude, Aklapper, GoranSMilovanovic, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to