Page MenuHomePhabricator
Create Task
Maniphest T230721

Decommission db2049.codfw.wmnet
Closed, ResolvedPublic
Actions

Description

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

db2049
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.

  • - 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 db2041 db204[3-4] db204[6-7] and db2049operations/dnsmaster+1 -24
wmnet: Remove db2049 production entriesoperations/dnsmaster+0 -2
mariadb: Decommission db2049operations/puppetproduction+0 -5
mariadb: Decommission db2049operations/puppetproduction+6 -9
Customize query in gerrit

Related Objects
Search...

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

Event Timeline

Marostegui triaged this task as Medium priority.Aug 19 2019, 12:41 PM
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.
Stashbot added a comment.Aug 19 2019, 12:50 PM

Mentioned in SAL (#wikimedia-operations) [2019-08-19T12:50:00Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db2049 from config T230721 (duration: 00m 48s)

Stashbot added a comment.Aug 19 2019, 12:51 PM

Mentioned in SAL (#wikimedia-operations) [2019-08-19T12:51:13Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Remove db2049 from config T230721 (duration: 00m 48s)

Marostegui updated the task description. (Show Details)Aug 19 2019, 1:00 PM
gerritbot added a comment.Aug 20 2019, 5:30 AM

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

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

gerritbot added a project: Patch-For-Review.Aug 20 2019, 5:30 AM

Change 531026 merged by Marostegui:
[operations/puppet@production] mariadb: Decommission db2049

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

Stashbot added a comment.Aug 20 2019, 5:35 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-20T05:35:00Z] <marostegui> Stop MySQL on db2049 for decommissioning - T230721

Stashbot added a comment.Aug 20 2019, 5:36 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-20T05:36:59Z] <marostegui> Remove db2049 from tendril and zarcillo T230721

Marostegui reassigned this task from Marostegui to RobH.Aug 20 2019, 5:38 AM
Marostegui edited projects, added decommission-hardware, ops-codfw, DC-Ops; removed Patch-For-Review, DBA.
Marostegui updated the task description. (Show Details)

This host is ready for DC-Ops to decommission

Marostegui moved this task from Backlog to Ready for Decommission on the decommission-hardware board.Sep 5 2019, 9:40 AM
ops-monitoring-bot added a comment.Sep 24 2019, 7:33 AM

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

  • db2049.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 24 2019, 7:34 AM

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

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

gerritbot added a project: Patch-For-Review.Sep 24 2019, 7:34 AM

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

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

gerritbot added a comment.Sep 24 2019, 7:35 AM

Change 538751 merged by Marostegui:
[operations/puppet@production] mariadb: Decommission db2049

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

gerritbot added a comment.Sep 24 2019, 7:36 AM

Change 538752 merged by Marostegui:
[operations/dns@master] wmnet: Remove db2049 production entries

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

Marostegui reassigned this task from RobH to Papaul.Sep 24 2019, 7:37 AM
Marostegui updated the task description. (Show Details)
Marostegui moved this task from Ready for Decommission to pending onsite steps (codfw) on the decommission-hardware board.
Marostegui removed a project: Patch-For-Review.

Host ready for @Papaul to decommission after running the decommission script.

Papaul moved this task from Backlog to Decommission on the ops-codfw board.Sep 25 2019, 2:27 PM
Papaul added a comment.Sep 25 2019, 3:53 PM
papaul@asw-c-codfw# show | compare 
[edit interfaces interface-range vlan-private1-c-codfw]
-    member ge-6/0/18;
[edit interfaces interface-range disabled]
     member ge-6/0/13 { ... }
+    member ge-6/0/18;
[edit interfaces]
-   ge-6/0/18 {
-       description db2049;
-       enable;
-   }
Papaul updated the task description. (Show Details)Sep 25 2019, 3:54 PM
Papaul updated the task description. (Show Details)Sep 30 2019, 5:10 PM
Papaul updated the task description. (Show Details)Oct 1 2019, 1:10 AM
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 project: Patch-For-Review.Oct 1 2019, 10:17 PM
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 updated the task description. (Show Details)Oct 1 2019, 10:53 PM
Papaul closed this task as Resolved.Oct 1 2019, 10:57 PM
DannyS712 removed a project: Patch-For-Review.Nov 18 2019, 11:37 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