[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. In T162539#3260955, @jcrespo wrote: @aude: don't run update.php on s3 for altering a table- you will create lag on 900 wikis unless connections are cleared and table is pre-warmed-up (and appropiately tested). Also, the only wiki mentioned here was wikidatawiki, you

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

jcrespo added a comment. @aude: don't run update.php on s3 for altering a table- you will create lag on 900 wikis unless connections are cleared and table is pre-warmed-up (and appropiately tested). Also, the only wiki mentioned here was wikidatawiki, you have to create a separate request for

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

aude added a comment. @Marostegui for small schema changes (e.g. adding a table, or for small wikis like test wikidata), we normally apply schema changes run it via mediawiki maintenance script: https://www.mediawiki.org/wiki/Manual:Sql.php We should just be sure it's okay to do this one this

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. In T162539#3258455, @aude wrote: i checked test wikidata (testwikidatawiki) and it needs the change also. the tables there tend to be small. select count(*) from wb_terms; +--+ | count(*) | +--+ | 192947 | +--+ Is it safe to apply this

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. dbstore1001 is done: root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdbstore1001 wikidatawiki -e "show create table wb_terms\G" | egrep "term_full_entity_id|term_search_full" `term_full_entity_id` varbinary(32) DEFAULT NULL, KEY

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. codfw master, db2023 is done: root@neodymium:~# mysql --skip-ssl -hdb2023.codfw.wmnet wikidatawiki -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`

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

aude added a comment. @jcrespo no hurry on our side. (was just more curious how this is going and seems good to me)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, audeCc: Stashbot, hoo, jcrespo,

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Ladsgroup added a comment. My apologies. I was a little bit confused about the codfw master. Thanks for letting me know.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, LadsgroupCc: Stashbot, hoo,

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Ladsgroup added a comment. Hey @Marostegui, I can't see db2023 (master in codfw) gets deplooed and repooled (maybe you don't do that for masters). But I don't know if this schema change is done for db2023 or not. Please tell me once it's done, so we deploy the config change.TASK

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db2038 is done: root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb2038.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "term_full_entity_id|term_search_full" `term_full_entity_id` varbinary(32) DEFAULT NULL, KEY

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 352543 merged by jenkins-bot: [operations/mediawiki-config@master] db-codfw.php: Repool db2045, depool db2038 https://gerrit.wikimedia.org/r/352543TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 352543 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/mediawiki-config@master] db-codfw.php: Repool db2045, depool db2038 https://gerrit.wikimedia.org/r/352543TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db2045 is done: root@neodymium:~# mysql --skip-ssl -hdb2045.codfw.wmnet wikidatawiki -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`),

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-05T15:28:12Z] Synchronized wmf-config/db-codfw.php: Repool db2052, depool db2045 - T162539 T163548 (duration: 00m 41s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-05T15:28:21Z] Deploy alter table on wikidatawiki.wb_terms - db2045 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 352167 merged by jenkins-bot: [operations/mediawiki-config@master] db-codfw.php: Repool db2052, depool db2045 https://gerrit.wikimedia.org/r/352167TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 352167 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/mediawiki-config@master] db-codfw.php: Repool db2052, depool db2045 https://gerrit.wikimedia.org/r/352167TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db2052 is done: root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb2052.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "term_full_entity_id|term_search_full" `term_full_entity_id` varbinary(32) DEFAULT NULL, KEY

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-05T07:49:15Z] Deploy alter table on wikidatawiki.wb_terms - dbstore1002 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-05T07:11:58Z] Deploy alter table on wikidatawiki.wb_terms - dbstore2001 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-05T05:55:19Z] Deploy alter table on wikidatawiki.wb_terms - db2052 - T162539 T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-05T05:55:01Z] Synchronized wmf-config/db-codfw.php: Repool db2059, depool db2052 - T162539 T163548 (duration: 00m 40s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 352076 merged by jenkins-bot: [operations/mediawiki-config@master] db-codfw.php: Repool db2059, depool db2052 https://gerrit.wikimedia.org/r/352076TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 352076 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/mediawiki-config@master] db-codfw.php: Repool db2059, depool db2052 https://gerrit.wikimedia.org/r/352076TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db2059 is done: root@neodymium:~# mysql --skip-ssl -hdb2059.codfw.wmnet wikidatawiki -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`),

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-04T15:16:17Z] Deploy alter table on wikidatawiki.wb_terms - db2059- https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-04T15:14:28Z] Synchronized wmf-config/db-codfw.php: Repool db2066, depool db2059 - T162539 T163548 (duration: 01m 06s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 351858 merged by jenkins-bot: [operations/mediawiki-config@master] db-codfw.php: Repool db2066, depool db2059 https://gerrit.wikimedia.org/r/351858TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 351858 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/mediawiki-config@master] db-codfw.php: Repool db2066, depool db2059 https://gerrit.wikimedia.org/r/351858TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db2066 is done: root@neodymium:~# mysql --skip-ssl -hdb2066.codfw.wmnet wikidatawiki -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`),

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-04T06:10:26Z] Deploy alter table on wikidatawiki.wb_terms - db2066 - T162539 T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-04T06:10:09Z] Synchronized wmf-config/db-codfw.php: Depool db2066 - T162539 T163548 (duration: 01m 25s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 351766 merged by jenkins-bot: [operations/mediawiki-config@master] db-codfw.php: Depool db2066 https://gerrit.wikimedia.org/r/351766TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 351766 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/mediawiki-config@master] db-codfw.php: Depool db2066 https://gerrit.wikimedia.org/r/351766TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-05-04T06:03:48Z] Deploy alter table on wikidatawiki.wb_terms - dbstore2002 - T162539 T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-28T07:58:44Z] Synchronized wmf-config/db-eqiad.php: Repool db1045 - T162539 T163548 (duration: 02m 38s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 350798 merged by jenkins-bot: [operations/mediawiki-config@master] db-eqiad.php: Repool db1045 https://gerrit.wikimedia.org/r/350798TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 350798 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/mediawiki-config@master] db-eqiad.php: Repool db1045 https://gerrit.wikimedia.org/r/350798TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db1049 is done: root@neodymium:~# mysql --skip-ssl -hdb1049 wikidatawiki -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

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db1070 is done: root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1070 wikidatawiki -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`

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db1069 is done: root@db1069:~# mysql -S /tmp/mysql.s5.sock --skip-ssl wikidatawiki -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`),

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-27T06:11:00Z] Deploy alter table on s5 (wikidatawiki) on db1070 (running locally instead of neodymium as this host will be affected by the network maintenance) - T130067 T162539TASK

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-27T05:59:54Z] Deploy alter table labsdb1003 (wikidatawiki) https://phabricator.wikimedia.org/T162539%C2%A0https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. labsdb1001 is done: [root@labsdb1001 05:57 /root] # mysql wikidatawiki -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

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. In T162539#3214508, @Marostegui wrote: For the record: the alter on labsdb1001 has been killed because we ran out of space there, same thing will happen on labsdb1003, so we need to find a solution for those two hosts before applying this change. If we start using

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. For the record: the alter on labsdb1001 has been killed because we ran out of space there, same thing will happen on labsdb1003, so we need to find a solution for those two hosts before applying this change. If we start using this column before it is applied there, it

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-26T14:00:30Z] Synchronized wmf-config/db-eqiad.php: Repool db1026, depool db1045 - T162539 T163548 (duration: 00m 53s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 350411 merged by jenkins-bot: [operations/mediawiki-config@master] db-eqiad.php: Repool db1026, depool db1045 https://gerrit.wikimedia.org/r/350411TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-26T13:29:44Z] Deploy alter table on db1069 (wikidatawiki) https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-26T13:27:01Z] Deploy alter table labsdb1001 https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-26T13:23:23Z] Deploy alter table db1045 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 350411 had a related patch set uploaded (by Marostegui): [operations/mediawiki-config@master] db-eqiad.php: Repool db1026 https://gerrit.wikimedia.org/r/350411TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db1026 is done root@neodymium:~# mysql --skip-ssl -hdb1026 wikidatawiki -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

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-26T06:56:08Z] Synchronized wmf-config/db-eqiad.php: Repool db1071 - T162539 T163548 (duration: 02m 24s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 350369 merged by jenkins-bot: [operations/mediawiki-config@master] db-eqiad.php: Repool db1071 https://gerrit.wikimedia.org/r/350369TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 350369 had a related patch set uploaded (by Marostegui): [operations/mediawiki-config@master] db-eqiad.php: Repool db1071 https://gerrit.wikimedia.org/r/350369TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db1071 and db1063 are done: root@neodymium:~# mysql --skip-ssl -hdb1071 wikidatawiki -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`),

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-25T06:06:12Z] Synchronized wmf-config/db-eqiad.php: Repool db1071, depool db1026 - T162539 T163548 (duration: 01m 17s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 350119 merged by jenkins-bot: [operations/mediawiki-config@master] db-eqiad.php: Depool db1071 and db1026 https://gerrit.wikimedia.org/r/350119TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 350119 had a related patch set uploaded (by Marostegui): [operations/mediawiki-config@master] db-eqiad.php: Depool db1071 and db1026 https://gerrit.wikimedia.org/r/350119TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db1082 is done: root@neodymium:~# mysql --skip-ssl -hdb1082 wikidatawiki -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

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 349953 abandoned by Marostegui: db-eqiad.php: Depool db1082 Reason: not needed https://gerrit.wikimedia.org/r/349953TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To:

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-24T13:12:04Z] Deploy alter table on wikidatawiki.wb_terms on db1082 - T162539 - T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-24T13:11:03Z] Deploy alter table on wikidatawiki.wb_terms on db1063 - T162539 https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 349953 had a related patch set uploaded (by Marostegui): [operations/mediawiki-config@master] db-eqiad.php: Depool db1082 https://gerrit.wikimedia.org/r/349953TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db1087 is done: root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1087 wikidatawiki -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`

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-24T06:12:44Z] Deploy alter table on wikidatawiki.wb_terms on db1087 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-24T06:12:32Z] Synchronized wmf-config/db-eqiad.php: Repool db1092, depoll db1087 - T162539 T163548 (duration: 02m 19s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 349870 merged by jenkins-bot: [operations/mediawiki-config@master] db-eqiad.php: Repool db1092, depool db1087 https://gerrit.wikimedia.org/r/349870TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 349870 had a related patch set uploaded (by Marostegui): [operations/mediawiki-config@master] db-eqiad.php: Repool db1092, depool db1087 https://gerrit.wikimedia.org/r/349870TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. db1092 is done: root@neodymium:~# mysql --skip-ssl -hdb1092 wikidatawiki -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

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-21T13:35:33Z] Deploy alter table on wikidatawiki.wb_terms on db1092 - T162539 T163548TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2017-04-21T13:20:29Z] Synchronized wmf-config/db-eqiad.php: Depool db1092 - T162539 T163548 (duration: 01m 18s)TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 349430 merged by jenkins-bot: [operations/mediawiki-config@master] db-eqiad.php: Depool db1092 https://gerrit.wikimedia.org/r/349430TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

gerritbot added a comment. Change 349430 had a related patch set uploaded (by Marostegui): [operations/mediawiki-config@master] db-eqiad.php: Depool db1092 https://gerrit.wikimedia.org/r/349430TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

aude added a comment. @Marostegui I think starting around the ~20th (or whatever you think best) is good with us.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: audeCc: jcrespo, Marostegui, WMDE-leszek,

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. In T162539#3170794, @aude wrote: I am not sure we are deploying new Wikidata code this week. (we normally deploy every other week) If you really want it deployed, maybe we could backport this, but in the past it's not been necessary to have the code deployed yet to do

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

aude added a comment. I am not sure we are deploying new Wikidata code this week. (we normally deploy every other week) If you really want it deployed, maybe we could backport this, but in the past it's not been necessary to have the code deployed yet to do the schema change (as long as the code

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. In T162539#3167923, @Ladsgroup wrote: It's already merged but given that it's in wmf.20, it'll be deployed in 11th in test wikis and 12th on Wikidata. I don't if that would work for you. Sure, that is ok. Let's wait for it to be deployed before starting the schema

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Ladsgroup added a comment. It's already merged but given that it's in wmf.20, it'll be deployed in 11th in test wikis and 12th on Wikidata. I don't if that would work for you.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table

Marostegui added a comment. I will start this once it is deployed. Please note that we (the DBAs) have decided to put ourselves some dates to stop maintenance before the DC switchover and the switch back. That is the 12th (until the 20th) of April and 28th April until the 4th of May, at those days