Page MenuHomePhabricator
Create Task
Maniphest T383572

decommission db2128.codfw.wmnet
Closed, ResolvedPublicRequest
Actions

Description

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

db2128

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. (likely done by script)
  • - 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, and run homer.
  • - remove all remaining puppet references and all host entries in the puppet repo
  • - reassign task from service owner to no owner and ensure the site project (ops-sitename depending on site of server) is assigned.

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

  • - system disks removed (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: mgmt dns entries removed.
  • - IF RECLAIM: set netbox state to 'inventory' and hostname to asset tag

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
mariadb: Remove db2128operations/puppetproduction+0 -8
db2128: Disable notificationsoperations/puppetproduction+1 -2
instances.yaml: Remove db2128operations/puppetproduction+0 -1
Customize query in gerrit

Related Objects
Search...

Event Timeline

Marostegui created this task.EditedJan 13 2025, 3:27 PM
Marostegui moved this task from Triage to In progress on the DBA board.
  • Depool the host:
sudo dbctl instance db2128 depool
sudo dbctl config commit -m "Depool db2128 T383572"
  • Make puppet patch to remove it from dbctl
  • Merge the puppet patch
  • Run dbctl commit:
sudo dbctl config commit -m "Remove db2128 from dbctl T383572"
  • Make puppet patch cleaning the rest up (DO NOT merge)
  • Run the decommissioning script:
sudo cookbook sre.hosts.decommission -t T383572 db2128.codfw.wmnet
  • Merge the puppet patch
  • Remove from zacillo
    • In IRC: !log Removing db2128 from zarcillo T383572
    • In cumin: sudo db-mysql db1215 -A zarcillo
set binlog_format='ROW';
delete from servers where hostname="db2128";
delete from instances where name like 'db2128%';
delete from section_instances where instance like 'db2128%';
  • Remove host from orchestrator
  • Update the task and hand it over to dcops
Stashbot added a comment.Jan 13 2025, 3:28 PM

Mentioned in SAL (#wikimedia-operations) [2025-01-13T15:28:29Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depool db2128 T383572', diff saved to https://phabricator.wikimedia.org/P72012 and previous config saved to /var/cache/conftool/dbconfig/20250113-152828-marostegui.json

gerritbot added a comment.Jan 13 2025, 3:29 PM

Change #1110799 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] instances.yaml: Remove db2128

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

gerritbot added a project: Patch-For-Review.Jan 13 2025, 3:29 PM

Change #1110799 merged by Marostegui:

[operations/puppet@production] instances.yaml: Remove db2128

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

Marostegui updated the task description. (Show Details)Jan 13 2025, 3:30 PM
Stashbot added a comment.Jan 13 2025, 3:30 PM

Mentioned in SAL (#wikimedia-operations) [2025-01-13T15:30:46Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Remove db2128 from dbctl T383572', diff saved to https://phabricator.wikimedia.org/P72013 and previous config saved to /var/cache/conftool/dbconfig/20250113-153046-marostegui.json

Maintenance_bot removed a project: Patch-For-Review.Jan 13 2025, 3:31 PM
gerritbot added a comment.Jan 13 2025, 3:31 PM

Change #1110800 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] db2128: Disable notifications

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

gerritbot added a project: Patch-For-Review.Jan 13 2025, 3:31 PM

Change #1110800 merged by Marostegui:

[operations/puppet@production] db2128: Disable notifications

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

Marostegui updated the task description. (Show Details)Jan 13 2025, 3:32 PM
Marostegui added a parent task: T374623: Decommission db21[21-40].
Marostegui mentioned this in T374623: Decommission db21[21-40].
Maintenance_bot removed a project: Patch-For-Review.Jan 13 2025, 4:31 PM
gerritbot added a comment.Jan 14 2025, 12:44 PM

Change #1111211 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] mariadb: Remove db2128

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

gerritbot added a project: Patch-For-Review.Jan 14 2025, 12:44 PM

Change #1111211 merged by Marostegui:

[operations/puppet@production] mariadb: Remove db2128

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

Marostegui updated the task description. (Show Details)Jan 14 2025, 12:45 PM
ops-monitoring-bot added a comment.Jan 14 2025, 12:52 PM

cookbooks.sre.hosts.decommission executed by marostegui@cumin1002 for hosts: db2128.codfw.wmnet

  • db2128.codfw.wmnet (PASS)
    • Downtimed host on Icinga/Alertmanager
    • Found physical host
    • Downtimed management interface on Alertmanager
    • Wiped all swraid, partition-table and filesystem signatures
    • Powered off
    • [Netbox] Set status to Decommissioning, deleted all non-mgmt IPs, updated switch interfaces (disabled, removed vlans, etc)
    • Configured the linked switch interface(s)
    • Removed from DebMonitor
    • Removed from Puppet master and PuppetDB
Marostegui removed Marostegui as the assignee of this task.Jan 14 2025, 12:52 PM
Marostegui updated the task description. (Show Details)
Marostegui added a project: ops-codfw.
Restricted Application added a project: DC-Ops. · View Herald TranscriptJan 14 2025, 12:52 PM
Marostegui moved this task from In progress to Done on the DBA board.Jan 14 2025, 12:53 PM

This is ready for DC-Ops

Marostegui moved this task from Backlog to pending onsite steps (codfw) on the decommission-hardware board.Jan 14 2025, 12:53 PM
Maintenance_bot added a project: SRE.Jan 14 2025, 1:29 PM
Maintenance_bot removed a project: Patch-For-Review.
Jhancock.wm moved this task from Backlog to Decommission on the ops-codfw board.Jan 14 2025, 2:29 PM
Jhancock.wm closed this task as Resolved.Jan 14 2025, 3:24 PM
Jhancock.wm claimed this task.
Jhancock.wm updated the task description. (Show Details)
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