Page MenuHomePhabricator
Create Task
Maniphest T336332

decommission db1112.eqiad.wmnet
Closed, ResolvedPublicRequest
Actions

Description

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

db1112.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 db1112 from puppetoperations/puppetproduction+1 -4
db1112: Remove from dbctloperations/puppetproduction+0 -1
db1112: Disable notificationsoperations/puppetproduction+1 -0
Customize query in gerrit

Related Objects
Search...

StatusSubtypeAssignedTask
Unknown Object (Task)
 ResolvedPapaulT326661 Q3:rack/setup/install db1207-db1225
 ResolvedMarosteguiT326669 Productionize db1206-db1225
 ResolvedMarosteguiT326683 Decommission db1106-db1125
 ResolvedRequestJclark-ctrT336332 decommission db1112.eqiad.wmnet

Event Timeline

Marostegui created this task.May 10 2023, 6:48 AM
Marostegui moved this task from Triage to Blocked on the DBA board.
Marostegui mentioned this in T326683: Decommission db1106-db1125.
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.May 16 2023, 5:49 AM
Stashbot added a comment.May 16 2023, 5:51 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-16T05:51:23Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1112 T336332', diff saved to https://phabricator.wikimedia.org/P48242 and previous config saved to /var/cache/conftool/dbconfig/20230516-055122-root.json

Marostegui updated the task description. (Show Details)May 16 2023, 5:52 AM
gerritbot added a comment.May 16 2023, 5:52 AM

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

[operations/puppet@production] db1112: Disable notifications

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

gerritbot added a project: Patch-For-Review.May 16 2023, 5:52 AM
Marostegui moved this task from Blocked to In progress on the DBA board.May 16 2023, 5:52 AM
gerritbot added a comment.May 16 2023, 5:53 AM

Change 920142 merged by Marostegui:

[operations/puppet@production] db1112: Disable notifications

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

Maintenance_bot removed a project: Patch-For-Review.May 16 2023, 6:10 AM
gerritbot added a comment.May 17 2023, 5:18 AM

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

[operations/puppet@production] db1112: Remove from dbctl

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

gerritbot added a project: Patch-For-Review.May 17 2023, 5:18 AM

Change 920564 merged by Marostegui:

[operations/puppet@production] db1112: Remove from dbctl

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

Stashbot added a comment.May 17 2023, 5:20 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-17T05:20:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Remove db1112 from dbctl T336332', diff saved to https://phabricator.wikimedia.org/P48263 and previous config saved to /var/cache/conftool/dbconfig/20230517-052007-marostegui.json

Marostegui reassigned this task from Marostegui to Ladsgroup.May 17 2023, 5:20 AM
Marostegui updated the task description. (Show Details)
Marostegui added a subscriber: Ladsgroup.

This is ready to go @Ladsgroup

Maintenance_bot removed a project: Patch-For-Review.May 17 2023, 5:30 AM
Ladsgroup added a comment.EditedMay 17 2023, 6:39 PM

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 T336332 db1112.eqiad.wmnet
  • Merge the puppet patch
  • Remove from zacillo
    • In IRC: !log Removing db1112 from zarcillo T336332
    • In cumin: sudo db-mysql db1215 -A zarcillo
set binlog_format='ROW';
delete from servers where hostname="db1112";
delete from instances where name like 'db1112%';
delete from section_instances where instance like 'db1112%';
  • Remove host from orchestrator
  • Update the task and hand it over to dcops
gerritbot added a comment.May 17 2023, 6:41 PM

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

[operations/puppet@production] Remove db1112 from puppet

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

gerritbot added a project: Patch-For-Review.May 17 2023, 6:41 PM
ops-monitoring-bot added a comment.May 17 2023, 6:59 PM

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

  • db1112.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 17 2023, 7:00 PM

Change 920768 merged by Ladsgroup:

[operations/puppet@production] Remove db1112 from puppet

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

Stashbot added a comment.May 17 2023, 7:01 PM

Mentioned in SAL (#wikimedia-operations) [2023-05-17T19:01:34Z] <Amir1> Removing db1112 from zarcillo T336332

Ladsgroup reassigned this task from Ladsgroup to wiki_willy.May 17 2023, 7:03 PM
Ladsgroup updated the task description. (Show Details)
Ladsgroup edited projects, added ops-eqiad; removed Patch-For-Review, DBA.
Ladsgroup moved this task from Blocked on Service Owners to Ready for Decommission on the decommission-hardware board.
Maintenance_bot added a project: SRE.May 17 2023, 7:29 PM
wiki_willy reassigned this task from wiki_willy to Jclark-ctr.May 17 2023, 9:07 PM
wiki_willy subscribed.
Jclark-ctr closed this task as Resolved.May 18 2023, 6:44 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