Page MenuHomePhabricator
Create Task
Maniphest T244463

Decommission dbproxy1001.eqiad.wmnet
Closed, ResolvedPublic
Actions

Description

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

dbproxy1001

Steps for service owner:

  • - Remove grants T231280
  • - 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/+/570588/
  • - 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.
  • - 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 https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/571628/
  • - remove ALL dns entries except the asset tag mgmt entries. https://gerrit.wikimedia.org/r/#/c/operations/dns/+/571629/
  • - reassign task from service owner to DC ops team member depending on site of server

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.

x[] - 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.
  • - IF RECLAIM: set netbox state to 'inventory' and hostname to asset tag

Details

SubjectRepoBranchLines +/-
DNS: Remove mgmt asset tag for dbproxy100[1-2]operations/dnsmaster+0 -4
wmnet: Remove dbproxy1001 production DNSoperations/dnsmaster+0 -2
site.pp: Remove dbproxy1001 puppet referencesoperations/puppetproduction+0 -5
dbproxy1001: Set it to spareoperations/puppetproduction+7 -15
dbproxy1001: Disable notificationsoperations/puppetproduction+1 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

Marostegui triaged this task as Medium priority.Feb 6 2020, 9:20 AM
Marostegui created this task.
Marostegui moved this task from Triage to In progress on the DBA board.

Not yet ready. This host has stopped being the active m1 proxy master, so let's give it a few days before starting its decommissioning.
We should also test dbproxy1012 first to make sure it can also act as a master for m1.

gerritbot added a comment.Feb 6 2020, 9:23 AM

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

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

gerritbot added a project: Patch-For-Review.Feb 6 2020, 9:23 AM

Change 570588 merged by Marostegui:
[operations/puppet@production] dbproxy1001: Disable notifications

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

Marostegui updated the task description. (Show Details)Feb 6 2020, 9:26 AM
Marostegui removed subscribers: RobH, Papaul.
Maintenance_bot removed a project: Patch-For-Review.Feb 6 2020, 10:10 AM
Marostegui updated the task description. (Show Details)Feb 11 2020, 6:45 AM
Marostegui added subscribers: Papaul, RobH.
Marostegui mentioned this in T231280: Remove grants for the old dbproxy hosts from the misc databases.Feb 11 2020, 6:53 AM
Marostegui updated the task description. (Show Details)Feb 11 2020, 6:56 AM
Stashbot added a comment.Feb 11 2020, 6:59 AM

Mentioned in SAL (#wikimedia-operations) [2020-02-11T06:59:55Z] <marostegui> Stop haproxy on dbproxy1001 - T244463

gerritbot added a comment.Feb 11 2020, 7:03 AM

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

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

gerritbot added a project: Patch-For-Review.Feb 11 2020, 7:03 AM
gerritbot added a comment.Feb 11 2020, 7:17 AM

Change 571425 merged by Marostegui:
[operations/puppet@production] dbproxy1001: Set it to spare

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

Marostegui updated the task description. (Show Details)Feb 11 2020, 7:18 AM
Maintenance_bot removed a project: Patch-For-Review.Feb 11 2020, 8:11 AM
RobH unsubscribed.Feb 11 2020, 4:04 PM
ops-monitoring-bot added a comment.Feb 12 2020, 6:16 AM

cookbooks.sre.hosts.decommission executed by marostegui@cumin1001 for hosts: dbproxy1001.eqiad.wmnet

  • dbproxy1001.eqiad.wmnet (FAIL)
    • Host steps raised exception: Empty Management Password

ERROR: some step on some host failed, check the bolded items above

ops-monitoring-bot added a comment.Feb 12 2020, 6:18 AM

cookbooks.sre.hosts.decommission executed by marostegui@cumin1001 for hosts: dbproxy1001.eqiad.wmnet

  • dbproxy1001.eqiad.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.Feb 12 2020, 6:18 AM

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

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

gerritbot added a project: Patch-For-Review.Feb 12 2020, 6:18 AM

Change 571628 merged by Marostegui:
[operations/puppet@production] site.pp: Remove dbproxy1001 puppet references

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

gerritbot added a comment.Feb 12 2020, 6:22 AM

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

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

gerritbot added a comment.Feb 12 2020, 6:23 AM

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

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

Marostegui reassigned this task from Marostegui to Jclark-ctr.Feb 12 2020, 6:24 AM
Marostegui edited projects, added ops-eqiad, decommission-hardware, SRE; removed Patch-For-Review, DBA.
Marostegui updated the task description. (Show Details)
Marostegui moved this task from Backlog to pending onsite steps (eqiad) on the decommission-hardware board.
Marostegui edited subscribers, added: RobH; removed: Papaul.

Ready for DC-OPs to finish its decommissioning.

Marostegui mentioned this in T245161: Track down and replace very old HW.Feb 17 2020, 6:40 AM
Marostegui moved this task from Backlog to Decommission on the ops-eqiad board.Feb 18 2020, 6:58 AM
Marostegui added a project: DC-Ops.Feb 19 2020, 9:09 AM
Marostegui added a subscriber: Papaul.
RobH unsubscribed.Feb 19 2020, 3:58 PM
Papaul added a comment.Mar 19 2020, 2:28 PM
[edit interfaces interface-range disabled]
     member ge-8/0/4 { ... }
+    member ge-3/0/3;
[edit interfaces interface-range vlan-private1-a-eqiad]
-    member ge-3/0/3;
[edit interfaces]
-   ge-3/0/3 {
-       description dbproxy1001;
-   }
Papaul updated the task description. (Show Details)Mar 19 2020, 2:29 PM
Papaul added a subscriber: RobH.
RobH unsubscribed.Apr 1 2020, 3:45 PM
RobH removed a project: DC-Ops.Apr 1 2020, 4:59 PM
RobH updated the task description. (Show Details)
RobH removed a subscriber: wiki_willy.
RobH updated the task description. (Show Details)Apr 1 2020, 5:41 PM
gerritbot added a comment.Apr 21 2020, 6:38 PM

Change 591417 had a related patch set uploaded (by Papaul; owner: Papaul):
[operations/dns@master] DNS: Remove mgmt asset tag for dbproxy100[1-2]

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

gerritbot added a project: Patch-For-Review.Apr 21 2020, 6:38 PM
gerritbot added a comment.Apr 21 2020, 6:40 PM

Change 591417 merged by Papaul:
[operations/dns@master] DNS: Remove mgmt asset tag for dbproxy100[1-2]

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

Papaul updated the task description. (Show Details)Apr 21 2020, 6:41 PM

@Jclark-ctr this is left for you to finish and resolve when done

• Cmjohnson closed this task as Resolved.May 13 2020, 7:03 PM
• Cmjohnson updated the task description. (Show Details)
• Cmjohnson subscribed.

verified all entries are gone, removed from rack, updated netbox to offline

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