Page MenuHomePhabricator
Create Task
Maniphest T239188

Decommission db1062.eqiad.wmnet
Closed, ResolvedPublic
Actions

Description

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

db1062

Steps for service owner:

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

  • - Label disk #0 as broken so it doesn't get re-used
  • - disable switch port / set to asset tag if host isn't being unracked / remove from switch if being unracked.
  • - system disks wiped (by onsite) ( removed for shreding)
  • - determine system age, under 5 years are reclaimed to spare, over 5 years are decommissioned. If uncertain, ask @wiki_willy.
  • - IF DECOM: system unracked and decommissioned (by onsite), update netbox with result and set state to offline
  • - IF DECOM: switch port configration removed from switch once system is unracked.
  • - IF DECOM: add system to decommission tracking google sheet
  • - IF DECOM: mgmt dns entries removed.

Details

SubjectRepoBranchLines +/-
wmnet: Remove production DNS for db1062operations/dnsmaster+0 -2
site.pp: Remove puppet references for db1062operations/puppetproduction+0 -6
mariadb: db1062 set it to spareoperations/puppetproduction+6 -10
instances.yaml: Remove db1062 from configoperations/puppetproduction+0 -1
db-eqiad,db-codfw.php: Remove db1062 from configoperations/mediawiki-configmaster+0 -2
db1062: Disable notificationsoperations/puppetproduction+1 -0
Customize query in gerrit

Related Objects
Search...

StatusSubtypeAssignedTask
 ResolvedMarosteguiT217396 Decommission db1061-db1073
 ResolvedJclark-ctrT239188 Decommission db1062.eqiad.wmnet

Event Timeline

Marostegui created this task.Nov 26 2019, 6:52 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 26 2019, 6:52 AM
Marostegui triaged this task as Medium priority.Nov 26 2019, 6:53 AM
Marostegui moved this task from Triage to Pending comment on the DBA board.
Marostegui mentioned this in T217396: Decommission db1061-db1073.
Marostegui updated the task description. (Show Details)
gerritbot added a comment.Nov 26 2019, 7:12 AM

Change 552963 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db1062: Disable notifications

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

gerritbot added a project: Patch-For-Review.Nov 26 2019, 7:12 AM
Marostegui updated the task description. (Show Details)Nov 26 2019, 7:13 AM
gerritbot added a comment.Nov 26 2019, 7:15 AM

Change 552963 merged by Marostegui:
[operations/puppet@production] db1062: Disable notifications

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

Marostegui updated the task description. (Show Details)Nov 26 2019, 7:17 AM
Maintenance_bot removed a project: Patch-For-Review.Nov 26 2019, 11:51 AM
Stashbot added a comment.Dec 3 2019, 6:07 AM

Mentioned in SAL (#wikimedia-operations) [2019-12-03T06:07:27Z] <marostegui> Stop MySQL on db1062 for decommissioning T239188

gerritbot added a comment.Dec 3 2019, 8:25 AM

Change 554243 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad,db-codfw.php: Remove db1062 from config

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

gerritbot added a project: Patch-For-Review.Dec 3 2019, 8:25 AM
Marostegui updated the task description. (Show Details)Dec 3 2019, 8:27 AM
gerritbot added a comment.Dec 3 2019, 8:27 AM

Change 554243 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad,db-codfw.php: Remove db1062 from config

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

Stashbot added a comment.Dec 3 2019, 8:29 AM

Mentioned in SAL (#wikimedia-operations) [2019-12-03T08:29:15Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db1062 from config T239188 (duration: 01m 08s)

Stashbot added a comment.Dec 3 2019, 8:30 AM

Mentioned in SAL (#wikimedia-operations) [2019-12-03T08:30:25Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Remove db1062 from config T239188 (duration: 01m 02s)

Maintenance_bot removed a project: Patch-For-Review.Dec 3 2019, 9:10 AM
Marostegui moved this task from Pending comment to In progress on the DBA board.Dec 3 2019, 10:25 AM
RobH unsubscribed.Dec 3 2019, 5:04 PM
Krinkle mentioned this in T239874: MediaWiki: "host db1062 is unreachable" (Connection refused).Dec 4 2019, 11:27 PM
gerritbot added a comment.Dec 5 2019, 8:04 AM

Change 554678 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] instances.yaml: Remove db1062 from config

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

gerritbot added a project: Patch-For-Review.Dec 5 2019, 8:04 AM

Change 554678 merged by Marostegui:
[operations/puppet@production] instances.yaml: Remove db1062 from config

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

Marostegui updated the task description. (Show Details)Dec 5 2019, 8:07 AM
Marostegui added a subscriber: RobH.
Stashbot added a comment.Dec 5 2019, 8:09 AM

Mentioned in SAL (#wikimedia-operations) [2019-12-05T08:09:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Remove db1062 from etcd T239188', diff saved to https://phabricator.wikimedia.org/P9821 and previous config saved to /var/cache/conftool/dbconfig/20191205-080909-marostegui.json

Maintenance_bot removed a project: Patch-For-Review.Dec 5 2019, 8:10 AM
Stashbot added a comment.Dec 10 2019, 6:39 AM

Mentioned in SAL (#wikimedia-operations) [2019-12-10T06:39:14Z] <marostegui> Remove db1062 from tendril and zarcillo T239188

gerritbot added a comment.Dec 10 2019, 6:42 AM

Change 556101 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: db1062 set it to spare

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

gerritbot added a project: Patch-For-Review.Dec 10 2019, 6:42 AM

Change 556101 merged by Marostegui:
[operations/puppet@production] mariadb: db1062 set it to spare

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

Marostegui updated the task description. (Show Details)Dec 10 2019, 6:45 AM
Marostegui updated the task description. (Show Details)
Maintenance_bot removed a project: Patch-For-Review.Dec 10 2019, 7:10 AM
gerritbot added a comment.Dec 11 2019, 6:05 AM

Change 556317 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] site.pp: Remove puppet references for db1062

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

gerritbot added a project: Patch-For-Review.Dec 11 2019, 6:05 AM

Change 556318 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/dns@master] wmnet: Remove production DNS for db1062

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

ops-monitoring-bot added a comment.Dec 11 2019, 6:07 AM

cookbooks.sre.hosts.decommission executed by marostegui@cumin1001 for hosts: db1062.eqiad.wmnet

  • db1062.eqiad.wmnet (PASS)
    • Downtimed host on Icinga
    • Downtimed management interface on Icinga
    • Wiped bootloaders
    • Powered off
    • Set Netbox status to Decommissioning
    • Removed from DebMonitor
    • Removed from Puppet master and PuppetDB
gerritbot added a comment.Dec 11 2019, 6:08 AM

Change 556317 merged by Marostegui:
[operations/puppet@production] site.pp: Remove puppet references for db1062

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

gerritbot added a comment.Dec 11 2019, 6:09 AM

Change 556318 merged by Marostegui:
[operations/dns@master] wmnet: Remove production DNS for db1062

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

Maintenance_bot removed a project: Patch-For-Review.Dec 11 2019, 6:10 AM
Marostegui reassigned this task from Marostegui to Jclark-ctr.Dec 11 2019, 6:12 AM
Marostegui edited projects, added decommission-hardware, ops-eqiad, DC-Ops; removed DBA.
Marostegui updated the task description. (Show Details)
Restricted Application added a project: SRE. · View Herald TranscriptDec 11 2019, 6:12 AM
Marostegui moved this task from Backlog to pending onsite steps (eqiad) on the decommission-hardware board.Dec 11 2019, 6:12 AM

Host ready for on-site steps

wiki_willy moved this task from Backlog to Decommission on the ops-eqiad board.Dec 28 2019, 9:06 PM
Jclark-ctr updated the task description. (Show Details)Feb 5 2020, 9:50 PM
RobH unsubscribed.Feb 5 2020, 9:54 PM
Papaul added a comment.Mar 19 2020, 3:24 PM

No interface on any switch showing this server

Papaul updated the task description. (Show Details)Mar 19 2020, 3:25 PM
Papaul added a subscriber: RobH.
Papaul closed this task as Resolved.Mar 20 2020, 3:26 PM
Papaul updated the task description. (Show Details)

complete

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