Page MenuHomePhabricator
Create Task
Maniphest T230391

Decommission db2050.codfw.wmnet
Closed, ResolvedPublic
Actions

Description

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

db2050
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.

  • - Label disk #3,#4 and #7 as broken so they don't get re-used
  • - system disks wiped (by onsite)
  • - IF DECOM: system unracked and decommissioned (by onsite), update racktables with result
  • - IF DECOM: add system to decommission tracking google sheet
  • - IF DECOM: mgmt dns entries removed.

Details

SubjectRepoBranchLines +/-
DNS: Remove mgmt DNS for sarin,db2050 and db2055operations/dnsmaster+0 -12
wmnet: Remove production DNS entries for db2050operations/dnsmaster+0 -2
site.pp: Remove db2050 from puppetoperations/puppetproduction+0 -5
mariadb: Decommission db2050operations/puppetproduction+6 -9
db-eqiad,db-codfw.php: Remove db2050 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
 ResolvedPapaulT230391 Decommission db2050.codfw.wmnet

Event Timeline

Marostegui triaged this task as Medium priority.Aug 13 2019, 5:27 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 13 2019, 5:29 AM

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

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

gerritbot added a project: Patch-For-Review.Aug 13 2019, 5:29 AM
Marostegui updated the task description. (Show Details)Aug 13 2019, 5:29 AM
gerritbot added a comment.Aug 13 2019, 5:31 AM

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

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

Stashbot added a comment.Aug 13 2019, 5:32 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-13T05:32:51Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db2050 from config T230391 (duration: 00m 48s)

Stashbot added a comment.Aug 13 2019, 5:33 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-13T05:33:44Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Remove db2050 from config T230391 (duration: 00m 48s)

Stashbot added a comment.Aug 13 2019, 5:35 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-13T05:35:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Remove db2050 from config, host will be decommissioned T230391', diff saved to https://phabricator.wikimedia.org/P8904 and previous config saved to /var/cache/conftool/dbconfig/20190813-053514-marostegui.json

gerritbot added a comment.Aug 13 2019, 5:38 AM

Change 529850 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: Decommissioned db2050

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

Marostegui updated the task description. (Show Details)Aug 13 2019, 5:39 AM
Stashbot added a comment.Aug 13 2019, 5:40 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-13T05:40:18Z] <marostegui> Remove db2050 from tendril and zarcillo T230391

gerritbot added a comment.Aug 13 2019, 5:40 AM

Change 529850 merged by Marostegui:
[operations/puppet@production] mariadb: Decommission db2050

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

Stashbot added a comment.Aug 13 2019, 5:47 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-13T05:47:30Z] <marostegui> Stop mysql on db2050 - T230391

Marostegui reassigned this task from Marostegui to RobH.Aug 13 2019, 5:48 AM
Marostegui edited projects, added 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

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
Marostegui mentioned this in T234444: Degraded RAID on db2050.Oct 2 2019, 6:13 PM
Marostegui updated the task description. (Show Details)
ops-monitoring-bot added a comment.Oct 3 2019, 5:46 AM

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

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

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

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

gerritbot added a project: Patch-For-Review.Oct 3 2019, 5:47 AM

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

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

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

Change 540531 merged by Marostegui:
[operations/puppet@production] site.pp: Remove db2050 from puppet

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

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

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

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

Marostegui reassigned this task from RobH to Papaul.Oct 3 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 @Papaul for on-site steps and switch port disablement.

Papaul added a comment.Oct 3 2019, 2:39 PM
papaul@asw-c-codfw# show| compare 
[edit interfaces interface-range vlan-private1-c-codfw]
-    member ge-6/0/19;
[edit interfaces interface-range disabled]
     member ge-6/0/16 { ... }
+    member ge-6/0/19;
[edit interfaces]
-   ge-6/0/19 {
-       description db2050;
-       enable;
-   }
Papaul updated the task description. (Show Details)Oct 3 2019, 2:40 PM
RobH unsubscribed.Oct 3 2019, 3:05 PM
Papaul updated the task description. (Show Details)Oct 7 2019, 3:17 PM
Papaul added a subscriber: RobH.
Papaul updated the task description. (Show Details)Oct 7 2019, 8:02 PM
gerritbot added a comment.Oct 9 2019, 7:58 PM

Change 541907 had a related patch set uploaded (by Papaul; owner: Papaul):
[operations/dns@master] DNS: Remove mgmt DNS for sarin,db2050 and db2055

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

gerritbot added a project: Patch-For-Review.Oct 9 2019, 7:58 PM
gerritbot added a comment.Oct 9 2019, 8:17 PM

Change 541907 merged by Papaul:
[operations/dns@master] DNS: Remove mgmt DNS for sarin,db2050 and db2055

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

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

complete

DannyS712 removed a project: Patch-For-Review.Nov 18 2019, 11:38 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