Page MenuHomePhabricator
Create Task
Maniphest T233185

Decommission db2067.codfw.wmnet
Closed, ResolvedPublic
Actions

Description

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

With the launch of updates to the decom cookbook, the majority of these steps can be handled by the service owners directly. The DC Ops team only gets involved once the system has been fully removed from service and powered down by the decommission cookbook.

db2067

Steps for service owner:

  • - all system services confirmed offline from production use
  • - set all icinga checks to maint mode/disabled while reclaim/decommmission takes place. https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/552198/
  • - remove system from all lvs/pybal active configuration
  • - any service group puppet/hiera/dsh config removed
  • - remove site.pp, replace with role(spare::system) recommended to ensure services offline but not 100% required as long as the decom script is IMMEDIATELY run below. https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/553444/
  • - login to cumin host and run the decom cookbook: cookbook sre.hosts.decommission <host fqdn> -t <phab task>. This does: bootloader wipe, host power down, netbox update to decommissioning status, puppet node clean, puppet node deactivate, debmonitor removal.
  • - remove all remaining puppet references (include role::spare) and all host entries in the puppet repo
  • - remove ALL dns entries except the asset tag mgmt entries.
  • - reassign task from service owner to DC ops team member depending on site of server: codfw = @Papaul, eqiad = @Jclark-ctr, all other sites = @RobH.

End service owner steps / Begin DC-Ops team steps:

  • - disable switch port / set to asset tag if host isn't being unracked / remove from switch if being unracked.
  • - system disks wiped (by onsite)
  • - determine system age, under 5 years are reclaimed to spare, over 5 years are decommissioned. If uncertain, ask @wiki_willy.
  • - IF DECOM: system unracked and decommissioned (by onsite), update netbox with result and set state to offline
  • - 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 db2062 and db2067operations/dnsmaster+0 -10
wmnet: Remove production dns entries for db2067operations/dnsmaster+0 -2
site.pp: Remove puppet references for db2067operations/puppetproduction+0 -5
mariadb: Set db2067 to spareoperations/puppetproduction+1 -11
db2067: Disable notificationsoperations/puppetproduction+1 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

Marostegui changed the task status from Open to Stalled.Sep 18 2019, 5:19 AM
Marostegui triaged this task as Medium priority.
Marostegui created this task.
Marostegui moved this task from Triage to Backlog on the DBA board.

This host is now working as m2 master in codfw, and will be replaced once the new misc hosts are bought.

Marostegui mentioned this in T228258: Decommission db2043-db2070.Sep 18 2019, 5:20 AM
Marostegui added a parent task: T238183: Productionize db213[2-5}.Nov 13 2019, 10:03 AM
Marostegui changed the task status from Stalled to Open.Nov 20 2019, 9:25 AM
Marostegui moved this task from Backlog to Pending comment on the DBA board.
gerritbot added a comment.Nov 21 2019, 8:23 AM

Change 552198 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db2067: Disable notifications

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

gerritbot added a project: Patch-For-Review.Nov 21 2019, 8:23 AM

Change 552198 merged by Marostegui:
[operations/puppet@production] db2067: Disable notifications

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

Marostegui updated the task description. (Show Details)Nov 21 2019, 8:27 AM
Marostegui mentioned this in T208323: Predictive failures on disk S.M.A.R.T. status.
Maintenance_bot removed a project: Patch-For-Review.Nov 21 2019, 9:10 AM
gerritbot added a comment.Nov 28 2019, 5:58 AM

Change 553444 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: Set db2067 to spare

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

gerritbot added a project: Patch-For-Review.Nov 28 2019, 5:58 AM
gerritbot added a comment.Nov 28 2019, 6:01 AM

Change 553444 merged by Marostegui:
[operations/puppet@production] mariadb: Set db2067 to spare

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

Marostegui updated the task description. (Show Details)Nov 28 2019, 6:02 AM
Marostegui added subscribers: Jclark-ctr, wiki_willy, Papaul.
Stashbot added a comment.Nov 28 2019, 6:02 AM

Mentioned in SAL (#wikimedia-operations) [2019-11-28T06:02:25Z] <marostegui> Remove db2067 from tendril and zarcillo T233185

Maintenance_bot removed a project: Patch-For-Review.Nov 28 2019, 6:10 AM
Marostegui moved this task from Pending comment to In progress on the DBA board.Nov 29 2019, 6:10 AM
gerritbot added a comment.Dec 3 2019, 5:52 AM

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

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

gerritbot added a project: Patch-For-Review.Dec 3 2019, 5:52 AM

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

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

ops-monitoring-bot added a comment.Dec 3 2019, 5:53 AM

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

  • db2067.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.Dec 3 2019, 5:54 AM

Change 554234 merged by Marostegui:
[operations/puppet@production] site.pp: Remove puppet references for db2067

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

gerritbot added a comment.Dec 3 2019, 5:55 AM

Change 554235 merged by Marostegui:
[operations/dns@master] wmnet: Remove production dns entries for db2067

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

Marostegui reassigned this task from Marostegui to Papaul.Dec 3 2019, 5:56 AM
Marostegui edited projects, added decommission-hardware, ops-codfw, DC-Ops; removed Patch-For-Review, DBA.
Marostegui updated the task description. (Show Details)
Restricted Application added a project: SRE. · View Herald TranscriptDec 3 2019, 5:56 AM
Marostegui moved this task from Backlog to pending onsite steps (codfw) on the decommission-hardware board.Dec 3 2019, 5:56 AM

host ready for @Papaul to take over the last steps

Papaul added a comment.Dec 4 2019, 1:57 AM
[edit interfaces interface-range vlan-private1-d-codfw]
-    member ge-6/0/15;
[edit interfaces interface-range disabled]
     member ge-6/0/9 { ... }
+    member ge-6/0/15;
[edit interfaces]
-   ge-6/0/15 {
-       description db2067;
-       enable;
-   }
Papaul moved this task from Backlog to Decommission on the ops-codfw board.Dec 4 2019, 5:45 PM
Papaul updated the task description. (Show Details)Dec 6 2019, 12:11 AM
gerritbot added a comment.Dec 6 2019, 12:15 AM

Change 554972 had a related patch set uploaded (by Papaul; owner: Papaul):
[operations/dns@master] DNS: Remove mgmt DNS for db2062 and db2067

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

gerritbot added a project: Patch-For-Review.Dec 6 2019, 12:15 AM
gerritbot added a comment.Dec 6 2019, 12:20 AM

Change 554972 merged by Papaul:
[operations/dns@master] DNS: Remove mgmt DNS for db2062 and db2067

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

Papaul closed this task as Resolved.Dec 6 2019, 12:22 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