Page MenuHomePhabricator
Create Task
Maniphest T229543

Decommission db2058.codfw.wmnet
Closed, ResolvedPublic
Actions

Description

db2058 had a broken storage T229449: db2058: Broken storage and needs to be decommissioned

This task will track the decommission-hardware of server db2058.codfw.wmnet

The first 5 steps should be completed by the service owner that is returning the server to DC-ops (for reclaim to spare or decommissioning, dependent on server configuration and age.)

db2058.codfw.wmnet

Steps for service owner:

Steps for DC-Ops:

The following steps cannot be interrupted, as it will leave the system in an unfinished state.

Start non-interrupt steps:

  • - disable puppet on host
  • - power down host
  • - update netbox status to Inventory (if decom) or Planned (if spare)
  • - disable switch port
  • - switch port assignment noted on this task (for later removal)
  • - remove all remaining puppet references (include role::spare)
  • - remove production dns entries
  • - puppet node clean, puppet node deactivate (handled by wmf-decommission-host)
  • - remove dbmonitor entries on neodymium/sarin: sudo curl -X DELETE https://debmonitor.discovery.wmnet/hosts/${HOST_FQDN} --cert /etc/debmonitor/ssl/cert.pem --key /etc/debmonitor/ssl/server.key (handled by wmf-decommission-host)

End non-interrupt steps.

  • - Label RAID controller as broken so it doesn't get re-used T229449#5383312
  • - system disks wiped (by onsite)
  • - IF DECOM: system unracked and decommissioned (by onsite), update racktables with result
  • - IF DECOM: switch port configration removed from switch once system is unracked.
  • - IF DECOM: add system to decommission tracking google sheet
  • - IF DECOM: mgmt dns entries removed.

Details

SubjectRepoBranchLines +/-
DNS: Remove mgmt DNS for db2058 and db2069operations/dnsmaster+2 -8
wmnet: Remove db2058 production DNSoperations/dnsmaster+0 -2
site.pp: Remove references to db2058operations/puppetproduction+0 -5
mariadb: Decommission db2058operations/puppetproduction+6 -11
db-eqiad,db-codfw.php: Remove db2058operations/mediawiki-configmaster+0 -3
Customize query in gerrit

Related Objects
Search...

StatusSubtypeAssignedTask
 ResolvedNoneT208323 Predictive failures on disk S.M.A.R.T. status
 ResolvedMarosteguiT228258 Decommission db2043-db2070
 ResolvedPapaulT229543 Decommission db2058.codfw.wmnet

Event Timeline

Marostegui triaged this task as Medium priority.Aug 1 2019, 4:59 AM
Marostegui created this task.
Marostegui moved this task from Triage to In progress on the DBA board.
Marostegui mentioned this in T228258: Decommission db2043-db2070.
gerritbot added a comment.Aug 1 2019, 10:40 AM

Change 527058 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad,db-codfw.php: Remove db2058

https://gerrit.wikimedia.org/r/527058

gerritbot added a project: Patch-For-Review.Aug 1 2019, 10:40 AM
Marostegui updated the task description. (Show Details)Aug 1 2019, 10:47 AM
gerritbot added a comment.Aug 1 2019, 10:48 AM

Change 527058 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad,db-codfw.php: Remove db2058

https://gerrit.wikimedia.org/r/527058

Stashbot added a comment.Aug 1 2019, 10:50 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-01T10:50:13Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Remove db2058 from config T229543 (duration: 00m 55s)

Stashbot added a comment.Aug 1 2019, 10:51 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-01T10:51:15Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db2058 from config T229543 (duration: 00m 57s)

Maintenance_bot removed a project: Patch-For-Review.Aug 1 2019, 11:10 AM
Stashbot added a comment.Aug 2 2019, 5:06 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-02T05:06:55Z] <marostegui> Remove db2058 from tendril and zarcillo T229543

gerritbot added a comment.Aug 2 2019, 5:07 AM

Change 527382 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: Decommission db2058

https://gerrit.wikimedia.org/r/527382

gerritbot added a project: Patch-For-Review.Aug 2 2019, 5:07 AM
gerritbot added a comment.Aug 2 2019, 5:10 AM

Change 527382 merged by Marostegui:
[operations/puppet@production] mariadb: Decommission db2058

https://gerrit.wikimedia.org/r/527382

Maintenance_bot removed a project: Patch-For-Review.Aug 2 2019, 5:10 AM
Stashbot added a comment.Aug 2 2019, 5:10 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-02T05:10:42Z] <marostegui> Stop MySQL on db2058 for decommissioning T229543

Marostegui reassigned this task from Marostegui to RobH.Aug 2 2019, 5:11 AM
Marostegui edited projects, added ops-codfw; removed DBA.
Marostegui updated the task description. (Show Details)
Marostegui added a project: DC-Ops.Aug 2 2019, 5:15 AM

This host is ready for DC-Ops to decommission

Papaul moved this task from Backlog to Decommission on the ops-codfw board.Aug 16 2019, 3:43 PM
Marostegui moved this task from Backlog to Ready for Decommission on the decommission-hardware board.Sep 5 2019, 9:41 AM
gerritbot added a comment.Oct 8 2019, 5:48 AM

Change 541413 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] site.pp: Remove references to db2058

https://gerrit.wikimedia.org/r/541413

gerritbot added a project: Patch-For-Review.Oct 8 2019, 5:48 AM
ops-monitoring-bot added a comment.Oct 8 2019, 5:48 AM

cookbooks.sre.hosts.decommission executed by marostegui@cumin1001 for hosts: db2058.codfw.wmnet

  • db2058.codfw.wmnet (PASS)
    • Downtimed host on Icinga
    • Downtimed management interface on Icinga
    • Wiped bootloaders
    • Powered off
    • Set Netbox status to Decommissioning
    • Removed from DebMonitor
    • Removed from Puppet master and PuppetDB
gerritbot added a comment.Oct 8 2019, 5:49 AM

Change 541413 merged by Marostegui:
[operations/puppet@production] site.pp: Remove references to db2058

https://gerrit.wikimedia.org/r/541413

gerritbot added a comment.Oct 8 2019, 5:49 AM

Change 541414 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/dns@master] wmnet: Remove db2058 production DNS

https://gerrit.wikimedia.org/r/541414

gerritbot added a comment.Oct 8 2019, 5:51 AM

Change 541414 merged by Marostegui:
[operations/dns@master] wmnet: Remove db2058 production DNS

https://gerrit.wikimedia.org/r/541414

Marostegui reassigned this task from RobH to Papaul.Oct 8 2019, 5:51 AM
Marostegui removed a project: Patch-For-Review.
Marostegui updated the task description. (Show Details)

Host ready final decommissioning steps + switch disablement

Marostegui moved this task from Ready for Decommission to pending onsite steps (codfw) on the decommission-hardware board.Oct 8 2019, 6:17 AM
Papaul added a comment.Oct 9 2019, 3:58 PM
papaul@asw-d-codfw# show | compare 
[edit interfaces interface-range vlan-private1-d-codfw]
-    member ge-6/0/6;
[edit interfaces interface-range disabled]
     member ge-6/0/17 { ... }
+    member ge-6/0/6;
[edit interfaces]
-   ge-6/0/6 {
-       description db2058;
-       enable;
-   }
Papaul updated the task description. (Show Details)Oct 9 2019, 4:06 PM
Papaul updated the task description. (Show Details)Oct 10 2019, 3:48 PM
gerritbot added a comment.Oct 10 2019, 11:11 PM

Change 542252 had a related patch set uploaded (by Papaul; owner: Papaul):
[operations/dns@master] DNS: Remoce mgmt DNS for db2058 and db2069

https://gerrit.wikimedia.org/r/542252

gerritbot added a project: Patch-For-Review.Oct 10 2019, 11:11 PM
gerritbot added a comment.Oct 10 2019, 11:22 PM

Change 542252 merged by Dzahn:
[operations/dns@master] DNS: Remove mgmt DNS for db2058 and db2069

https://gerrit.wikimedia.org/r/542252

Maintenance_bot removed a project: Patch-For-Review.Oct 11 2019, 12:11 AM
Papaul closed this task as Resolved.Oct 11 2019, 1:32 AM
Papaul updated the task description. (Show Details)

Complete

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits