Page MenuHomePhabricator
Create Task
Maniphest T230107

Decommission db2069.codfw.wmnet
Closed, ResolvedPublic
Actions

Description

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

db2069
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 db2058 and db2069operations/dnsmaster+2 -8
wmnet: Remove db2069 production DNS entriesoperations/dnsmaster+0 -2
site.pp: Remove puppet references for db2069operations/puppetproduction+0 -5
mariadb: Decommission db2069operations/puppetproduction+6 -9
db-eqiad,db-codfw.php: Remove db2069 from configoperations/mediawiki-configmaster+1 -4
Customize query in gerrit

Related Objects
Search...

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

Event Timeline

Marostegui triaged this task as Medium priority.Aug 8 2019, 8:59 AM
Marostegui created this task.
Marostegui moved this task from Triage to In progress on the DBA board.
gerritbot added a comment.Aug 8 2019, 9:01 AM

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

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

gerritbot added a project: Patch-For-Review.Aug 8 2019, 9:01 AM
Marostegui updated the task description. (Show Details)Aug 8 2019, 9:05 AM
gerritbot added a comment.Aug 8 2019, 9:18 AM

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

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

Marostegui updated the task description. (Show Details)Aug 8 2019, 9:19 AM
Stashbot added a comment.Aug 8 2019, 9:19 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-08T09:19:54Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Remove db2069 from config T230107 (duration: 00m 57s)

Stashbot added a comment.Aug 8 2019, 9:21 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-08T09:20:58Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db2069 from config T230107 (duration: 00m 55s)

Maintenance_bot removed a project: Patch-For-Review.Aug 8 2019, 10:10 AM
• Cmjohnson edited projects, added ops-codfw; removed ops-eqiad.Aug 8 2019, 2:04 PM
gerritbot added a comment.Aug 9 2019, 6:04 AM

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

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

gerritbot added a project: Patch-For-Review.Aug 9 2019, 6:04 AM
gerritbot added a comment.Aug 9 2019, 8:16 AM

Change 529201 merged by Marostegui:
[operations/puppet@production] mariadb: Decommission db2069

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

Marostegui updated the task description. (Show Details)Aug 9 2019, 8:29 AM
Stashbot added a comment.Aug 9 2019, 8:29 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-09T08:29:18Z] <marostegui> Remove db2069 from tendril and zarcillo T230107

Stashbot added a comment.Aug 9 2019, 8:32 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-09T08:32:36Z] <marostegui> Stop MySQL on db2069 T230107

Marostegui reassigned this task from Marostegui to RobH.Aug 9 2019, 8:36 AM
Marostegui removed projects: Patch-For-Review, DBA.
Marostegui updated the task description. (Show Details)
Marostegui added a project: DC-Ops.

This host is ready for DC-Ops to decommission

Marostegui renamed this task from Decommission db2069 to Decommission db2069.codfw.wmnet.Aug 13 2019, 5:49 AM
Marostegui mentioned this in T228258: Decommission db2043-db2070.Aug 13 2019, 7:24 AM
Papaul moved this task from Backlog to Decommission on the ops-codfw board.Aug 16 2019, 3:42 PM
Marostegui moved this task from Backlog to Ready for Decommission on the decommission-hardware board.Sep 5 2019, 9:41 AM
gerritbot added a comment.Oct 9 2019, 5:46 AM

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

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

gerritbot added a project: Patch-For-Review.Oct 9 2019, 5:46 AM

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

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

ops-monitoring-bot added a comment.Oct 9 2019, 5:47 AM

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

  • db2069.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 9 2019, 5:47 AM

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

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

gerritbot added a comment.Oct 9 2019, 5:48 AM

Change 541710 merged by Marostegui:
[operations/dns@master] wmnet: Remove db2069 production DNS entries

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

Marostegui reassigned this task from RobH to Papaul.Oct 9 2019, 5:49 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 9 2019, 3:12 PM
papaul@asw-d-codfw# show | compare 
[edit interfaces interface-range vlan-private1-d-codfw]
-    member ge-6/0/17;
[edit interfaces interface-range disabled]
     member ge-6/0/3 { ... }
+    member ge-6/0/17;
[edit interfaces]
-   ge-6/0/17 {
-       description db2069;
-       enable;
-   }
Papaul updated the task description. (Show Details)Oct 9 2019, 3:13 PM
RobH unsubscribed.Oct 9 2019, 8:29 PM
Papaul updated the task description. (Show Details)Oct 10 2019, 3:50 PM
Papaul added a subscriber: RobH.
gerritbot added a comment.Oct 10 2019, 11:11 PM

Change 542252 had a related patch set uploaded (by Papaul; owner: Papaul):
[operations/dns@master] DNS: Remoce mgmt DNS for db2058 and db2069

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

gerritbot added a project: Patch-For-Review.Oct 10 2019, 11:11 PM
gerritbot added a comment.Oct 10 2019, 11:22 PM

Change 542252 merged by Dzahn:
[operations/dns@master] DNS: Remove mgmt DNS for db2058 and db2069

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

Maintenance_bot removed a project: Patch-For-Review.Oct 11 2019, 12:10 AM
Papaul closed this task as Resolved.Oct 11 2019, 1:33 AM
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 · Credits