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

2017-05-14 Thread Marostegui 
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 have to create a
 separate request for other wikis.


Ah, thanks for the good catch, I didn't know he meant s3 (I thought he was talking about another small host or something that wasn't on my radar, hence my two questions to see where that database he wanted to alter lives in, as I was planning to check the table size and if there were slaves or stuff).
I am glad you mentioned s3 now I have the full picture.

By the way:

root@db1075:/srv/sqldata/testwikidatawiki# ls -lh wb_terms.ibd
-rw-rw 1 mysql mysql 68M May 14 13:43 wb_terms.ibdTASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-14 Thread jcrespo 
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 other wikis.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, jcrespoCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-12 Thread aude 
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 wayTASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, audeCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-12 Thread Marostegui 
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 schema change test wikidata on terbium? (like how we add new tables) me or someone else can do that, if it is ok.


Hi!

I can do that, however I am a bit confused, is it terbium what you really mean?

root@terbium:~# ps aux | grep mysql
root 22730  0.0  0.0  12728  2216 pts/1S+   13:24   0:00 grep mysqlTASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-11 Thread Marostegui 
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 `term_full_entity` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-10 Thread Marostegui 
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` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-09 Thread aude 
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, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-09 Thread Ladsgroup 
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, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-09 Thread Ladsgroup 
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 DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, LadsgroupCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-08 Thread Marostegui 
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 `term_full_entity` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))

Only pending host is the codfw master which will be done tomorrow morning.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-08 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-08 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-08 Thread Marostegui 
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`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))

dbstore2001 is done:

root@neodymium:~# mysql --skip-ssl -hdbstore2001.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`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))

dbstore1002 is done:

root@neodymium:~# mysql --skip-ssl -hdbstore1002 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 `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-05 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-05 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-05 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-05 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-05 Thread Marostegui 
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 `term_full_entity` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-05 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-05 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread Marostegui 
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`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))

dbstore2002 is done:

root@neodymium:~# mysql --skip-ssl -hdbstore2002.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`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread Marostegui 
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`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-05-04 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-28 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-28 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-28 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-28 Thread Marostegui 
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 `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))

db1045 is done:

root@neodymium:~# mysql --skip-ssl -hdb1045 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 `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))

All the eqiad core hosts (dbstore servers pending) are now done.
This is not yet finished and this column cannot be used until this ticket gets fully resolved as it is not present on codfw yetTASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-27 Thread Marostegui 
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` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-27 Thread Marostegui 
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`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-27 Thread Stashbot 
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 DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-27 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread Marostegui 
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 `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))

TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread Marostegui 
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 this column before it is applied there, it will break replication on labs.


We have hotfixed the issue by removing an unused partition and adding it to the main volume. So l am re-running the ALTER on labsdb1001 now.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread Marostegui 
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 will break replication on labs.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Minhnv-2809, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread Marostegui 
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 `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-26 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-25 Thread Marostegui 
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`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))
root@neodymium:~# mysql --skip-ssl -hdb1063 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 `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-25 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-25 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread Marostegui 
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 `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread gerritbot 
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: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread Marostegui 
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` (`term_full_entity_id`),
  KEY `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-24 Thread Marostegui 
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 `term_search_full` (`term_language`,`term_full_entity_id`,`term_type`,`term_search_key`(16))TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-21 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-21 Thread Stashbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-21 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-21 Thread gerritbot 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-11 Thread aude 
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, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Salgo60, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-11 Thread Marostegui 
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 the schema change (as long as the code is merged).  I know we want to go ahead and get the schema change done while there is maintenance window.


That is fine, we can start deploying it. However, we, DBAs, have set up some "code freeze" of maintenance, for us, starting 12th (tomorrow) until the DC switchover (19th Apr), just to make sure we do not have long running maintenance, alters etc before the DC switch. So we will start this after that, the 20th maybe.
The most important thing is to get it done in eqiad while it is on stand by, and once it is switched back we can get it done on codfw, so I believe we are still good here.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Salgo60, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-11 Thread aude 
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 is merged).  I know we want to go ahead and get the schema change done while there is maintenance window.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: audeCc: jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Salgo60, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-10 Thread Marostegui 
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 change.
Thanks!TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Salgo60, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-10 Thread Ladsgroup 
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 PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Salgo60, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

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

2017-04-10 Thread Marostegui 
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 we will stop any maintenance until the switchover is done.

So this change will take a bit longer because of that maintenance freeze. Given that this only needs to be done on wikidata, I believe we should have no problem to get it done in eqiad while it is the standby datacenter. Specially on the master which is the hard part.

Please let us know once the patch is merged and we will start it.TASK DETAILhttps://phabricator.wikimedia.org/T162539EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, QZanden, Salgo60, Izno, Wikidata-bugs, Mbch331, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs