Page MenuHomePhabricator

bking (Brian King)
Senior Site Reliability Engineer, Search Platform Team

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Friday

  • Clear sailing ahead.

User Details

User Since
Dec 15 2021, 9:19 PM (101 w, 6 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
BKing (WMF) [ Global Accounts ]

Recent Activity

Today

bking updated the task description for T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model.
Wed, Nov 29, 4:21 PM · Data-Platform-SRE, [DEPRECATED] wdwb-tech, serviceops-radar, Discovery-Search (Current work), Wikidata, Wikidata-Query-Service
bking added a comment to T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator.
  • remove unused secrets from kubernetes.yaml on private puppet
Wed, Nov 29, 3:49 PM · Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking added a comment to T347355: Create alerts for https://query.wikidata.org/bigdata/ldf.

I've created another 24-hour silence for this alert, UUID 59b5ca30-1aeb-4d06-b083-7023a373ccb3 .

Wed, Nov 29, 12:14 AM · Patch-For-Review, Wikidata, Wikidata-Query-Service, Data-Platform-SRE

Yesterday

bking moved T352111: Simplify query.wikidata.org LDF endpoint config from Incoming to In Progress on the Data-Platform-SRE board.
Tue, Nov 28, 10:34 PM · Patch-For-Review, Data-Platform-SRE
bking changed the status of T352111: Simplify query.wikidata.org LDF endpoint config from Open to In Progress.
Tue, Nov 28, 10:34 PM · Patch-For-Review, Data-Platform-SRE
bking updated the task description for T336443: Investigate performance differences between wdqs2022 and older hosts.
Tue, Nov 28, 3:59 PM · Data-Platform-SRE, Discovery-Search (Current work)

Mon, Nov 27

bking added a comment to T347355: Create alerts for https://query.wikidata.org/bigdata/ldf.

The probe is getting a 500 error, which is spawning phab tickets for serviceops-collab team (see T352084 ). As such, I've set a 24-hour suppression in alertmanager (UUID fc02d897-8a64-4ebb-a362-77a765a7f155 ) . Will revisit once I'm back at work tomorrow.

Mon, Nov 27, 11:05 PM · Patch-For-Review, Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking added a comment to T347355: Create alerts for https://query.wikidata.org/bigdata/ldf.

Looks like the check targets are rendered at /srv/prometheus/ops/targets/probes-custom_puppet-http.yaml on the prom hosts
after merging the above patch, the target config for LDF endpoint looks like this

Mon, Nov 27, 10:50 PM · Patch-For-Review, Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking added a comment to P53914 Blackbox check T347355.
  • labels: address: 10.64.132.7 family: ip4 module: http_query_wikidata_org_ldf_ip4 targets:
    • miscweb1003:443@https://[10.64.132.7]:443/bigdata/ldf
Mon, Nov 27, 10:40 PM · Data-Platform-SRE
bking created T352111: Simplify query.wikidata.org LDF endpoint config.
Mon, Nov 27, 10:32 PM · Patch-For-Review, Data-Platform-SRE
bking created P53914 Blackbox check T347355.
Mon, Nov 27, 7:39 PM · Data-Platform-SRE
bking closed T352036: PuppetZeroResources - miscweb2003 as Resolved.

Sorry for the alert spam! We've fixed the Puppet failure and so I'll close this one out. Have a great rest of your week!

Mon, Nov 27, 7:10 PM · collaboration-services
bking updated subscribers of T351475: Reduce impact of Elastic snapshots.

Just wanted to add that Envoy is deployed for Swift frontends per today's SRE meeting.

Mon, Nov 27, 6:00 PM · Data-Platform-SRE
bking added a comment to T347504: WDQS graph split: load data from dumps into new hosts.

Looks like the data reload for lexemes completed. @dcausse , are you able to check the data from the reload and make sure it's usable? Let me know if I can help.

Mon, Nov 27, 2:43 PM · Wikidata, Data-Platform-SRE, Wikidata-Query-Service

Mon, Nov 20

bking updated the task description for T241128: EPIC: Reduce the time needed to do the initial WDQS import.
Mon, Nov 20, 10:00 PM · Epic, Wikidata, Wikidata-Query-Service
bking updated the task description for T241128: EPIC: Reduce the time needed to do the initial WDQS import.
Mon, Nov 20, 9:05 PM · Epic, Wikidata, Wikidata-Query-Service
bking renamed T351671: Service implementation for wdqs1017-1020 from Service implementation for wdqs1017-1021 to Service implementation for wdqs1017-1020.
Mon, Nov 20, 8:47 PM · Data-Platform-SRE
bking added a comment to T351671: Service implementation for wdqs1017-1020.

Let's leave wdqs1021 out for now, as we need it for performance testing in T351662

Mon, Nov 20, 8:47 PM · Data-Platform-SRE
bking updated subscribers of T351671: Service implementation for wdqs1017-1020.
Mon, Nov 20, 7:12 PM · Data-Platform-SRE
bking created T351671: Service implementation for wdqs1017-1020.
Mon, Nov 20, 7:07 PM · Data-Platform-SRE
bking added a comment to T351662: Test hardware-based performance optimizations for WDQS import.

Thanks @Addshore , this is a wealth of great info!

Mon, Nov 20, 6:38 PM · Data-Platform-SRE
bking updated the task description for T326409: Migrate the wdqs streaming updater flink jobs to flink-k8s-operator deployment model.
Mon, Nov 20, 5:41 PM · Data-Platform-SRE, [DEPRECATED] wdwb-tech, serviceops-radar, Discovery-Search (Current work), Wikidata, Wikidata-Query-Service
bking added a comment to T351662: Test hardware-based performance optimizations for WDQS import.

We'll test I/O wdqs1014 (R440) and wdqs1015 (R450) using fio. This Wikitech page might be useful

Mon, Nov 20, 5:31 PM · Data-Platform-SRE
bking created T351662: Test hardware-based performance optimizations for WDQS import.
Mon, Nov 20, 5:14 PM · Data-Platform-SRE
bking added a comment to T336443: Investigate performance differences between wdqs2022 and older hosts.

Reopening per today's IRC conversation. We really need this process to be faster, so we'll try enabling the performance governor and seeing what happens next.

Mon, Nov 20, 4:12 PM · Data-Platform-SRE, Discovery-Search (Current work)
bking reopened T336443: Investigate performance differences between wdqs2022 and older hosts, a subtask of T331300: Ensure WDQS stack works on Bullseye, as In Progress.
Mon, Nov 20, 4:10 PM · Patch-For-Review, Data-Platform-SRE, Discovery-Search (Current work)
bking reopened T336443: Investigate performance differences between wdqs2022 and older hosts as "In Progress".
Mon, Nov 20, 4:10 PM · Data-Platform-SRE, Discovery-Search (Current work)
bking added a comment to T347504: WDQS graph split: load data from dumps into new hosts.

Update: The wikidata dump finished on wdqs1022 ( Wikidata dump loaded in 25 days, 13:32:17.263762) .

Mon, Nov 20, 1:55 PM · Wikidata, Data-Platform-SRE, Wikidata-Query-Service

Fri, Nov 17

bking updated the task description for T351475: Reduce impact of Elastic snapshots.
Fri, Nov 17, 6:40 PM · Data-Platform-SRE
bking renamed T351475: Reduce impact of Elastic snapshots from Reduce network impact of Elastic snapshots to Reduce impact of Elastic snapshots.
Fri, Nov 17, 4:09 PM · Data-Platform-SRE
bking updated the task description for T351475: Reduce impact of Elastic snapshots.
Fri, Nov 17, 4:09 PM · Data-Platform-SRE
bking moved T351475: Reduce impact of Elastic snapshots from Incoming to Blocked / Waiting on the Data-Platform-SRE board.

Per today's IRC discussion in the security channel, @CDanis mentioned detuning or removing the LVS alerts for internal hosts. So I'll set this one to blocked at the moment. Chris and/or Brett, let us know what your teams decide.

Fri, Nov 17, 4:07 PM · Data-Platform-SRE
bking added a comment to T351354: Service implementation for cloudelastic1007-1010.

@jbond Sorry for the confusion, I associated the reimage with the wrong ticket. The output of the last reimage is here . Puppet was disabled because the hosts were previously set to their production role, but due to the PKI errors we put them back to insetup. I should have paid more attention...it seems the reimage never actually wiped the disks, whereas I had assumed it failed on later steps.

Fri, Nov 17, 2:35 PM · Data-Platform-SRE

Thu, Nov 16

bking closed T348686: Standardize/document Elastic snapshot configuration as Resolved.

Confirmed working, closing...

Thu, Nov 16, 10:55 PM · Data-Platform-SRE
bking updated subscribers of T351475: Reduce impact of Elastic snapshots.
Thu, Nov 16, 10:22 PM · Data-Platform-SRE
bking updated the task description for T351475: Reduce impact of Elastic snapshots.
Thu, Nov 16, 10:18 PM · Data-Platform-SRE
bking created T351475: Reduce impact of Elastic snapshots.
Thu, Nov 16, 10:17 PM · Data-Platform-SRE

Wed, Nov 15

bking closed T351123: Decommission search-loader1001/2001 VMs, a subtask of T346039: Migrate search-loader hosts to Bullseye or later, as Resolved.
Wed, Nov 15, 10:07 PM · Discovery-Search (Current work), Data-Platform-SRE
bking closed T351123: Decommission search-loader1001/2001 VMs as Resolved.

These VMs have been fully deleted/decommissioned. Closing...

Wed, Nov 15, 10:07 PM · Data-Platform-SRE
bking created T351354: Service implementation for cloudelastic1007-1010.
Wed, Nov 15, 9:35 PM · Data-Platform-SRE
bking updated the task description for T349772: Create dashboards/alerts for new Cirrus Streaming Updater.
Wed, Nov 15, 9:17 PM · Discovery-Search (Current work), Data-Platform-SRE
bking closed T342538: Q1:rack/setup/install cloudelastic10[07-10].wikimedia.org as Resolved.

Not sure what happened, but the cloudelastic1008-1010 hosts are up after a reimage. I had to manually powercycle the DRAC, login to its console, and force-enable/run puppet.

Wed, Nov 15, 8:59 PM · Data-Platform-SRE, SRE, ops-eqiad, cloud-services-team (Hardware), DC-Ops
bking closed T342538: Q1:rack/setup/install cloudelastic10[07-10].wikimedia.org, a subtask of T231010: Change partitioning scheme for elasticsearch from RAID to JBOD, as Resolved.
Wed, Nov 15, 8:59 PM · Discovery-Search (Current work), Data-Platform-SRE, Elasticsearch
bking added a comment to T350826: Test backfilling for cirrus-streaming-updater.

Apologies for the reimage spam, it's from an unrelated operation.

Wed, Nov 15, 8:43 PM · Discovery-Search (Current work), Data-Platform-SRE
bking moved T342538: Q1:rack/setup/install cloudelastic10[07-10].wikimedia.org from Blocked / Waiting to In Progress on the Data-Platform-SRE board.

Reopening as cloudelastic1008-1010 don't appear to have reimaged properly, and we may need them for T350826 .

Wed, Nov 15, 6:05 PM · Data-Platform-SRE, SRE, ops-eqiad, cloud-services-team (Hardware), DC-Ops
bking reopened T342538: Q1:rack/setup/install cloudelastic10[07-10].wikimedia.org as "In Progress".
Wed, Nov 15, 6:03 PM · Data-Platform-SRE, SRE, ops-eqiad, cloud-services-team (Hardware), DC-Ops
bking reopened T342538: Q1:rack/setup/install cloudelastic10[07-10].wikimedia.org, a subtask of T231010: Change partitioning scheme for elasticsearch from RAID to JBOD, as In Progress.
Wed, Nov 15, 6:03 PM · Discovery-Search (Current work), Data-Platform-SRE, Elasticsearch

Tue, Nov 14

bking claimed T347355: Create alerts for https://query.wikidata.org/bigdata/ldf.
Tue, Nov 14, 11:04 PM · Patch-For-Review, Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking added a comment to T347355: Create alerts for https://query.wikidata.org/bigdata/ldf.

team-sre/probes.yaml in the alerts repo looks like a good place to start.

Tue, Nov 14, 11:03 PM · Patch-For-Review, Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking moved T351233: Update search-loader dashboard to reflect new search-loader hosts from Incoming to Needs Reporting on the Discovery-Search (Current work) board.
Tue, Nov 14, 9:43 PM · Discovery-Search (Current work), Data-Platform-SRE
bking moved T351233: Update search-loader dashboard to reflect new search-loader hosts from Incoming to Done on the Data-Platform-SRE board.
Tue, Nov 14, 9:42 PM · Discovery-Search (Current work), Data-Platform-SRE
bking closed T351233: Update search-loader dashboard to reflect new search-loader hosts, a subtask of T346039: Migrate search-loader hosts to Bullseye or later, as Invalid.
Tue, Nov 14, 9:42 PM · Discovery-Search (Current work), Data-Platform-SRE
bking closed T351233: Update search-loader dashboard to reflect new search-loader hosts as Invalid.

Confirmed, we do not need to take further action. The decommissioned hosts have been removed automatically, and other aspects of the dashboard are still working.

Tue, Nov 14, 9:42 PM · Discovery-Search (Current work), Data-Platform-SRE
bking created T351233: Update search-loader dashboard to reflect new search-loader hosts.
Tue, Nov 14, 3:50 PM · Discovery-Search (Current work), Data-Platform-SRE
bking triaged T351123: Decommission search-loader1001/2001 VMs as Medium priority.
Tue, Nov 14, 3:45 PM · Data-Platform-SRE
bking closed T346273: eqiad: 1 VM requested for search-loader, a subtask of T346039: Migrate search-loader hosts to Bullseye or later, as Resolved.
Tue, Nov 14, 3:43 PM · Discovery-Search (Current work), Data-Platform-SRE
bking closed T346273: eqiad: 1 VM requested for search-loader as Resolved.

This is done...closing out ticket.

Tue, Nov 14, 3:43 PM · vm-requests, Infrastructure-Foundations, SRE
bking claimed T351123: Decommission search-loader1001/2001 VMs.
Tue, Nov 14, 3:41 PM · Data-Platform-SRE
bking moved T351123: Decommission search-loader1001/2001 VMs from Incoming to In Progress on the Data-Platform-SRE board.
Tue, Nov 14, 3:41 PM · Data-Platform-SRE
bking closed T350078: Decom search-loader VMs still using Buster, a subtask of T346039: Migrate search-loader hosts to Bullseye or later, as Invalid.
Tue, Nov 14, 3:36 PM · Discovery-Search (Current work), Data-Platform-SRE
bking closed T350078: Decom search-loader VMs still using Buster as Invalid.

Duplicate of T351123 ... closing.

Tue, Nov 14, 3:36 PM · Data-Platform-SRE

Mon, Nov 13

bking added a comment to T351123: Decommission search-loader1001/2001 VMs.

Command should be sudo cookbook sre.hosts.decommission search-loader1001.eqiad.wmnet,search-loader2001.codfw.wmnet -t T351123. I'm at the end of my day, so will run tomorrow.

Mon, Nov 13, 10:52 PM · Data-Platform-SRE
bking added a comment to T346039: Migrate search-loader hosts to Bullseye or later.

Per the last deploy message above, it looks like mjolnir is running successfully under Bullseye and Python 3.10. The next step is to decom the older, buster-based VMs. That work is tracked in T351123.

Mon, Nov 13, 10:24 PM · Discovery-Search (Current work), Data-Platform-SRE
bking added a subtask for T346039: Migrate search-loader hosts to Bullseye or later: T351123: Decommission search-loader1001/2001 VMs.
Mon, Nov 13, 9:29 PM · Discovery-Search (Current work), Data-Platform-SRE
bking added a parent task for T351123: Decommission search-loader1001/2001 VMs: T346039: Migrate search-loader hosts to Bullseye or later.
Mon, Nov 13, 9:29 PM · Data-Platform-SRE
bking created T351123: Decommission search-loader1001/2001 VMs.
Mon, Nov 13, 9:28 PM · Data-Platform-SRE
bking updated the task description for T350703: Restart Search Platform-owned services for Java 8 / Java 11 security updates.
Mon, Nov 13, 9:11 PM · Data-Platform-SRE
bking added a comment to T349095: Migrate staging rdf-streaming-updater to flink operator.

Both apps (commons and wikidata) are stable in staging-eqiad now:

Mon, Nov 13, 8:48 PM · Discovery-Search (Current work), Patch-For-Review, Wikidata, Data-Platform-SRE, Wikidata-Query-Service
bking added a comment to T350703: Restart Search Platform-owned services for Java 8 / Java 11 security updates.

I've also extended this task to cover the restarts for WCSQ and WQDS, I've just rolled out the respective Java 8 security updates.

Also, for cloudelastic* I'm still seeing some logstash processes using the old JRE, maybe that's something that needs to be covered in the cookbook as well?

Mon, Nov 13, 3:52 PM · Data-Platform-SRE
bking added a comment to T347504: WDQS graph split: load data from dumps into new hosts.

Another progress report: We are 80% (869/1104) done on the leading host (wdqs1022).

Mon, Nov 13, 3:38 PM · Wikidata, Data-Platform-SRE, Wikidata-Query-Service

Thu, Nov 9

bking updated the task description for T350703: Restart Search Platform-owned services for Java 8 / Java 11 security updates.
Thu, Nov 9, 5:47 PM · Data-Platform-SRE
bking created T350885: Project future physical host usage for Search Platform-owned services.
Thu, Nov 9, 3:54 PM · Data-Platform-SRE
bking renamed T350703: Restart Search Platform-owned services for Java 8 / Java 11 security updates from Restart Elasticsearch services for Java 8 / Java 11 security updates to Restart Search Platform-owned services for Java 8 / Java 11 security updates.
Thu, Nov 9, 2:25 PM · Data-Platform-SRE

Wed, Nov 8

bking updated the task description for T350703: Restart Search Platform-owned services for Java 8 / Java 11 security updates.
Wed, Nov 8, 9:33 PM · Data-Platform-SRE
bking removed projects from T350185: Estimate cirrus streaming updater's usage of MWAPI: Discovery-Search (Current work), serviceops-radar.
Wed, Nov 8, 8:28 PM · Epic, Data-Platform-SRE
bking closed T350185: Estimate cirrus streaming updater's usage of MWAPI, a subtask of T349848: Determine and control cirrus streaming updater's usage of MWAPI resources, as Invalid.
Wed, Nov 8, 8:28 PM · serviceops-radar, Epic, Discovery-Search (Current work), Data-Platform-SRE
bking closed T350185: Estimate cirrus streaming updater's usage of MWAPI as Invalid.

Upon further review, I'm declining this as invalid. We do need to track resource usage, but that shouldn't be limited to MWAPI. Other resource-related issues will turn up as we roll out in staging (T347075) and test a backfill (T350826) , so we can add new subtasks off these tickets as needed.

Wed, Nov 8, 8:28 PM · Epic, Data-Platform-SRE
bking added a subtask for T340548: [EPIC] Deployment of the Search Update Pipeline on Flink / k8s: T350826: Test backfilling for cirrus-streaming-updater.
Wed, Nov 8, 7:55 PM · Epic, Discovery-Search (Current work), Data-Platform-SRE
bking added a parent task for T350826: Test backfilling for cirrus-streaming-updater: T340548: [EPIC] Deployment of the Search Update Pipeline on Flink / k8s.
Wed, Nov 8, 7:55 PM · Discovery-Search (Current work), Data-Platform-SRE
bking added a comment to T350826: Test backfilling for cirrus-streaming-updater.

My rough notes around this subject are here . I'm still learning Flink and Kafka, so will need some help creating the backfill test.

Wed, Nov 8, 7:52 PM · Discovery-Search (Current work), Data-Platform-SRE
bking created T350826: Test backfilling for cirrus-streaming-updater.
Wed, Nov 8, 7:48 PM · Discovery-Search (Current work), Data-Platform-SRE
bking updated the task description for T350185: Estimate cirrus streaming updater's usage of MWAPI.
Wed, Nov 8, 7:39 PM · Epic, Data-Platform-SRE
bking updated the task description for T346438: [Epic] Review alerting strategy for Data Platform SRE.
Wed, Nov 8, 6:25 PM · Epic, Data-Platform-SRE, observability
bking added a comment to T346039: Migrate search-loader hosts to Bullseye or later.

Per conversation with @Gehel , we might need to do a scream test by shutting off the old instances. Will look into this next week.

Wed, Nov 8, 6:04 PM · Discovery-Search (Current work), Data-Platform-SRE
bking updated subscribers of T349666: [EPIC] Improve helm chart development experience.

@JMeybohm posted https://helm-playground.com in #wikimedia-k8s-sig today, this could be a piece of the puzzle as well.

Wed, Nov 8, 6:02 PM · Kubernetes, Discovery-Search, Epic, serviceops-radar, Data-Platform-SRE
bking updated the task description for T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator.
Wed, Nov 8, 4:52 PM · Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking added a project to T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator: Wikidata-Query-Service.
Wed, Nov 8, 4:08 PM · Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking renamed T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator from Clean up deployment-charts leftovers after rdf-streaming-updater migrates to flink operator to Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator.
Wed, Nov 8, 4:08 PM · Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking updated subscribers of T350499: Search Platform Airflow jobs: Identify dependencies and configure alerts.
Wed, Nov 8, 3:59 PM · Data-Platform-SRE
bking updated the task description for T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator.
Wed, Nov 8, 2:41 PM · Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking updated the task description for T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator.
Wed, Nov 8, 2:41 PM · Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking added a project to T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator: Data-Platform-SRE.
Wed, Nov 8, 2:39 PM · Wikidata, Wikidata-Query-Service, Data-Platform-SRE
bking created T350784: Identify/complete post-migration tasks after rdf-streaming-updater migrates to flink operator.
Wed, Nov 8, 2:39 PM · Wikidata, Wikidata-Query-Service, Data-Platform-SRE

Tue, Nov 7

bking added a comment to T347504: WDQS graph split: load data from dumps into new hosts.

@bking thanks for triggering the import, could you update the task description with the dump files you used? (needed because we have to explicitly keep the corresponding partition in hdfs).

Tue, Nov 7, 10:53 PM · Wikidata, Data-Platform-SRE, Wikidata-Query-Service
bking updated the task description for T347504: WDQS graph split: load data from dumps into new hosts.
Tue, Nov 7, 10:52 PM · Wikidata, Data-Platform-SRE, Wikidata-Query-Service
bking updated the task description for T350703: Restart Search Platform-owned services for Java 8 / Java 11 security updates.
Tue, Nov 7, 10:48 PM · Data-Platform-SRE
bking claimed T350703: Restart Search Platform-owned services for Java 8 / Java 11 security updates.
Tue, Nov 7, 9:35 PM · Data-Platform-SRE
bking updated subscribers of T350703: Restart Search Platform-owned services for Java 8 / Java 11 security updates.
Tue, Nov 7, 4:21 PM · Data-Platform-SRE
bking created T350703: Restart Search Platform-owned services for Java 8 / Java 11 security updates.
Tue, Nov 7, 4:16 PM · Data-Platform-SRE

Mon, Nov 6

bking added a comment to T349095: Migrate staging rdf-streaming-updater to flink operator.

Current status:

Mon, Nov 6, 11:06 PM · Discovery-Search (Current work), Patch-For-Review, Wikidata, Data-Platform-SRE, Wikidata-Query-Service