Page MenuHomePhabricator
Create Task
Maniphest T245384

decommission dbproxy1002.eqiad.wmnet
Closed, ResolvedPublicRequest
Actions

Description

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

dbproxy1002

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/572514
  • - 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
  • - 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

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 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
report_users: Remove dbproxy1002 IPoperations/softwaremaster+3 -3
wmnet: Remove production dns for dbproxy1002operations/dnsmaster+0 -2
dbproxy1002: Decommission this host.operations/puppetproduction+2 -108
dbproxy100[2,7]: Disable notificationsoperations/puppetproduction+2 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

• Marostegui created this task.Feb 17 2020, 6:31 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 17 2020, 6:31 AM
gerritbot added a comment.Feb 17 2020, 6:32 AM

Change 572514 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] dbproxy100[2,7]: Disable notifications

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

gerritbot added a project: Patch-For-Review.Feb 17 2020, 6:32 AM
• Marostegui mentioned this in T231280: Remove grants for the old dbproxy hosts from the misc databases.Feb 17 2020, 6:34 AM
• Marostegui mentioned this in T245161: Track down and replace very old HW.Feb 17 2020, 6:37 AM
• Marostegui added a parent task: T231280: Remove grants for the old dbproxy hosts from the misc databases.Feb 17 2020, 6:40 AM
• Marostegui updated the task description. (Show Details)
gerritbot added a comment.Feb 17 2020, 6:46 AM

Change 572514 merged by Marostegui:
[operations/puppet@production] dbproxy100[2,7]: Disable notifications

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

• Marostegui moved this task from Triage to Pending comment on the DBA board.Feb 17 2020, 7:00 AM
Maintenance_bot removed a project: Patch-For-Review.Feb 17 2020, 7:10 AM
Stashbot added a comment.Feb 17 2020, 7:22 AM

Mentioned in SAL (#wikimedia-operations) [2020-02-17T07:22:06Z] <marostegui> Stop haproxy on dbproxy1002 - T245384

gerritbot added a comment.Feb 18 2020, 6:07 AM

Change 572770 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] dbproxy1002: Decommission this host.

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

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

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

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

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

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

  • dbproxy1002.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 18 2020, 6:11 AM

Change 572770 merged by Marostegui:
[operations/puppet@production] dbproxy1002: Decommission this host.

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

gerritbot added a comment.Feb 18 2020, 6:11 AM

Change 572771 merged by Marostegui:
[operations/dns@master] wmnet: Remove production dns for dbproxy1002

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

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

Host ready for on-site steps

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

Change 572774 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/software@master] report_users: Remove dbproxy1002 IP

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

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

Change 572774 merged by Marostegui:
[operations/software@master] report_users: Remove dbproxy1002 IP

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

• Marostegui moved this task from Backlog to Decommission on the ops-eqiad board.Feb 18 2020, 6:57 AM
• Marostegui added a project: DC-Ops.Feb 19 2020, 9:09 AM
• Marostegui added subscribers: Papaul, RobH.
RobH unsubscribed.Feb 19 2020, 3:58 PM
Papaul added a comment.Mar 19 2020, 2:34 PM
[edit interfaces interface-range disabled]
     member ge-3/0/3 { ... }
+    member ge-3/0/4;
[edit interfaces interface-range vlan-private1-a-eqiad]
-    member ge-3/0/4;
[edit interfaces]
-   ge-3/0/4 {
-       description dbproxy1002;
-   }
Papaul updated the task description. (Show Details)Mar 19 2020, 2:35 PM
Papaul added a subscriber: RobH.
RobH unsubscribed.Apr 1 2020, 3:45 PM
RobH updated the task description. (Show Details)Apr 1 2020, 4:58 PM
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 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:44 PM
Papaul added a comment.Apr 21 2020, 6:48 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 subscribed.

Removed server from rack, updated netbox

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