Page MenuHomePhabricator
Create Task
Maniphest T365485

Q4:rack/setup/install dbproxy102[89]
Closed, ResolvedPublic
Actions

Description

This task will track racking of dbproxy102[89]

Hostname / Racking / Installation Details

Hostnames: dbproxy1028, dbproxy1029 (see comments below, we only need to replace dbproxy1020 and dbproxy1021 - dbproxy1018 and dbproxy1019 are no needed anymore)
Racking Proposal: dbproxy1028 anywhere but not in row E. dbproxy1029 anywhere but not in row F.
Networking Setup: # of Connections:1/2 - Speed:1G/10G. - VLAN:Private/Public/Other(Specify) : AAAA records:N, Additional IP records (Cassandra)? Yes/No
Partitioning/Raid: HW Raid: N, Partman recipe and/or desired Raid Level: @Marostegui will take care of this
OS Distro: Bookworm
Sub-team Technical Contact: @Marostegui

Per host setup checklist

Each host should have its own setup checklist copied and pasted into the list below.

dbproxy1028:
  • Receive in system on procurement task 361351 & in Coupa
  • Rack system with proposed racking plan (see above) & update Netbox (include all system info plus location, state of planned)
  • Run the Provision a server's network attributes Netbox script - Note that you must run the DNS and Provision cookbook after completing this step
  • Immediately run the sre.dns.netbox cookbook
  • Immediately run the sre.hosts.provision cookbook
  • Run the sre.hardware.upgrade-firmware cookbook
  • Update the operations/puppet repo - this should include updates to preseed.yaml, and site.pp with roles defined by service group: https://wikitech.wikimedia.org/wiki/SRE/Dc-operations
  • Run the sre.hosts.reimage cookbook
dbproxy1029:
  • Receive in system on procurement task 361351 & in Coupa
  • Rack system with proposed racking plan (see above) & update Netbox (include all system info plus location, state of planned)
  • Run the Provision a server's network attributes Netbox script - Note that you must run the DNS and Provision cookbook after completing this step
  • Immediately run the sre.dns.netbox cookbook
  • Immediately run the sre.hosts.provision cookbook
  • Run the sre.hardware.upgrade-firmware cookbook
  • Update the operations/puppet repo - this should include updates to preseed.yaml, and site.pp with roles defined by service group: https://wikitech.wikimedia.org/wiki/SRE/Dc-operations
  • Run the sre.hosts.reimage cookbook

Related Objects
Search...

StatusSubtypeAssignedTask
Unknown Object (Task)
 ResolvedJclark-ctrT365485 Q4:rack/setup/install dbproxy102[89]
 ResolvedMarosteguiT368874 Productionize dbproxy102[89]
 ResolvedRequestJclark-ctrT383025 decommission dbproxy1020.eqiad.wmnet
 ResolvedRequestJclark-ctrT383033 decommission dbproxy1021.eqiad.wmnet

Event Timeline

RobH created this task.May 21 2024, 2:50 PM
RobH moved this task from Backlog to Racking Tasks on the ops-eqiad board.
RobH mentioned this in Unknown Object (Task).
RobH added a parent task: Unknown Object (Task).
RobH unsubscribed.
Maintenance_bot added a project: SRE.May 21 2024, 3:29 PM
Marostegui updated the task description. (Show Details)May 22 2024, 5:25 AM

Please remember these hosts must not have IPV6 dns records.

ops-monitoring-bot added a comment.Jun 28 2024, 7:46 PM

Cookbook cookbooks.sre.hosts.reimage was started by jclark@cumin1002 for host dbproxy1028.eqiad.wmnet with OS bookworm

ops-monitoring-bot added a comment.Jun 28 2024, 7:46 PM

Cookbook cookbooks.sre.hosts.reimage was started by jclark@cumin1002 for host dbproxy1029.eqiad.wmnet with OS bookworm

Jclark-ctr updated the task description. (Show Details)Jun 28 2024, 7:48 PM
Jclark-ctr claimed this task.Jun 28 2024, 7:51 PM
ops-monitoring-bot added a comment.Jun 28 2024, 8:18 PM

Cookbook cookbooks.sre.hosts.reimage started by jclark@cumin1002 for host dbproxy1029.eqiad.wmnet with OS bookworm completed:

  • dbproxy1029 (PASS)
    • Removed from Puppet and PuppetDB if present and deleted any certificates
    • Removed from Debmonitor if present
    • Forced PXE for next reboot
    • Host rebooted via IPMI
    • Host up (Debian installer)
    • Add puppet_version metadata to Debian installer
    • Checked BIOS boot parameters are back to normal
    • Host up (new fresh bookworm OS)
    • Generated Puppet certificate
    • Signed new Puppet certificate
    • Run Puppet in NOOP mode to populate exported resources in PuppetDB
    • Found Nagios_host resource for this host in PuppetDB
    • Downtimed the new host on Icinga/Alertmanager
    • First Puppet run completed and logged in /var/log/spicerack/sre/hosts/reimage/202406282001_jclark_1655108_dbproxy1029.out
    • configmaster.wikimedia.org updated with the host new SSH public key for wmf-update-known-hosts-production
    • Rebooted
    • Automatic Puppet run was successful
    • Forced a re-check of all Icinga services for the host
    • Icinga status is optimal
    • Icinga downtime removed
    • Updated Netbox data from PuppetDB
    • Updated Netbox status planned -> active
    • The sre.puppet.sync-netbox-hiera cookbook was run successfully
ops-monitoring-bot added a comment.Jun 28 2024, 8:20 PM

Cookbook cookbooks.sre.hosts.reimage started by jclark@cumin1002 for host dbproxy1028.eqiad.wmnet with OS bookworm completed:

  • dbproxy1028 (PASS)
    • Removed from Puppet and PuppetDB if present and deleted any certificates
    • Removed from Debmonitor if present
    • Forced PXE for next reboot
    • Host rebooted via IPMI
    • Host up (Debian installer)
    • Add puppet_version metadata to Debian installer
    • Checked BIOS boot parameters are back to normal
    • Host up (new fresh bookworm OS)
    • Generated Puppet certificate
    • Signed new Puppet certificate
    • Run Puppet in NOOP mode to populate exported resources in PuppetDB
    • Found Nagios_host resource for this host in PuppetDB
    • Downtimed the new host on Icinga/Alertmanager
    • First Puppet run completed and logged in /var/log/spicerack/sre/hosts/reimage/202406282004_jclark_1655060_dbproxy1028.out
    • configmaster.wikimedia.org updated with the host new SSH public key for wmf-update-known-hosts-production
    • Rebooted
    • Automatic Puppet run was successful
    • Forced a re-check of all Icinga services for the host
    • Icinga status is optimal
    • Icinga downtime removed
    • Updated Netbox data from PuppetDB
    • Updated Netbox status planned -> active
    • The sre.puppet.sync-netbox-hiera cookbook was run successfully
Jclark-ctr closed this task as Resolved.Jun 28 2024, 8:20 PM
Jclark-ctr updated the task description. (Show Details)
ops-monitoring-bot added a comment.Jun 29 2024, 12:04 AM

Cookbook cookbooks.sre.hosts.reimage was started by jclark@cumin1002 for host cloudcephosd1040.eqiad.wmnet with OS bullseye

ops-monitoring-bot added a comment.Jun 29 2024, 1:24 AM

Cookbook cookbooks.sre.hosts.reimage started by jclark@cumin1002 for host cloudcephosd1040.eqiad.wmnet with OS bullseye executed with errors:

  • cloudcephosd1040 (FAIL)
    • Removed from Puppet and PuppetDB if present and deleted any certificates
    • Removed from Debmonitor if present
    • Forced PXE for next reboot
    • Host rebooted via IPMI
    • The reimage failed, see the cookbook logs for the details,You can also try typing "install-console" cloudcephosd1040.eqiad.wmnet to get a root shellbut depending on the failure this may not work.
ops-monitoring-bot added a comment.Jul 1 2024, 6:57 PM

Cookbook cookbooks.sre.hosts.reimage was started by jclark@cumin1002 for host cloudcephosd1041.eqiad.wmnet with OS bullseye

ops-monitoring-bot added a comment.Jul 1 2024, 10:47 PM

Cookbook cookbooks.sre.hosts.reimage started by jclark@cumin1002 for host cloudcephosd1041.eqiad.wmnet with OS bullseye completed:

  • cloudcephosd1041 (PASS)
    • Removed from Puppet and PuppetDB if present and deleted any certificates
    • Removed from Debmonitor if present
    • Forced PXE for next reboot
    • Host rebooted via IPMI
    • Host up (Debian installer)
    • Add puppet_version metadata to Debian installer
    • Checked BIOS boot parameters are back to normal
    • Host up (new fresh bullseye OS)
    • Generated Puppet certificate
    • Signed new Puppet certificate
    • Run Puppet in NOOP mode to populate exported resources in PuppetDB
    • Found Nagios_host resource for this host in PuppetDB
    • Downtimed the new host on Icinga/Alertmanager
    • First Puppet run completed and logged in /var/log/spicerack/sre/hosts/reimage/202407011916_jclark_2203544_cloudcephosd1041.out
    • configmaster.wikimedia.org updated with the host new SSH public key for wmf-update-known-hosts-production
    • Rebooted
    • Automatic Puppet run was successful
    • Forced a re-check of all Icinga services for the host
    • Icinga status is optimal
    • Icinga downtime removed
    • Updated Netbox data from PuppetDB
    • Updated Netbox status planned -> active
    • The sre.puppet.sync-netbox-hiera cookbook was run successfully
Marostegui closed subtask T368874: Productionize dbproxy102[89] as Resolved.Jan 7 2025, 12:07 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