mysql:root@localhost [nova_eqiad1]> update instances set host = 'cloudvirt1058' where uuid = '1c3e4b8a-9076-4c8c-b2e6-51606c0b1fb8';

taavi@cloudcontrol1006 ~ $ sudo OS_PROJECT_ID=tools wmcs-openstack server reboot tools-k8s-haproxy-4 --hard

mysql:root@localhost [nova_eqiad1]> update instances set host = 'cloudvirt1058' where host = 'cloudvirt1051' and deleted = 0;
Query OK, 25 rows affected (0.007 sec)
Rows matched: 25  Changed: 25  Warnings: 0

mysql:root@localhost [neutron]> update ml2_port_bindings set host = 'cloudvirt1058' where host = 'cloudvirt1051';
Query OK, 24 rows affected (0.004 sec)
Rows matched: 24  Changed: 24  Warnings: 0

mysql:root@localhost [neutron]> update ml2_port_binding_levels set host = 'cloudvirt1058' where host = 'cloudvirt1051';
Query OK, 24 rows affected (0.003 sec)
Rows matched: 24  Changed: 24  Warnings: 0

select group_concat(CONCAT("sudo OS_PROJECT_ID=", project_id, " wmcs-openstack server reboot ", hostname, " --hard") SEPARATOR "\n") from instances where host = 'cloudvirt1058' and deleted = 0;

mysql:root@localhost [cinder]> select nova_eqiad1.instances.uuid as instance_uuid,
    ->        volume_attachment.volume_id, volumes.status,
    ->        volume_attachment.attach_status, volume_attachment.mountpoint,
    ->        volumes.display_name from volume_attachment
    ->        inner join nova_eqiad1.instances on volume_attachment.instance_uuid=nova_eqiad1.instances.uuid
    ->        inner join volumes on volumes.id = volume_attachment.volume_id
    ->        where nova_eqiad1.instances.host = 'cloudvirt1058' and volume_attachment.attach_status = 'attached';
+--------------------------------------+--------------------------------------+--------+---------------+------------+--------------------------------------------+
| instance_uuid                        | volume_id                            | status | attach_status | mountpoint | display_name                               |
+--------------------------------------+--------------------------------------+--------+---------------+------------+--------------------------------------------+
| bfad7fbd-53db-4604-aa38-19ffa3e3da02 | 3db99b7f-7a70-4671-af6a-a56fb4810a39 | in-use | attached      | /dev/sdb   | trove-7ac3c20a-cdde-4fec-b87f-3f3a2fd4ff5e |
| b07a92bd-7ec5-412a-ac23-16bd758150d4 | 554b519b-ca92-4fe2-a70c-290137a72a2a | in-use | attached      | /dev/vdb   | ws-export                                  |
| a8c98594-5b5f-46ac-9bb2-438b6d8484c4 | e524ac1c-65a9-443d-aea9-e5cb00900bdf | in-use | attached      | /dev/sdb   | backups                                    |
| e6bd0bc0-c168-48cf-bc25-374ba0c720bb | e58db70d-7c45-441b-bd89-5104c8ea02d8 | in-use | attached      | /dev/sdb   | prometheus-b                               |
+--------------------------------------+--------------------------------------+--------+---------------+------------+--------------------------------------------+
4 rows in set (0.016 sec)

	2023-10-17 15:41:50 	PSU0800 	Power Supply 1: Status = 0x1, IOUT = 0x0, VOUT= 0x0, TEMP= 0x0, FAN = 0x0, INPUT= 0x0.	
--------
		2023-10-17 16:14:23 	SYS1003 	System CPU Resetting.	
	
Log Sequence Number:
227
Detailed Description:
System is performing a CPU reset because of system power off, power on or a warm reset like CTRL-ALT-DEL.
Recommended Action:
No response action is required.
--------
		2023-10-17 16:14:23 	SYS1001 	System is turning off.	
	
Log Sequence Number:
226
Detailed Description:
System is turning off.
Recommended Action:
No response action is required.
-------
		2023-06-29 13:43:25 	SYS336 	An existing hash value is updated because some system configuration items are changed.