Page MenuHomePhabricator
Create Task
Maniphest T230884

Decommission db2059.codfw.wmnet
Closed, ResolvedPublic
Actions

Description

This task will track the decommission-hardware of server db2059.codfw.wmnet

The first 5 steps should be completed by the service owner that is returning the server to DC-ops (for reclaim to spare or decommissioning, dependent on server configuration and age.)

db2059

Steps for service owner:

Steps for DC-Ops:

The following steps cannot be interrupted, as it will leave the system in an unfinished state.

Start non-interrupt steps:

  • - Label disk #12 as broken so it doesn't get re-used
  • - disable puppet on host
  • - power down host
  • - update netbox status to Inventory (if decom) or Planned (if spare)
  • - disable switch port
  • - switch port assignment noted on this task (for later removal)
  • - remove all remaining puppet references (include role::spare)
  • - remove production dns entries
  • - puppet node clean, puppet node deactivate (handled by wmf-decommission-host)
  • - remove dbmonitor entries on neodymium/sarin: sudo curl -X DELETE https://debmonitor.discovery.wmnet/hosts/${HOST_FQDN} --cert /etc/debmonitor/ssl/cert.pem --key /etc/debmonitor/ssl/server.key (handled by wmf-decommission-host)

End non-interrupt steps.

  • - system disks wiped (by onsite)
  • - IF DECOM: system unracked and decommissioned (by onsite), update racktables with result
  • - 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 +/-
DNS: Remove mgmt DNS for db2052,db2053.db2059 and db2060operations/dnsmaster+0 -17
instances.yaml: Remove db2059operations/puppetproduction+0 -1
wmnet: Remove production DNS entries for db2059operations/dnsmaster+0 -2
site.pp: Remove references to db2059operations/puppetproduction+0 -5
mariadb: Decommission db2059operations/puppetproduction+6 -8
db-eqiad,db-codfw.php: Remove db2059 from configoperations/mediawiki-configmaster+0 -3
Customize query in gerrit

Related Objects
Search...

StatusSubtypeAssignedTask
 ResolvedNoneT208323 Predictive failures on disk S.M.A.R.T. status
 ResolvedMarosteguiT228258 Decommission db2043-db2070
 ResolvedPapaulT230884 Decommission db2059.codfw.wmnet

Event Timeline

Marostegui triaged this task as Medium priority.Aug 21 2019, 7:53 AM
Marostegui created this task.
Marostegui moved this task from Triage to In progress on the DBA board.
Marostegui mentioned this in T228258: Decommission db2043-db2070.
gerritbot added a comment.Aug 21 2019, 1:01 PM

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

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

gerritbot added a project: Patch-For-Review.Aug 21 2019, 1:01 PM
gerritbot added a comment.Aug 22 2019, 5:05 AM

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

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

Stashbot added a comment.Aug 22 2019, 5:06 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-22T05:06:52Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db2059 from config T230884 (duration: 00m 59s)

Stashbot added a comment.Aug 22 2019, 5:08 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-22T05:08:02Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Remove db2059 from config T230884 (duration: 00m 55s)

Marostegui updated the task description. (Show Details)Aug 22 2019, 5:09 AM
Maintenance_bot removed a project: Patch-For-Review.Aug 22 2019, 5:10 AM
Marostegui updated the task description. (Show Details)Aug 22 2019, 5:13 AM
Stashbot added a comment.Aug 22 2019, 5:14 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-22T05:14:52Z] <marostegui> Remove db2059 from tendril and zarcillo - T230884

gerritbot added a comment.Aug 22 2019, 5:23 AM

Change 531593 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: Decommission db2059

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

gerritbot added a project: Patch-For-Review.Aug 22 2019, 5:23 AM

Change 531593 merged by Marostegui:
[operations/puppet@production] mariadb: Decommission db2059

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

Marostegui reassigned this task from Marostegui to RobH.Aug 22 2019, 5:28 AM
Marostegui edited projects, added decommission-hardware, ops-codfw, DC-Ops; removed Patch-For-Review, DBA.
Marostegui updated the task description. (Show Details)

This host is ready for DC-Ops to decommission

Marostegui mentioned this in T231690: Degraded RAID on db2059.Sep 2 2019, 4:50 AM
Marostegui updated the task description. (Show Details)
Marostegui moved this task from Backlog to Ready for Decommission on the decommission-hardware board.Sep 5 2019, 9:40 AM
Papaul moved this task from Backlog to Decommission on the ops-codfw board.Oct 10 2019, 1:32 AM
gerritbot added a comment.Oct 18 2019, 5:33 AM

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

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

gerritbot added a project: Patch-For-Review.Oct 18 2019, 5:33 AM

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

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

ops-monitoring-bot added a comment.Oct 18 2019, 5:34 AM

cookbooks.sre.hosts.decommission executed by marostegui@cumin1001 for hosts: db2059.codfw.wmnet

  • db2059.codfw.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.Oct 18 2019, 5:35 AM

Change 544101 merged by Marostegui:
[operations/puppet@production] site.pp: Remove references to db2059

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

gerritbot added a comment.Oct 18 2019, 5:36 AM

Change 544102 merged by Marostegui:
[operations/dns@master] wmnet: Remove production DNS entries for db2059

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

Marostegui reassigned this task from RobH to Papaul.Oct 18 2019, 5:36 AM
Marostegui removed a project: Patch-For-Review.
Marostegui updated the task description. (Show Details)
Marostegui moved this task from Ready for Decommission to pending onsite steps (codfw) on the decommission-hardware board.

Host ready for labeling the broken disk, switch disablement and on-site steps

gerritbot added a comment.Oct 18 2019, 1:05 PM

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

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

gerritbot added a project: Patch-For-Review.Oct 18 2019, 1:05 PM

Change 544190 merged by Marostegui:
[operations/puppet@production] instances.yaml: Remove db2059

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

Papaul added a comment.Oct 18 2019, 2:27 PM
papaul@asw-d-codfw# show | compare 
[edit interfaces interface-range vlan-private1-d-codfw]
-    member ge-6/0/7;
[edit interfaces interface-range disabled]
     member ge-6/0/0 { ... }
+    member ge-6/0/7;
[edit interfaces]
-   ge-6/0/7 {
-       description db2059;
-   }
Papaul updated the task description. (Show Details)Oct 18 2019, 2:28 PM
RobH unsubscribed.Oct 18 2019, 5:50 PM
Papaul updated the task description. (Show Details)Oct 31 2019, 3:22 PM
Papaul added a subscriber: RobH.
Papaul updated the task description. (Show Details)Oct 31 2019, 9:35 PM
gerritbot added a comment.Oct 31 2019, 9:46 PM

Change 547663 had a related patch set uploaded (by Papaul; owner: Papaul):
[operations/dns@master] DNS: Remove mgmt DNS for db2052,db2053.db2059 and db2060

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

gerritbot added a comment.Oct 31 2019, 9:49 PM

Change 547663 merged by Papaul:
[operations/dns@master] DNS: Remove mgmt DNS for db2052,db2053.db2059 and db2060

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

Papaul closed this task as Resolved.Oct 31 2019, 9:51 PM
Papaul updated the task description. (Show Details)

complete

DannyS712 removed a project: Patch-For-Review.Nov 18 2019, 11:37 AM
DannyS712 subscribed.

[batch] remove patch for review tag from resolved tasks

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