Page MenuHomePhabricator
Create Task
Maniphest T229784

Decommission db2035
Closed, ResolvedPublic
Actions

Description

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

db2035

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 #1 and #3 as broken so it doesn't get re-used again
  • - 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 db2035 and db2054operations/dnsmaster+1 -9
wmnet: Remove db2035 production entriesoperations/dnsmaster+0 -2
mariadb: Remove db2035operations/puppetproduction+0 -5
mariadb: Decommission db2035operations/puppetproduction+6 -11
db2035: Disable notificationsoperations/puppetproduction+1 -0
db-eqiad,db-codfw.php: Remove db2035 from configoperations/mediawiki-configmaster+1 -4
Customize query in gerrit

Related Objects
Search...

Event Timeline

Marostegui triaged this task as Medium priority.Aug 5 2019, 8:39 AM
Marostegui created this task.
gerritbot added a comment.Aug 5 2019, 8:40 AM

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

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

Marostegui added projects: DC-Ops, ops-codfw.Aug 5 2019, 8:40 AM
gerritbot added a project: Patch-For-Review.Aug 5 2019, 8:40 AM
Marostegui updated the task description. (Show Details)Aug 5 2019, 8:44 AM
gerritbot added a comment.Aug 5 2019, 8:44 AM

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

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

Marostegui moved this task from Triage to In progress on the DBA board.Aug 5 2019, 8:45 AM
Marostegui mentioned this in T221533: Decommission old coredb machines (<=db2042).
Stashbot added a comment.Aug 5 2019, 8:45 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-05T08:45:48Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Remove db2035 from config T229784 (duration: 00m 47s)

Stashbot added a comment.Aug 5 2019, 8:46 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-05T08:46:41Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Remove db2035 from config T229784 (duration: 00m 46s)

Maintenance_bot removed a project: Patch-For-Review.Aug 5 2019, 9:10 AM
gerritbot added a comment.Aug 6 2019, 9:54 AM

Change 528413 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db2035: Disable notifications

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

gerritbot added a project: Patch-For-Review.Aug 6 2019, 9:54 AM

Change 528413 merged by Marostegui:
[operations/puppet@production] db2035: Disable notifications

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

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

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

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

gerritbot added a project: Patch-For-Review.Aug 8 2019, 5:49 AM
gerritbot added a comment.Aug 8 2019, 5:51 AM

Change 528982 merged by Marostegui:
[operations/puppet@production] mariadb: Decommission db2035

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

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

Mentioned in SAL (#wikimedia-operations) [2019-08-08T05:52:55Z] <marostegui> Remove db2035 from tendril and zarcillo T229784

Stashbot added a comment.Aug 8 2019, 5:54 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-08T05:54:43Z] <marostegui> Stop MySQL on db2035 for decommissioning T229784

Marostegui reassigned this task from Marostegui to RobH.Aug 8 2019, 5:56 AM
Marostegui updated the task description. (Show Details)
Marostegui removed projects: Patch-For-Review, DBA.

This host is now 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 mentioned this in T231176: Degraded RAID on db2035.Aug 26 2019, 4:57 AM
Marostegui updated the task description. (Show Details)Aug 26 2019, 5:00 AM
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.Sep 25 2019, 5:11 AM

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

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

gerritbot added a project: Patch-For-Review.Sep 25 2019, 5:11 AM

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

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

ops-monitoring-bot added a comment.Sep 25 2019, 5:11 AM

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

  • db2035.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.Sep 25 2019, 5:15 AM

Change 539014 merged by Marostegui:
[operations/puppet@production] mariadb: Remove db2035

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

gerritbot added a comment.Sep 25 2019, 5:16 AM

Change 539015 merged by Marostegui:
[operations/dns@master] wmnet: Remove db2035 production entries

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

Marostegui reassigned this task from RobH to Papaul.Sep 25 2019, 5:16 AM
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.
Marostegui removed a project: Patch-For-Review.
Marostegui added a subscriber: Papaul.

Host ready for @Papaul after running the decommissioning script

Papaul added a comment.Sep 25 2019, 3:17 PM
papaul@asw-b-codfw# show | compare 
[edit interfaces interface-range vlan-private1-b-codfw]
-    member ge-1/0/4;
[edit interfaces interface-range disabled]
     member ge-3/0/20 { ... }
+    member ge-1/0/4;
[edit interfaces]
-   ge-1/0/4 {
-       description db2035;
-       enable;
-   }
Papaul updated the task description. (Show Details)Sep 25 2019, 3:17 PM
Papaul updated the task description. (Show Details)Oct 3 2019, 2:27 PM
RobH unsubscribed.Oct 3 2019, 3:55 PM
Papaul updated the task description. (Show Details)Oct 3 2019, 10:13 PM
Papaul added a subscriber: RobH.
RobH unsubscribed.Oct 3 2019, 11:15 PM
gerritbot added a comment.Oct 3 2019, 11:54 PM

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

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

gerritbot added a project: Patch-For-Review.Oct 3 2019, 11:54 PM
gerritbot added a comment.Oct 4 2019, 12:08 AM

Change 540728 merged by Papaul:
[operations/dns@master] DNS: Remove mgmt DNS for db2035 and db2054

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

Maintenance_bot removed a project: Patch-For-Review.Oct 4 2019, 12:10 AM
Papaul closed this task as Resolved.Oct 4 2019, 12:11 AM
Papaul updated the task description. (Show Details)
Papaul added a subscriber: RobH.

complete

RobH unsubscribed.Oct 4 2019, 3:15 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