Page MenuHomePhabricator
Create Task
Maniphest T336029

decommission db1113.eqiad.wmnet
Closed, ResolvedPublicRequest
Actions

Description

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

db1113.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 db1113 from puppetoperations/puppetproduction+3 -9
instances.yaml: Remove db1113 (s5,s6)operations/puppetproduction+0 -2
db1113: Disable notificationsoperations/puppetproduction+1 -0
Customize query in gerrit

Related Objects
Search...

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

Event Timeline

• Marostegui created this task.May 5 2023, 8:21 AM
• Marostegui added a parent task: T326683: Decommission db1106-db1125.
• Marostegui moved this task from Triage to Blocked on the DBA board.
• Marostegui mentioned this in T326683: Decommission db1106-db1125.May 8 2023, 5:09 AM
gerritbot added a comment.May 8 2023, 5:10 AM

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

[operations/puppet@production] db1113: Disable notifications

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

gerritbot added a project: Patch-For-Review.May 8 2023, 5:10 AM
Stashbot added a comment.May 8 2023, 5:10 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-08T05:10:37Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1113 (s5,s6) T336029', diff saved to https://phabricator.wikimedia.org/P47783 and previous config saved to /var/cache/conftool/dbconfig/20230508-051036-root.json

• Marostegui updated the task description. (Show Details)May 8 2023, 5:10 AM
gerritbot added a comment.May 8 2023, 5:11 AM

Change 916894 merged by Marostegui:

[operations/puppet@production] db1113: Disable notifications

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

Maintenance_bot removed a project: Patch-For-Review.May 8 2023, 5:30 AM
gerritbot added a comment.May 8 2023, 11:10 AM

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

[operations/puppet@production] instances.yaml: Remove db1113 (s5,s6)

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

gerritbot added a project: Patch-For-Review.May 8 2023, 11:10 AM

Change 917301 merged by Marostegui:

[operations/puppet@production] instances.yaml: Remove db1113 (s5,s6)

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

Stashbot added a comment.May 8 2023, 11:11 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-08T11:11:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Remove db1113 from dbctl T336029', diff saved to https://phabricator.wikimedia.org/P47847 and previous config saved to /var/cache/conftool/dbconfig/20230508-111113-marostegui.json

• Marostegui updated the task description. (Show Details)May 8 2023, 11:11 AM
Maintenance_bot removed a project: Patch-For-Review.May 8 2023, 11:11 AM
• Marostegui reassigned this task from • Marostegui to • Ladsgroup.May 9 2023, 11:40 AM

This is ready

• Marostegui moved this task from Blocked to Ready on the DBA board.May 9 2023, 11:40 AM
• Marostegui moved this task from Backlog to Blocked on Service Owners on the decommission-hardware board.May 10 2023, 6:47 AM
• Ladsgroup moved this task from Ready to In progress on the DBA board.EditedMay 10 2023, 10:03 AM

DBA-specific checklist:

  • Remove host from dbctl (done or NA)
  • Make puppet patch cleaning the rest up (DO NOT merge)
  • Run the decommissioning script:
sudo cookbook sre.hosts.decommission -t T336029 db1113.eqiad.wmnet
  • Merge the puppet patch
  • Remove from zacillo
    • In IRC: !log Removing db1113 from zarcillo T336029
    • In cumin: sudo db-mysql db1215 -A zarcillo
set binlog_format='ROW';
delete from servers where hostname="db1113";
delete from instances where name like 'db1113%';
delete from section_instances where instance like 'db1113%';
  • Remove host from orchestrator
  • Update the task and hand it over to dcops
gerritbot added a comment.May 10 2023, 10:06 AM

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

[operations/puppet@production] Remove db1113 from puppet

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

gerritbot added a project: Patch-For-Review.May 10 2023, 10:06 AM
ops-monitoring-bot added a comment.May 10 2023, 10:17 AM

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

  • db1113.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 10 2023, 10:26 AM

Change 918417 merged by Ladsgroup:

[operations/puppet@production] Remove db1113 from puppet

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

Stashbot added a comment.May 10 2023, 10:26 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-10T10:26:47Z] <Amir1> Removing db1113 from zarcillo T336029

• Ladsgroup reassigned this task from • Ladsgroup to wiki_willy.May 10 2023, 10:29 AM
• Ladsgroup edited projects, added ops-eqiad; removed Patch-For-Review.
• Ladsgroup moved this task from In progress to Done on the DBA board.
• Ladsgroup updated the task description. (Show Details)
• Ladsgroup subscribed.
• Ladsgroup moved this task from Blocked on Service Owners to pending onsite steps (eqiad) on the decommission-hardware board.May 10 2023, 10:35 AM
Maintenance_bot added a project: SRE.May 10 2023, 10:45 AM
wiki_willy reassigned this task from wiki_willy to Jclark-ctr.May 10 2023, 3:09 PM
wiki_willy subscribed.
Jclark-ctr moved this task from Backlog to Decommission on the ops-eqiad board.May 10 2023, 7:11 PM
• Marostegui removed a project: DBA.May 16 2023, 5:30 AM
Jclark-ctr closed this task as Resolved.May 17 2023, 3:03 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 · Credits