Page MenuHomePhabricator
Create Task
Maniphest T230885

Decommission db2066.codfw.wmnet
Closed, ResolvedPublic
Actions

Description

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

db2066

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:

  • - 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 db2066operations/dnsmaster+1 -4
wmnet: Remove production DNS entries for db2066operations/dnsmaster+0 -2
site.pp: Remove puppet references from db2066operations/puppetproduction+0 -5
mariadb: Decommission db2066operations/puppetproduction+5 -10
db-eqiad,db-codfw.php: Remove db2066 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
 ResolvedPapaulT230885 Decommission db2066.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 22 2019, 5:37 AM

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

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

gerritbot added a project: Patch-For-Review.Aug 22 2019, 5:37 AM
Marostegui updated the task description. (Show Details)Aug 22 2019, 5:38 AM
gerritbot added a comment.Aug 22 2019, 5:39 AM

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

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

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

Mentioned in SAL (#wikimedia-operations) [2019-08-22T05:40:23Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db2066 from config T230885 (duration: 00m 54s)

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

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

Maintenance_bot removed a project: Patch-For-Review.Aug 22 2019, 6:10 AM
Marostegui updated the task description. (Show Details)Aug 23 2019, 5:03 AM
gerritbot added a comment.Aug 23 2019, 5:07 AM

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

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

gerritbot added a project: Patch-For-Review.Aug 23 2019, 5:07 AM
Marostegui updated the task description. (Show Details)Aug 23 2019, 5:08 AM
Stashbot added a comment.Aug 23 2019, 5:08 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-23T05:08:51Z] <marostegui> Remove db2066 from tendril and zarcillo T230885

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

Change 531803 merged by Marostegui:
[operations/puppet@production] mariadb: Decommission db2066

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

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

Mentioned in SAL (#wikimedia-operations) [2019-08-23T05:11:21Z] <marostegui> Stop MySQL on db2066 for decommission T230885

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

This host is ready for DC-Ops to decommission

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:31 AM
gerritbot added a comment.Oct 16 2019, 5:26 AM

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

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

gerritbot added a project: Patch-For-Review.Oct 16 2019, 5:26 AM

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

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

ops-monitoring-bot added a comment.Oct 16 2019, 5:26 AM

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

  • db2066.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 16 2019, 5:27 AM

Change 543269 merged by Marostegui:
[operations/puppet@production] site.pp: Remove puppet references from db2066

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

gerritbot added a comment.Oct 16 2019, 5:28 AM

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

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

Marostegui reassigned this task from RobH to Papaul.Oct 16 2019, 5:28 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 on-site steps + switch disablement

Papaul added a comment.Oct 16 2019, 2:37 PM
papaul@asw-d-codfw# show | compare 
[edit interfaces interface-range vlan-private1-d-codfw]
-    member ge-6/0/14;
[edit interfaces interface-range disabled]
     member ge-6/0/16 { ... }
+    member ge-6/0/14;
[edit interfaces]
-   ge-6/0/14 {
-       description db2066;
-       enable;
-   }
Papaul updated the task description. (Show Details)Oct 16 2019, 2:38 PM
Papaul updated the task description. (Show Details)Oct 18 2019, 2:58 PM
gerritbot added a comment.Oct 28 2019, 2:19 PM

Change 546503 had a related patch set uploaded (by Papaul; owner: Papaul):
[operations/dns@master] DNS: Remove mgmt DNS for db2066

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

gerritbot added a project: Patch-For-Review.Oct 28 2019, 2:19 PM

Change 546503 merged by Papaul:
[operations/dns@master] DNS: Remove mgmt DNS for db2066

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

Papaul closed this task as Resolved.Oct 28 2019, 2:20 PM
Papaul updated the task description. (Show Details)

Complete

Maintenance_bot removed a project: Patch-For-Review.Oct 28 2019, 3:11 PM
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