[06:14:03] <wikibugs>	 10DBA, 10Operations, 10ops-codfw, 10Patch-For-Review: rack/setup/deploy codfw dedicated backup recovery/provisioning hosts - https://phabricator.wikimedia.org/T218336 (10Marostegui)
[06:29:52] <wikibugs>	 10DBA, 10MediaWiki-Cache, 10Patch-For-Review, 10Performance-Team (Radar), 10User-Marostegui: Replace parsercache keys to something more meaningful on db-XXXX.php - https://phabricator.wikimedia.org/T210725 (10Marostegui) I would like to start moving this forward. I want to merge https://gerrit.wikimedia....
[06:42:27] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad: db1078 s3 primary DB master BBU pre-failure - https://phabricator.wikimedia.org/T219115 (10Marostegui)
[06:42:45] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad: db1078 s3 primary DB master BBU pre-failure - https://phabricator.wikimedia.org/T219115 (10Marostegui) p:05Triage→03High Setting this to high priority as this is s3 primary database master.
[07:20:24] <wikibugs>	 10DBA, 10Data-Services: Discrepancies with logging table on different wikis - https://phabricator.wikimedia.org/T71127 (10Marostegui)
[07:20:29] <wikibugs>	 10Blocked-on-schema-change, 10MediaWiki-Database, 10MW-1.32-notes (WMF-deploy-2018-07-17 (1.32.0-wmf.13)), 10Schema-change: Add index log_type_action - https://phabricator.wikimedia.org/T51199 (10Marostegui)
[08:19:59] <jynus>	 I found the issue with failed backup statistics- if there were 2 backups of the same section at the same time, even on different dcs, statistics got confused
[08:20:19] <marostegui>	 oh
[08:20:29] <marostegui>	 did you catch the bug on why they get confused?
[08:20:33] <marostegui>	 is it the select?
[10:49:04] <wikibugs>	 10DBA: Purchase and setup remaining hosts for database backups - https://phabricator.wikimedia.org/T213406 (10Marostegui)
[10:49:17] <marostegui>	 I am updating the meeting's path, also the backup section with some updates about the procurement/hw status
[13:46:55] <marostegui>	 any objections to push https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/498768/ ?
[13:54:32] <mutante>	 marostegui: i think you have a tyo
[13:54:34] <mutante>	 typo
[13:55:10] <mutante>	 labsdb10[10-12] should be  labsdb101[0-2]
[13:55:18] <marostegui>	 mutante: That's what reviews are for!
[13:55:22] <marostegui>	 mutante: indeed! :)
[13:55:24] <marostegui>	 thank you!
[13:55:41] <mutante>	 ok, reviewed. n
[13:55:42] <marostegui>	 actually, it is the same thing
[13:55:43] <marostegui>	 no?
[13:56:05] <marostegui>	 I mean, it will match the same thing
[13:56:09] <marostegui>	 wouldn't it?
[14:00:46] <mutante>	 #!/bin/bash
[14:00:46] <mutante>	 host=labsdb1011
[14:00:47] <mutante>	 case $host in \
[14:00:47] <mutante>	     labsdb10[10-12])
[14:00:47] <mutante>	     echo "matches";;
[14:00:49] <mutante>	     *)
[14:00:51] <mutante>	     echo "nope"
[14:00:54] <mutante>	 esac
[14:00:57] <mutante>	 nope
[14:01:22] <marostegui>	 https://regex101.com/r/zJ6UQm/1
[14:01:29] <mutante>	 case $host in \
[14:01:29] <mutante>	     labsdb101[0-2])
[14:01:30] <mutante>	     echo "matches";;
[14:01:38] <mutante>	 --
[14:01:38] <mutante>	 matches
[14:04:19] <marostegui>	 (I have ammended it anyways)
[14:06:47] <addshore>	 so we have standards for varchar vs varbinary ?
[14:23:44] <marostegui>	 jynus: check my comment about why I included dbprov on my patchset, but anyways, I have removed them now
[14:32:38] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad: db1078 s3 primary DB master BBU pre-failure - https://phabricator.wikimedia.org/T219115 (10Cmjohnson) Your case was successfully submitted. Please note your Case ID: 5337355107 for future reference.
[14:33:51] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad: db1078 s3 primary DB master BBU pre-failure - https://phabricator.wikimedia.org/T219115 (10Marostegui) Thanks!
[15:50:30] <addshore>	 marostegui: so, wb_terms related work started today
[15:50:38] <marostegui>	 \o/
[15:50:42] <marostegui>	 any ticket to follow?
[15:50:54] <addshore>	 and before running into the distance we would like a once over of https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/Wikibase/+/57198cb2d907591d7fd8f2c72ff629895fd53e93/repo/sql/AddNewTermsStuff.sql
[15:51:16] <addshore>	 work will be tracked on https://phabricator.wikimedia.org/project/view/3972/
[15:51:36] <addshore>	 I'l link all of the work to https://phabricator.wikimedia.org/T208425 too
[15:54:38] * marostegui in a meeting
[15:56:05] <addshore>	 ack
[15:56:56] <wikibugs>	 10DBA, 10Wikidata wb_terms Trailblazing: Send the schema to DBAs and follow up with their review - https://phabricator.wikimedia.org/T219142 (10Addshore) I just pinged the #DBA s on IRC with a link to https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/Wikibase/+/57198cb2d907591d7fd8f2c72ff6298...
[15:58:20] <wikibugs>	 10DBA, 10Wikidata, 10Wikidata wb_terms Trailblazing: Send the schema to DBAs and follow up with their review - https://phabricator.wikimedia.org/T219142 (10Lydia_Pintscher)
[16:00:49] <wikibugs>	 10DBA, 10Wikidata, 10Wikidata wb_terms Trailblazing: Send the schema to DBAs and follow up with their review - https://phabricator.wikimedia.org/T219142 (10Marostegui) Is there a wikipage where we can see what each table is supposed to do and store?
[16:01:25] <wikibugs>	 10DBA, 10Wikidata, 10Wikidata wb_terms Trailblazing: Send the schema to DBAs and follow up with their review - https://phabricator.wikimedia.org/T219142 (10Addshore) >>! In T219142#5053982, @Marostegui wrote: > Is there a wikipage where we can see what each table is supposed to do and store?  Not yet, but if...
[16:02:46] <wikibugs>	 10DBA, 10Wikidata, 10Wikidata wb_terms Trailblazing: Send the schema to DBAs and follow up with their review - https://phabricator.wikimedia.org/T219142 (10Marostegui) I am asking because reviewing the tables without really knowing the context is hard :-) Also, are these tables going to be public? Can they b...
[16:13:05] <wikibugs>	 10DBA, 10Wikidata: Make a copy of the current wb_terms table on the MCR testing DB servers - https://phabricator.wikimedia.org/T211338 (10Addshore)
[16:13:07] <wikibugs>	 10DBA: Grant addshore access to test-s4 servers - https://phabricator.wikimedia.org/T211593 (10Addshore)
[18:06:49] <wikibugs>	 10DBA: Purchase and setup remaining hosts for database backups - https://phabricator.wikimedia.org/T213406 (10RobH)
[19:07:27] <wikibugs>	 10DBA, 10Performance-Team, 10Reading-Infrastructure-Team-Backlog, 10WikimediaEditorTasks, and 2 others: Performance review of Extension:WikimediaEditorTasks - https://phabricator.wikimedia.org/T218087 (10Mholloway) @aaron How are we doing on this? Do you expect for this to be complete in time to enable in...
[20:30:27] <wikibugs>	 10DBA, 10MediaWiki-Database, 10WikimediaEditorTasks, 10Patch-For-Review, 10Reading-Infrastructure-Team-Backlog (Kanban): Choose DB/Cluster for WikimediaEditorTasks tables - https://phabricator.wikimedia.org/T218302 (10Mholloway) @Tgr mentioned that, for production, the DB table creation SQL needs to be r...
[20:41:05] <wikibugs>	 10DBA, 10MediaWiki-Database, 10WikimediaEditorTasks, 10Patch-For-Review, 10Reading-Infrastructure-Team-Backlog (Kanban): Choose DB/Cluster for WikimediaEditorTasks tables - https://phabricator.wikimedia.org/T218302 (10Marostegui) DBAs do not create the tables, that must be done, typically, by a deployer:...
[21:23:01] <wikibugs>	 10DBA, 10MediaWiki-Database, 10WikimediaEditorTasks, 10Patch-For-Review, 10Reading-Infrastructure-Team-Backlog (Kanban): Choose DB/Cluster for WikimediaEditorTasks tables - https://phabricator.wikimedia.org/T218302 (10Mholloway) >>! In T218302#5055758, @Marostegui wrote: > DBAs do not create the tables,...