Page MenuHomePhabricator
Create Task
Maniphest T334910

decommission db1123.eqiad.wmnet
Closed, ResolvedPublicRequest
Actions

Description

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

db1123.eqiad.wmnet

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 DC ops team member and site project (ops-sitename) depending on site of server

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.

Details

SubjectRepoBranchLines +/-
Remove db1123operations/puppetproduction+1 -3
conftool-data: Remove db1123operations/puppetproduction+0 -1
Customize query in gerrit

Related Objects
Search...

StatusSubtypeAssignedTask
Unknown Object (Task)
 ResolvedPapaulT326661 Q3:rack/setup/install db1207-db1225
 Resolved• MarosteguiT326669 Productionize db1206-db1225
 Open• MarosteguiT326683 Decommission db1106-db1125
 ResolvedRequestJclark-ctrT334910 decommission db1123.eqiad.wmnet

Event Timeline

• Marostegui created this task.Apr 18 2023, 8:00 AM
• Marostegui mentioned this in T326683: Decommission db1106-db1125.
• Marostegui moved this task from Triage to In progress on the DBA board.
• Marostegui added a parent task: T326683: Decommission db1106-db1125.
• Marostegui moved this task from Backlog to Blocked on Service Owners on the decommission-hardware board.Apr 19 2023, 6:43 AM
• Marostegui reassigned this task from • Marostegui to Ladsgroup.May 3 2023, 8:44 AM
Ladsgroup added a comment.EditedMay 15 2023, 9:49 AM

DBA-specific checklist:

  • Depool the host:
sudo dbctl instance db1123 depool
sudo dbctl config commit -m "Depool db1123 T334910"
  • Make puppet patch to remove it from dbctl
  • Merge the puppet patch
  • Run dbctl commit:
sudo dbctl config commit -m "Remove db1123 from dbctl T334910"
  • Make puppet patch cleaning the rest up (DO NOT merge)
  • Run the decommissioning script:
sudo cookbook sre.hosts.decommission -t T334910 db1123.eqiad.wmnet
  • Merge the puppet patch
  • Remove from zacillo
    • In IRC: !log Removing db1123 from zarcillo T334910
    • In cumin: sudo db-mysql db1215 -A zarcillo
set binlog_format='ROW';
delete from servers where hostname="db1123";
delete from instances where name like 'db1123%';
delete from section_instances where instance like 'db1123%';
  • Remove host from orchestrator
  • Update the task and hand it over to dcops
Stashbot added a comment.May 15 2023, 9:49 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-15T09:49:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depool db1123 T334910', diff saved to https://phabricator.wikimedia.org/P48220 and previous config saved to /var/cache/conftool/dbconfig/20230515-094938-ladsgroup.json

gerritbot added a comment.May 15 2023, 9:51 AM

Change 919805 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/puppet@production] conftool-data: Remove db1123

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

gerritbot added a project: Patch-For-Review.May 15 2023, 9:51 AM

Change 919805 merged by Ladsgroup:

[operations/puppet@production] conftool-data: Remove db1123

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

Stashbot added a comment.May 15 2023, 9:54 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-15T09:54:12Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Remove db1123 from dbctl T334910', diff saved to https://phabricator.wikimedia.org/P48221 and previous config saved to /var/cache/conftool/dbconfig/20230515-095412-ladsgroup.json

gerritbot added a comment.May 15 2023, 9:56 AM

Change 919807 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/puppet@production] Remove db1123

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

ops-monitoring-bot added a comment.May 15 2023, 10:15 AM

cookbooks.sre.hosts.decommission executed by ladsgroup@cumin1001 for hosts: db1123.eqiad.wmnet

  • db1123.eqiad.wmnet (WARN)
    • Downtimed host on Icinga/Alertmanager
    • Found physical host
    • Management interface not found on Icinga, unable to downtime it
    • 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
gerritbot added a comment.May 15 2023, 10:18 AM

Change 919807 merged by Ladsgroup:

[operations/puppet@production] Remove db1123

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

Stashbot added a comment.May 15 2023, 10:19 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-15T10:19:34Z] <Amir1> Removing db1123 from zarcillo T334910

Maintenance_bot removed a project: Patch-For-Review.May 15 2023, 10:30 AM
Ladsgroup reassigned this task from Ladsgroup to wiki_willy.May 15 2023, 10:39 AM
Ladsgroup updated the task description. (Show Details)
Ladsgroup added a project: ops-eqiad.
Ladsgroup moved this task from In progress to Done on the DBA board.
Ladsgroup subscribed.
Maintenance_bot added a project: SRE.May 15 2023, 10:45 AM
wiki_willy reassigned this task from wiki_willy to Jclark-ctr.May 15 2023, 4:43 PM
wiki_willy subscribed.
Jclark-ctr moved this task from Backlog to Decommission on the ops-eqiad board.May 15 2023, 9:34 PM
• Marostegui removed a project: DBA.May 16 2023, 5:08 AM
Jclark-ctr closed this task as Resolved.May 17 2023, 3:02 PM
Jclark-ctr 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