[05:55:12] 10DBA, 13Patch-For-Review: Unify revision table on s7 - https://phabricator.wikimedia.org/T160390#3167364 (10Marostegui) db1033 and dbstore1001 are done: ``` root@neodymium:/home/marostegui# for i in `cat s7_T160390`; do echo $i; mysql --skip-ssl -hdb1033.eqiad.wmnet $i -e "show create table revision\G" | egre... [06:02:46] 10DBA, 10Wikimedia-Site-requests, 13Patch-For-Review: Recreate a wiki for Wikimedia Portugal - https://phabricator.wikimedia.org/T126832#2055502 (10Marostegui) From the DBA side, we are just waiting for @Dereckson to let us know when this want to be done as Jaime expressed here: T126832#3117923 [06:05:40] 10DBA, 06Operations, 10hardware-requests, 10ops-codfw: codfw: (1) spare pool system for temp allocation as database failover - https://phabricator.wikimedia.org/T161712#3167374 (10Marostegui) [06:05:41] 10DBA, 06Operations, 10ops-codfw, 13Patch-For-Review: setup tempdb2001(WMF6407) - https://phabricator.wikimedia.org/T162290#3167372 (10Marostegui) 05Open>03Resolved Hi, I have merged the patch to add it as a slave in codfw and the puppet temporary change to get it with sync_binlog=0 and innodb_flush... [06:20:07] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10MediaWiki-extensions-WikibaseRepository, 10Wikidata: Choose a field length for entity id columns and stick to it - https://phabricator.wikimedia.org/T162562#3167056 (10Marostegui) Once you've decided which size goes best for the needs and the future, just let... [06:34:16] 07Blocked-on-schema-change, 10Wikidata, 03Wikidata-Sprint: Deploy schema change for adding term_full_entity_id column to wb_terms table - https://phabricator.wikimedia.org/T162539#3167422 (10Marostegui) I will start this once it is deployed. Please note that we (the DBAs) have decided to put ourselves some d... [07:06:27] 10DBA, 10Cognate, 10Wikidata, 10Wikimedia-Extension-setup, and 3 others: Create SQL database and Tables for Cognate extension to be used on Wiktionaries - https://phabricator.wikimedia.org/T162252#3167440 (10Marostegui) Hello, So I have created the db and the 3 tables in the following production hosts (w... [07:50:03] 10DBA, 10Wikimedia-Site-requests, 13Patch-For-Review: Recreate a wiki for Wikimedia Portugal - https://phabricator.wikimedia.org/T126832#3167554 (10Dereckson) Thanks to have confirmed your interest @waldyrious, we currently have several wikis to create, and wait logos for them, so my first intent was to do a... [08:18:23] 10DBA, 10Wikimedia-Site-requests, 13Patch-For-Review: Recreate a wiki for Wikimedia Portugal - https://phabricator.wikimedia.org/T126832#3167597 (10Marostegui) >>! In T126832#3167554, @Dereckson wrote: > Thanks to have confirmed your interest @waldyrious, we currently have several wikis to create, and wait l... [08:23:38] 10DBA, 10Wikimedia-Site-requests, 13Patch-For-Review: Recreate a wiki for Wikimedia Portugal - https://phabricator.wikimedia.org/T126832#3167604 (10Dereckson) And 17 is still Easter, so next week seems difficult. Monday 24 is then the first available deployment day afterwards.I tentatively scheduled a window... [09:28:47] 10DBA, 10Cognate, 10Wikidata, 10Wikimedia-Extension-setup, and 3 others: Create SQL database and Tables for Cognate extension to be used on Wiktionaries - https://phabricator.wikimedia.org/T162252#3167753 (10Addshore) >>! In T162252#3167440, @Marostegui wrote: > I will discuss with Jaime what to do with db... [11:35:07] 07Blocked-on-schema-change, 10Wikidata, 03Wikidata-Sprint: Deploy schema change for adding term_full_entity_id column to wb_terms table - https://phabricator.wikimedia.org/T162539#3167923 (10Ladsgroup) It's already merged but given that it's in wmf.20, it'll be deployed in 11th in test wikis and 12th on Wiki... [11:37:59] 07Blocked-on-schema-change, 10Wikidata, 03Wikidata-Sprint: Deploy schema change for adding term_full_entity_id column to wb_terms table - https://phabricator.wikimedia.org/T162539#3167927 (10Marostegui) >>! In T162539#3167923, @Ladsgroup wrote: > It's already merged but given that it's in wmf.20, it'll be de... [11:40:58] 10DBA, 10Cognate, 10Wikidata, 10Wikimedia-Extension-setup, and 3 others: Create SQL database and Tables for Cognate extension to be used on Wiktionaries - https://phabricator.wikimedia.org/T162252#3167934 (10Marostegui) >>! In T162252#3167753, @Addshore wrote: > > So although replication to labs is not a... [11:54:53] 10DBA: Run pt-table-checksum on s4 (commonswiki) - https://phabricator.wikimedia.org/T162593#3167981 (10Marostegui) [12:00:11] 10DBA: Run pt-table-checksum on s4 (commonswiki) - https://phabricator.wikimedia.org/T162593#3168006 (10Marostegui) Filters enabled on rc slaves: ``` Replicate_Wild_Ignore_Table: commonswiki.__wmf_checksums ``` [12:57:38] 10DBA: Run pt-table-checksum on s4 (commonswiki) - https://phabricator.wikimedia.org/T162593#3168173 (10Marostegui) This is now running, I am closely monitoring for this first run to make sure no lag is generated (I would be surprised if we have any, as we haven't had any on any of the other shards) [12:58:12] 10DBA: Run pt-table-checksum on s4 (commonswiki) - https://phabricator.wikimedia.org/T162593#3168178 (10Marostegui) [12:59:17] 10DBA: run pt-tablechecksum on s5 - https://phabricator.wikimedia.org/T161294#3168182 (10Marostegui) [13:00:06] 10DBA: Run pt-table-checksum on s4 (commonswiki) - https://phabricator.wikimedia.org/T162593#3167981 (10Marostegui) [13:00:26] 10DBA, 06Operations, 13Patch-For-Review: Decommission old coredb machines (<=db1050) - https://phabricator.wikimedia.org/T134476#3168199 (10Marostegui) [13:00:28] 10DBA: Run pt-table-checksum on s4 (commonswiki) - https://phabricator.wikimedia.org/T162593#3168198 (10Marostegui) [13:50:13] 10DBA, 07Epic, 05codfw-rollout: Database maintenance scheduled while eqiad datacenter is non primary (after the DC switchover) - https://phabricator.wikimedia.org/T155099#3168352 (10Marostegui) I have added the "failover schedule" on the wikipage [14:07:35] 10DBA, 13Patch-For-Review: Unify revision table on s7 - https://phabricator.wikimedia.org/T160390#3168366 (10Marostegui) db1028 is done: ``` root@neodymium:/home/marostegui# for i in `cat s7_T160390`; do echo $i; mysql --skip-ssl -hdb1028.eqiad.wmnet $i -e "show create table revision\G" | egrep "KEY";done arwi... [14:13:12] 10DBA, 13Patch-For-Review: Unify revision table on s7 - https://phabricator.wikimedia.org/T160390#3168383 (10Marostegui) The only production host pending is the master, which I will do tomorrow morning. Apart from that one, only labsdb1003 and db1069 are left. labsdb1001 (is currently being done) [15:10:43] 10DBA: Unify revision table on s2 - https://phabricator.wikimedia.org/T162611#3168583 (10Marostegui) [15:11:01] 10DBA: Unify revision table on s2 - https://phabricator.wikimedia.org/T162611#3168583 (10Marostegui) p:05Triage>03Normal [15:11:17] 10DBA: Unify revision table on s2 - https://phabricator.wikimedia.org/T162611#3168583 (10Marostegui) [15:11:19] 07Blocked-on-schema-change, 10DBA, 05MW-1.28-release (WMF-deploy-2016-08-30_(1.28.0-wmf.17)), 05MW-1.28-release-notes, 13Patch-For-Review: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#3168599 (10Marostegui) [16:35:12] 10DBA, 06Labs, 10Tool-Labs, 10Tool-Labs-tools-Other: s51362 has been rate limited to 2 concurrent connections for creating hundreds of 1400-second queries to labsdb1001 and labsdb1003 every 10 seconds - https://phabricator.wikimedia.org/T162519#3168791 (10madhuvishy) Noting here that s51362 is the mysql us... [17:09:08] 10DBA, 06Operations, 10ops-codfw, 13Patch-For-Review: codfw rack/setup 22 DB servers - https://phabricator.wikimedia.org/T162159#3168887 (10Papaul) [23:16:20] 10DBA, 06Labs, 07Regression: Tool Labs: Add skin, language, and variant to user_properties_anon - https://phabricator.wikimedia.org/T152043#3170033 (10Krinkle)