spazicus commented on issue #5300:
URL: https://github.com/apache/cloudstack/issues/5300#issuecomment-900409499
Hi, we are using mysql
Here is the output as requested:
`mysql> use cloud;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT * FROM cloud.host_view WHERE type='Routing'\G;
*************************** 1. row ***************************
id: 1
uuid: beaca323-0da1-49a7-88af-f2490c04bc21
name: macccg03
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.23
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590095465
created: 2021-04-11 14:45:16
removed: NULL
resource_state: Maintenance
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 40
speed: 2762
ram: 269008936960
cluster_id: 1
cluster_uuid: ca19dfd1-54de-42d0-9da6-5cf3969a1a1b
cluster_name: C1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: null
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 2. row ***************************
id: 4
uuid: eed3613e-cb20-4826-9baf-d299bd661505
name: maccdn01
status: Alert
disconnected: NULL
type: Routing
private_ip_address: 10.250.0.31
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1588926705
created: 2021-04-14 15:02:59
removed: NULL
resource_state: Enabled
mgmt_server_id: NULL
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710974464
cluster_id: 1
cluster_uuid: ca19dfd1-54de-42d0-9da6-5cf3969a1a1b
cluster_name: C1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 3. row ***************************
id: 5
uuid: 0b5465d8-ae89-404c-a793-e2096ababfe7
name: macccg05
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.25
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590687492
created: 2021-04-14 17:45:15
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 40
speed: 3200
ram: 268807782400
cluster_id: 1
cluster_uuid: ca19dfd1-54de-42d0-9da6-5cf3969a1a1b
cluster_name: C1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 4. row ***************************
id: 6
uuid: 98d1015b-f2d2-4cf4-a306-3f6d8c05075f
name: maccdn02
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.32
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590687129
created: 2021-04-20 18:04:55
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710970368
cluster_id: 1
cluster_uuid: ca19dfd1-54de-42d0-9da6-5cf3969a1a1b
cluster_name: C1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 536870912
memory_reserved_capacity: 0
cpu_used_capacity: 500
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 5. row ***************************
id: 7
uuid: 9c64600c-bc1e-4f63-9b9e-10c807d138a3
name: macccg02
status: Removed
disconnected: NULL
type: Routing
private_ip_address: 10.250.0.22
version: 4.15.0.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1581673910
created: 2021-04-27 17:03:30
removed: 2021-04-28 18:27:45
resource_state: Disabled
mgmt_server_id: NULL
cpu_sockets: 2
cpus: 40
speed: 1000
ram: 269008941056
cluster_id: NULL
cluster_uuid: NULL
cluster_name: NULL
cluster_type: NULL
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: NULL
memory_reserved_capacity: NULL
cpu_used_capacity: NULL
cpu_reserved_capacity: NULL
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 6. row ***************************
id: 8
uuid: 105df7bb-6fcc-46cf-a8b5-20e58ed449e7
name: macccg02
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.22
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590686664
created: 2021-04-28 18:28:49
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 40
speed: 3200
ram: 269008936960
cluster_id: 1
cluster_uuid: ca19dfd1-54de-42d0-9da6-5cf3969a1a1b
cluster_name: C1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 35433480192
memory_reserved_capacity: 0
cpu_used_capacity: 71700
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 7. row ***************************
id: 9
uuid: c2658fcf-47ab-434c-8ae9-625aae1d39e2
name: maccdn05
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.35
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590686302
created: 2021-05-17 17:01:54
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710970368
cluster_id: 1
cluster_uuid: ca19dfd1-54de-42d0-9da6-5cf3969a1a1b
cluster_name: C1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 536870912
memory_reserved_capacity: 0
cpu_used_capacity: 1000
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 8. row ***************************
id: 10
uuid: 3b750f24-4d7b-4359-93e0-b9b444476cdc
name: maccdn04
status: Alert
disconnected: NULL
type: Routing
private_ip_address: 10.250.0.34
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities:
last_ping: 1588926552
created: 2021-05-17 20:24:57
removed: NULL
resource_state: Enabled
mgmt_server_id: NULL
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710974464
cluster_id: 1
cluster_uuid: ca19dfd1-54de-42d0-9da6-5cf3969a1a1b
cluster_name: C1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 9. row ***************************
id: 11
uuid: 1654197b-ec6c-4e90-99be-343cdcf90381
name: maccdn20
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.60
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590685721
created: 2021-06-10 19:38:38
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710970368
cluster_id: 3
cluster_uuid: 2c04bcfe-ca2b-420d-a2f3-c5ffa915aa5b
cluster_name: C2
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 10. row ***************************
id: 12
uuid: 4f2d0b03-0144-4591-923e-2c29bb93038e
name: maccdn17
status: Alert
disconnected: NULL
type: Routing
private_ip_address: 10.250.0.57
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities:
last_ping: 1588922331
created: 2021-06-18 18:31:27
removed: NULL
resource_state: Enabled
mgmt_server_id: NULL
cpu_sockets: 0
cpus: 0
speed: 0
ram: 98710974464
cluster_id: 3
cluster_uuid: 2c04bcfe-ca2b-420d-a2f3-c5ffa915aa5b
cluster_name: C2
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 536870912
memory_reserved_capacity: 0
cpu_used_capacity: 1000
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 11. row ***************************
id: 13
uuid: cba00b7b-49f0-4c27-8be4-7effe27b4384
name: maccdn16
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.56
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590685156
created: 2021-06-19 08:19:45
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710970368
cluster_id: 3
cluster_uuid: 2c04bcfe-ca2b-420d-a2f3-c5ffa915aa5b
cluster_name: C2
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 268435456
memory_reserved_capacity: 0
cpu_used_capacity: 500
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 12. row ***************************
id: 14
uuid: bd2a88c4-1657-4d1d-a2ff-32236100ff41
name: maccdn15
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.55
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590684642
created: 2021-06-19 09:34:56
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710970368
cluster_id: 3
cluster_uuid: 2c04bcfe-ca2b-420d-a2f3-c5ffa915aa5b
cluster_name: C2
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 536870912
memory_reserved_capacity: 0
cpu_used_capacity: 1000
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 13. row ***************************
id: 15
uuid: caf59683-6cb4-46c3-93ff-0442d9030e33
name: maccdn14
status: Alert
disconnected: NULL
type: Routing
private_ip_address: 10.250.0.54
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities:
last_ping: 1588926494
created: 2021-06-19 11:15:58
removed: NULL
resource_state: Enabled
mgmt_server_id: NULL
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710974464
cluster_id: 3
cluster_uuid: 2c04bcfe-ca2b-420d-a2f3-c5ffa915aa5b
cluster_name: C2
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 14. row ***************************
id: 16
uuid: 04b18096-f8e3-4871-97a5-3ae1803d600c
name: maccdn13
status: Down
disconnected: NULL
type: Routing
private_ip_address: 10.250.0.53
version: 4.15.0.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1586041678
created: 2021-06-19 12:07:25
removed: NULL
resource_state: Enabled
mgmt_server_id: NULL
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710978560
cluster_id: 3
cluster_uuid: 2c04bcfe-ca2b-420d-a2f3-c5ffa915aa5b
cluster_name: C2
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 15. row ***************************
id: 17
uuid: 121579de-fa94-4484-90fe-af25f50c1b5b
name: maccdn12
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.52
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590679840
created: 2021-06-19 12:26:06
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710970368
cluster_id: 3
cluster_uuid: 2c04bcfe-ca2b-420d-a2f3-c5ffa915aa5b
cluster_name: C2
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 9663676416
memory_reserved_capacity: 0
cpu_used_capacity: 10000
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 16. row ***************************
id: 18
uuid: 8d56b8f1-27c0-4c68-9969-74b83e1d60b4
name: maccdn11
status: Alert
disconnected: NULL
type: Routing
private_ip_address: 10.250.0.51
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1588926660
created: 2021-06-19 12:53:52
removed: NULL
resource_state: Enabled
mgmt_server_id: NULL
cpu_sockets: 2
cpus: 48
speed: 3200
ram: 98710974464
cluster_id: 3
cluster_uuid: 2c04bcfe-ca2b-420d-a2f3-c5ffa915aa5b
cluster_name: C2
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 17. row ***************************
id: 19
uuid: 511262e0-46ce-434b-808c-8d208d3aa980
name: maccbg05
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.15
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590672269
created: 2021-07-01 09:04:37
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 40
speed: 3200
ram: 269008936960
cluster_id: 4
cluster_uuid: 0ba19aa0-31bd-4b22-8139-533240ede8d3
cluster_name: C3
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 18. row ***************************
id: 20
uuid: b3480c6b-8f92-44be-86ab-1f7bbc97b1be
name: maccbg04
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.14
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590671640
created: 2021-07-01 09:35:05
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 40
speed: 3200
ram: 269008936960
cluster_id: 4
cluster_uuid: 0ba19aa0-31bd-4b22-8139-533240ede8d3
cluster_name: C3
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 0
memory_reserved_capacity: 0
cpu_used_capacity: 0
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 19. row ***************************
id: 21
uuid: 116b4ab1-9f2b-4026-a7d3-af5dd0ec2ca1
name: maccbg03
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.13
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590670857
created: 2021-07-16 11:52:25
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 40
speed: 3200
ram: 269008936960
cluster_id: 4
cluster_uuid: 0ba19aa0-31bd-4b22-8139-533240ede8d3
cluster_name: C3
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 17716740096
memory_reserved_capacity: 0
cpu_used_capacity: 37800
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 20. row ***************************
id: 22
uuid: ad7c5996-ef47-4be1-bd89-436b89ee00fa
name: maccbg02
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.12
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590670349
created: 2021-07-16 12:24:06
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 40
speed: 3200
ram: 269008936960
cluster_id: 4
cluster_uuid: 0ba19aa0-31bd-4b22-8139-533240ede8d3
cluster_name: C3
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 805306368
memory_reserved_capacity: 0
cpu_used_capacity: 1500
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
*************************** 21. row ***************************
id: 23
uuid: 890947d8-32b2-429c-8d51-804018da0336
name: maccbg01
status: Up
disconnected: 2021-08-06 13:03:59
type: Routing
private_ip_address: 10.250.0.11
version: 4.15.1.0
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1590669987
created: 2021-07-19 14:46:47
removed: NULL
resource_state: Enabled
mgmt_server_id: 103907758103500
cpu_sockets: 2
cpus: 40
speed: 3200
ram: 269076434944
cluster_id: 4
cluster_uuid: 0ba19aa0-31bd-4b22-8139-533240ede8d3
cluster_name: C3
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: e9f33556-5acc-451c-a20a-363cb4428213
data_center_name: mycloud
data_center_type: Advanced
pod_id: 1
pod_uuid: 4055df41-081a-406d-b021-e04e804d70f1
pod_name: P1
tag: NULL
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 34359738368
memory_reserved_capacity: 0
cpu_used_capacity: 55200
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
21 rows in set (0.00 sec)
ERROR:
No query specified
mysql>
`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
