[01:37:41] 10DBA, 10Reading List Service, 10Reading-Infrastructure-Team-Backlog (Kanban): Update duplicate handling in reading lists API - https://phabricator.wikimedia.org/T184680#3933341 (10Tgr) This will involve creating a new unique index on `reading_list.rl_name` (no real data yet, just a few test rows). I imagine... [07:08:57] 10DBA: db1051 database host BBU issues - https://phabricator.wikimedia.org/T186049#3933540 (10Marostegui) ``` root@db1051:~# megacli -AdpBbuCmd -a0 BBU status for Adapter: 0 BatteryType: BBU Battery State: Unknown Battery backup charge time : 0 hours BBU Capacity Info for Adapter: 0 Relative State of C... [07:22:02] 10DBA, 10Patch-For-Review: Decommission db1030 - https://phabricator.wikimedia.org/T184397#3933551 (10Marostegui) [07:46:18] 10DBA, 10Patch-For-Review: Decommission db1030 - https://phabricator.wikimedia.org/T184397#3933562 (10Marostegui) [07:47:06] 10DBA, 10Patch-For-Review: Decommission db1030 - https://phabricator.wikimedia.org/T184397#3881935 (10Marostegui) [08:06:32] 10DBA, 10Operations, 10ops-eqiad, 10Patch-For-Review: Decommission db1030 - https://phabricator.wikimedia.org/T184397#3933578 (10Marostegui) a:05Marostegui>03Cmjohnson db1030 is now ready to be fully decommissioned by @Cmjohnson [08:09:16] 10DBA, 10MediaWiki-extensions-Linter, 10Patch-For-Review: Display count of remaining content space errors - https://phabricator.wikimedia.org/T173943#3933586 (10Legoktm) +#DBA, We'd appreciate your review on the proposed query (second one) I posted in T173943#3933570. The current plan is that we'd be running... [09:41:15] 10DBA: db1051 database host BBU issues - https://phabricator.wikimedia.org/T186049#3933643 (10Marostegui) After the relearn: ``` root@db1051:~# megacli -AdpBbuCmd -a0 | grep Optimal Battery State: Optimal ``` ``` root@db1051:~# megacli -ldinfo -l0 -a0 | grep Policy Default Cache Policy: WriteBack, ReadAheadNon... [12:15:09] 10DBA, 10Operations, 10hardware-requests, 10Goal: reclaim and return all cisco servers - https://phabricator.wikimedia.org/T128821#2087114 (10Marostegui) This task is now pending the last steps of the decommissioning process for labsdb1001 and labsdb1003 (T184832). I have tried to update the spreadsheet on... [14:41:53] marostegui: around? [15:56:27] Amir1: kinda... [15:56:43] marostegui: meeting atm, but will finish soon [15:57:05] Amir1: I am jetlagged, so might die soon too hehe :-) [15:57:56] marostegui: oh, I'd be quick, I'm changing some stuff for wbc_entity_usage in all wikis [15:58:11] it cut cawiki from 57M rows to 20M rows [15:58:22] <3 <3 <3 <3 <3 [15:58:36] but it also might make some wikis bigger but we put lots of safety checks so it doesn't explode [15:59:10] but I would love to if you keep an eye on the total issues [15:59:16] storage, etc. [15:59:29] which wikis you think might be those that can get bigger? [15:59:52] practically all [16:00:02] can we start slowly? [16:00:06] to isolate issues? [16:00:09] sure [16:00:36] (btw. it will also cut recentchanges table to half in lots of wikis, and fixes jobqueue issue once and for all) [16:01:10] nice! [16:01:23] which shard would you like to start with? [16:01:28] s5 maybe? (dewiki) [16:01:41] it only has dewiki, so storage wise, shouldn't be an issue [16:03:14] sure [16:03:22] let me check s6 [16:03:27] what about commons and enwiki? [16:03:51] Not sure I want to start with the biggest ones [16:03:56] In case we hit some issues [16:04:15] s6 should be fine too [16:04:23] s6 = frwiki, ruwiki, jawiki [16:07:10] marostegui: they already got bigger and will shrink drastically [16:07:29] so, should we go for those first? [16:08:01] they will automatically with the next week [16:08:33] (they will shrink and not grow) [16:08:40] same for lots of wikis in s7 [16:09:23] nice [16:09:32] so, then, what do you really need from me? keep an eye? :) [16:09:42] This wikis will shrink: [16:09:47] https://www.irccloud.com/pastebin/8ocHWbTz/ [16:10:01] but others will grow [16:10:20] so the question is, which wikis I should go next [16:10:28] (They will grow) [16:10:31] do we need to optimize the table on those ones btw? [16:10:46] only cawiki [16:11:06] why only that one? [16:11:08] (the tables in these wikis are so small that we don't need) [16:11:22] you can if you need to [16:11:54] ah cool [16:12:38] so, as per the wikis you should go next, why not dewiki + the rest of s7? [16:13:19] that would work [16:13:30] cool ( [16:13:47] s7 has no space issues at the moment [16:14:15] I might optimize the table on the labs hosts and all that [16:14:19] 10DBA, 10Operations, 10ops-codfw: rack/setup/install tendril2001 - https://phabricator.wikimedia.org/T186123#3934359 (10RobH) p:05Triage>03Normal [16:14:21] or on sanitarium at least [16:14:39] cool [16:16:28] can you ping me once you are done with s5 and s7? [16:16:39] so I can do the optimizes on sanitarium hosts? [16:17:07] sure [16:17:22] thank you [16:26:56] 10DBA, 10Operations, 10ops-codfw: rack/setup/install tendril2001 - https://phabricator.wikimedia.org/T186123#3934420 (10Papaul) Rack location = D5 [19:39:42] 10DBA, 10Operations, 10ops-codfw: rack/setup/install tendril2001 - https://phabricator.wikimedia.org/T186123#3934984 (10Papaul) [23:11:42] 10DBA, 10Operations, 10ops-codfw, 10Patch-For-Review: rack/setup/install tendril2001 - https://phabricator.wikimedia.org/T186123#3935714 (10Papaul) [23:15:44] 10DBA, 10Operations, 10netops, 10ops-codfw: switch port configuration for tendril2001 - https://phabricator.wikimedia.org/T186172#3935719 (10Papaul) p:05Triage>03Normal [23:59:33] 10DBA, 10Operations, 10netops, 10ops-codfw: switch port configuration for tendril2001 - https://phabricator.wikimedia.org/T186172#3935719 (10ayounsi) Interface description added, port up and in the private vlan. No MAC seen on the switch side so far.