Page MenuHomePhabricator
Create Task
Maniphest T335011

decommission db1110.eqiad.wmnet
Closed, ResolvedPublicRequest
Actions

Description

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

db1110

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

ProjectBranchLines +/-Subject
operations/puppetproduction+0 -10Remove db1110
operations/puppetproduction+0 -1instances.yaml: Remove db1110
operations/puppetproduction+1 -1db1118,db1110: Update notes
operations/puppetproduction+1 -0db1110: Disable notifications
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-ctrT335011 decommission db1110.eqiad.wmnet

Event Timeline

• Marostegui created this task.Apr 19 2023, 6:41 AM
Stashbot added a comment.Apr 19 2023, 6:41 AM

Mentioned in SAL (#wikimedia-operations) [2023-04-19T06:41:22Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1110 T335011', diff saved to https://phabricator.wikimedia.org/P47205 and previous config saved to /var/cache/conftool/dbconfig/20230419-064122-root.json

• Marostegui moved this task from Backlog to Blocked on Service Owners on the decommission-hardware board.Apr 19 2023, 6:41 AM
• Marostegui moved this task from Triage to In progress on the DBA board.
• Marostegui mentioned this in T326683: Decommission db1106-db1125.
• Marostegui added a parent task: T326683: Decommission db1106-db1125.
• Marostegui updated the task description. (Show Details)
• Marostegui added a comment.Apr 19 2023, 8:27 AM

I am going to repool this host as we have the DC switch next week, there's no benefit in decommissioning it today or tomorrow anyways. Better to have more power in case we run into spikes.

• Marostegui updated the task description. (Show Details)Apr 19 2023, 8:27 AM
Stashbot added a comment.May 3 2023, 7:36 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-03T07:36:03Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1110 T335011', diff saved to https://phabricator.wikimedia.org/P47304 and previous config saved to /var/cache/conftool/dbconfig/20230503-073602-root.json

gerritbot added a comment.May 3 2023, 7:36 AM

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

[operations/puppet@production] db1110: Disable notifications

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

gerritbot added a project: Patch-For-Review.May 3 2023, 7:36 AM

Change 914702 merged by Marostegui:

[operations/puppet@production] db1110: Disable notifications

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

• Marostegui updated the task description. (Show Details)May 3 2023, 7:37 AM
• Marostegui changed the task status from Open to Stalled.May 3 2023, 7:43 AM

Stalling until T335092 and T333885 are done

• Marostegui moved this task from In progress to Blocked on the DBA board.May 3 2023, 7:44 AM
gerritbot added a comment.May 3 2023, 7:44 AM

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

[operations/puppet@production] db1118,db1110: Update notes

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

gerritbot added a comment.May 3 2023, 7:45 AM

Change 914703 merged by Marostegui:

[operations/puppet@production] db1118,db1110: Update notes

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

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

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

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

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

gerritbot added a project: Patch-For-Review.Wed, May 3, 11:49 AM

Change 914765 merged by Marostegui:

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

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

• Marostegui updated the task description. (Show Details)Wed, May 3, 11:51 AM
Stashbot added a comment.Wed, May 3, 11:51 AM

Mentioned in SAL (#wikimedia-operations) [2023-05-03T11:51:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Remove db1110 from dbctl T335011', diff saved to https://phabricator.wikimedia.org/P47360 and previous config saved to /var/cache/conftool/dbconfig/20230503-115124-marostegui.json

Maintenance_bot removed a project: Patch-For-Review.Wed, May 3, 12:10 PM
• Marostegui reassigned this task from • Marostegui to Ladsgroup.Tue, May 9, 11:03 AM
• Marostegui moved this task from Blocked to Ready on the DBA board.

This is ready

Ladsgroup added a comment.Tue, May 9, 11:05 AM

Noice

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

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

[operations/puppet@production] Remove db1110

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

gerritbot added a project: Patch-For-Review.Thu, May 11, 1:50 PM
ops-monitoring-bot added a comment.Thu, May 11, 4:00 PM

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

  • db1110.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.Thu, May 11, 4:01 PM

Change 919070 merged by Ladsgroup:

[operations/puppet@production] Remove db1110

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

Stashbot added a comment.Thu, May 11, 4:01 PM

Mentioned in SAL (#wikimedia-operations) [2023-05-11T16:01:56Z] <Amir1> Removing db1110 from zarcillo T335011

Ladsgroup reassigned this task from Ladsgroup to wiki_willy.Thu, May 11, 4:03 PM
Ladsgroup edited projects, added ops-eqiad; removed Patch-For-Review.
Ladsgroup moved this task from Ready to Done on the DBA board.
Ladsgroup added a subscriber: Ladsgroup.
wiki_willy reassigned this task from wiki_willy to Jclark-ctr.Thu, May 11, 4:04 PM
wiki_willy added a subscriber: wiki_willy.
Maintenance_bot added a project: SRE.Thu, May 11, 4:29 PM
Ladsgroup updated the task description. (Show Details)Fri, May 12, 1:22 PM
Jclark-ctr closed this task as Resolved.Mon, May 15, 2:06 PM
Jclark-ctr updated the task description. (Show Details)
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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