Page MenuHomePhabricator
Create Task
Maniphest T238526

Decommission db2061.codfw.wmnet
Closed, ResolvedPublic
Actions

Description

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

db2061

Steps for service owner:

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

  • - disable switch port / set to asset tag if host isn't being unracked / remove from switch if being unracked.
  • - system disks wiped (by onsite)
  • - 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

ProjectBranchLines +/-Subject
operations/dnsmaster+0 -9DNS: Remove mgmt DNS for db2048 and db2061
operations/dnsmaster+0 -628DNS: Remove mgnt DNS for db2048 and db2061
operations/dnsmaster+0 -2wmnet: Remove production DNS entries for db2061
operations/puppetproduction+0 -5mariadb: Remove db2061 from puppet
operations/puppetproduction+6 -9mariadb: Set db2061 to spare
operations/mediawiki-configmaster+0 -2db-eqiad,db-codfw.php. Remove db2061 from config
Customize query in gerrit

Related Objects
Search...

Event Timeline

• Marostegui created this task.Nov 18 2019, 10:21 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 18 2019, 10:21 AM
• Marostegui triaged this task as Medium priority.Nov 18 2019, 10:21 AM
• Marostegui moved this task from Triage to Pending comment on the DBA board.
• Marostegui updated the task description. (Show Details)
• Marostegui mentioned this in T228258: Decommission db2043-db2070.Nov 18 2019, 10:23 AM
gerritbot added a comment.Nov 19 2019, 6:35 AM

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

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

gerritbot added a project: Patch-For-Review.Nov 19 2019, 6:35 AM
• Marostegui updated the task description. (Show Details)Nov 19 2019, 6:36 AM
gerritbot added a comment.Nov 19 2019, 6:37 AM

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

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

Stashbot added a comment.Nov 19 2019, 6:38 AM

Mentioned in SAL (#wikimedia-operations) [2019-11-19T06:38:12Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Remove db2061 from config T238526 (duration: 00m 53s)

Stashbot added a comment.Nov 19 2019, 6:39 AM

Mentioned in SAL (#wikimedia-operations) [2019-11-19T06:39:09Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db2061 from config T238526 (duration: 00m 52s)

gerritbot added a comment.Nov 19 2019, 6:41 AM

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

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

gerritbot added a comment.Nov 19 2019, 6:43 AM

Change 551729 merged by Marostegui:
[operations/puppet@production] mariadb: Set db2061 to spare

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

• Marostegui updated the task description. (Show Details)Nov 19 2019, 6:44 AM
Stashbot added a comment.Nov 19 2019, 6:44 AM

Mentioned in SAL (#wikimedia-operations) [2019-11-19T06:44:34Z] <marostegui> Remove db2061 from tendril and zarcillo T238526

Stashbot added a comment.Nov 19 2019, 6:45 AM

Mentioned in SAL (#wikimedia-operations) [2019-11-19T06:45:06Z] <marostegui> Stop MySQL on db2061 T238526

Maintenance_bot removed a project: Patch-For-Review.Nov 19 2019, 7:10 AM
• Marostegui moved this task from Pending comment to In progress on the DBA board.Nov 19 2019, 1:41 PM
ops-monitoring-bot added a comment.Nov 20 2019, 8:02 AM

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

  • db2061.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
• Marostegui updated the task description. (Show Details)Nov 20 2019, 8:05 AM
gerritbot added a comment.Nov 20 2019, 8:06 AM

Change 551968 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: Remove db2061 from puppet

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

gerritbot added a project: Patch-For-Review.Nov 20 2019, 8:06 AM
gerritbot added a comment.Nov 20 2019, 8:08 AM

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

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

gerritbot added a comment.Nov 20 2019, 8:08 AM

Change 551968 merged by Marostegui:
[operations/puppet@production] mariadb: Remove db2061 from puppet

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

gerritbot added a comment.Nov 20 2019, 8:10 AM

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

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

Maintenance_bot removed a project: Patch-For-Review.Nov 20 2019, 8:10 AM
• Marostegui reassigned this task from • Marostegui to Papaul.Nov 20 2019, 8:11 AM
• Marostegui edited projects, added decommission-hardware, ops-codfw; removed DBA.
• Marostegui updated the task description. (Show Details)
Restricted Application added a project: SRE. · View Herald TranscriptNov 20 2019, 8:11 AM
• Marostegui moved this task from Backlog to pending onsite steps (codfw) on the decommission-hardware board.Nov 20 2019, 8:11 AM

Host ready for @Papaul to take over

• Marostegui mentioned this in T208323: Predictive failures on disk S.M.A.R.T. status.Nov 20 2019, 8:19 AM
Papaul added a comment.Nov 20 2019, 3:50 PM
papaul@asw-d-codfw# show | compare 
[edit interfaces interface-range vlan-private1-d-codfw]
-    member ge-6/0/9;
[edit interfaces interface-range disabled]
     member ge-6/0/1 { ... }
+    member ge-6/0/9;
[edit interfaces]
-   ge-6/0/9 {
-       description db2061;
-       enable;
-   }
Papaul updated the task description. (Show Details)Nov 22 2019, 1:58 AM
gerritbot added a comment.Nov 22 2019, 4:25 PM

Change 552539 had a related patch set uploaded (by Papaul; owner: Papaul):
[operations/dns@master] DNS: Remove mgnt DNS for db2048 and db2061

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

gerritbot added a project: Patch-For-Review.Nov 22 2019, 4:25 PM
gerritbot added a comment.Nov 22 2019, 4:36 PM

Change 552539 abandoned by Papaul:
DNS: Remove mgnt DNS for db2048 and db2061

Reason:
Mistakenly removed a lot on DNS entries for others servers in the wmnet file. Have to redo.

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

gerritbot added a comment.Nov 22 2019, 4:47 PM

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

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

gerritbot added a comment.Nov 22 2019, 11:16 PM

Change 552542 merged by Papaul:
[operations/dns@master] DNS: Remove mgmt DNS for db2048 and db2061

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

Papaul closed this task as Resolved.Nov 22 2019, 11:18 PM
Papaul updated the task description. (Show Details)

Complete

Maintenance_bot removed a project: Patch-For-Review.Nov 26 2019, 11:53 AM
Volans reopened this task as Open.Nov 30 2019, 6:29 PM
Volans added a subscriber: Volans.

Netbox status is currently Decommissioning, if the host has been unracked it should be Offline.

Papaul closed this task as Resolved.Nov 30 2019, 6:40 PM
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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