Page MenuHomePhabricator
Create Task
Maniphest T230311

Decommission db2043.codfw.wmnet
Closed, ResolvedPublic
Actions

Description

This task will track the decommission-hardware of server db2043.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.)

db2043
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 disk #3 as broken so it doesn't get re-used
  • - 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.
  • - IF RECLAIM: system added back to spares tracking (by onsite)

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
DNS: Remove mgmt DNS for db2041 db204[3-4] db204[6-7] and db2049operations/dnsmaster+1 -24
db2043: Decom dns production entriesoperations/dnsmaster+0 -2
db2043: Remove it from puppetoperations/puppetproduction+0 -5
install_server: Remove db2043operations/puppetproduction+0 -5
mariadb: Decommission db2043operations/puppetproduction+6 -5
db-eqiad,db-codfw.php: Remove db2043 from configoperations/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
 ResolvedPapaulT230311 Decommission db2043.codfw.wmnet

Event Timeline

Marostegui created this task.Aug 12 2019, 8:30 AM
Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to In progress on the DBA board.
gerritbot added a comment.Aug 12 2019, 8:53 AM

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

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

gerritbot added a project: Patch-For-Review.Aug 12 2019, 8:53 AM
gerritbot added a comment.Aug 12 2019, 8:55 AM

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

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

gerritbot added a comment.Aug 12 2019, 9:20 AM

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

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

Stashbot added a comment.Aug 12 2019, 9:21 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-12T09:21:23Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Remove db2043 from config T230311 (duration: 00m 48s)

Marostegui updated the task description. (Show Details)Aug 12 2019, 9:21 AM
Stashbot added a comment.Aug 12 2019, 9:22 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-12T09:22:02Z] <marostegui> Remove db2043 from tendril and zarcillo T230311

Stashbot added a comment.Aug 12 2019, 9:22 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-12T09:22:19Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db2043 from config T230311 (duration: 00m 47s)

gerritbot added a comment.Aug 12 2019, 9:30 AM

Change 529716 merged by Marostegui:
[operations/puppet@production] mariadb: Decommission db2043

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

Marostegui updated the task description. (Show Details)Aug 12 2019, 9:31 AM
Stashbot added a comment.Aug 12 2019, 9:32 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-12T09:32:46Z] <marostegui> Stop MySQL on db2043 T230311

Marostegui reassigned this task from Marostegui to RobH.Aug 12 2019, 9:33 AM
Marostegui updated the task description. (Show Details)
Marostegui edited projects, added ops-codfw; removed Patch-For-Review, DBA.

This host is ready for DC-Ops to decommission

Marostegui mentioned this in T228258: Decommission db2043-db2070.Aug 12 2019, 9:34 AM
gerritbot added a comment.Aug 13 2019, 5:43 AM

Change 529851 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] install_server: Remove db2043

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

gerritbot added a project: Patch-For-Review.Aug 13 2019, 5:43 AM

Change 529851 merged by Marostegui:
[operations/puppet@production] install_server: Remove db2043

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

Papaul moved this task from Backlog to Decommission on the ops-codfw board.Aug 16 2019, 3:42 PM
Marostegui moved this task from Backlog to Ready for Decommission on the decommission-hardware board.Sep 5 2019, 9:41 AM
ops-monitoring-bot added a comment.Sep 20 2019, 7:29 AM

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

  • db2043.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.Sep 20 2019, 7:34 AM

Change 538157 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db2043: Remove it from puppet

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

gerritbot added a comment.Sep 20 2019, 7:34 AM

Change 538157 merged by Marostegui:
[operations/puppet@production] db2043: Remove it from puppet

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

gerritbot added a comment.Sep 20 2019, 7:38 AM

Change 538158 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/dns@master] db2043: Decom dns production entries

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

gerritbot added a comment.Sep 20 2019, 7:39 AM

Change 538158 merged by Marostegui:
[operations/dns@master] db2043: Decom dns production entries

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

Marostegui reassigned this task from RobH to Papaul.Sep 20 2019, 7:39 AM
Marostegui updated the task description. (Show Details)
Marostegui added subscribers: Muehlenhoff, Papaul.

I have tried the new cookbook to decom servers after having a chat with @Muehlenhoff - I think this is now ready for @Papaul to fully decom it!

Marostegui moved this task from Ready for Decommission to pending onsite steps (codfw) on the decommission-hardware board.Sep 20 2019, 7:40 AM
Papaul added a comment.Sep 25 2019, 3:47 PM
papaul@asw-c-codfw# show | compare 
[edit interfaces interface-range vlan-private1-c-codfw]
-    member ge-6/0/12;
[edit interfaces interface-range disabled]
     member ge-6/0/8 { ... }
+    member ge-6/0/12;
[edit interfaces]
-   ge-6/0/12 {
-       description db2043;
-       enable;
-   }
Papaul updated the task description. (Show Details)Sep 25 2019, 3:48 PM
Papaul updated the task description. (Show Details)Sep 30 2019, 8:19 PM
gerritbot added a comment.Oct 1 2019, 10:17 PM

Change 540230 had a related patch set uploaded (by Papaul; owner: Papaul):
[operations/dns@master] DNS: Remove mgmt DNS for db2041 db204[3-4] db204[6-7] and db2049

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

gerritbot added a comment.Oct 1 2019, 10:36 PM

Change 540230 merged by Papaul:
[operations/dns@master] DNS: Remove mgmt DNS for db2041 db204[3-4] db204[6-7] and db2049

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

Papaul closed this task as Resolved.Oct 1 2019, 10:39 PM
Papaul updated the task description. (Show Details)

Complete

DannyS712 removed a project: Patch-For-Review.Nov 18 2019, 11:38 AM
DannyS712 subscribed.

[batch] remove patch for review tag from resolved tasks

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