MilanHofmann commented on issue #7171:
URL: https://github.com/apache/cloudstack/issues/7171#issuecomment-1420964928
@slavkap
`mysql> select * from cluster\G;`
*************************** 1. row ***************************
id: 1
name: contabo_test_cluster
uuid: fc690d48-5e28-446d-bce5-71816590758f
guid: c4ca4238-a0b9-3382-8dcc-509a6f75849b
pod_id: 1
data_center_id: 1
hypervisor_type: KVM
cluster_type: CloudManaged
allocation_state: Enabled
managed_state: Managed
removed: NULL
owner: NULL
created: NULL
lastUpdated: NULL
engine_state: Disabled
`select * from host\G;`
*************************** 1. row ***************************
id: 1
name: m0995.contaboserver.net
uuid: 153a3067-1f83-4367-b49e-36e6b8af4b68
status: Removed
type: Routing
private_ip_address: 79.143.179.221
private_netmask: 255.255.255.0
private_mac_address: 1c:6f:65:91:9e:86
storage_ip_address: 79.143.179.221
storage_netmask: 255.255.255.0
storage_mac_address: 1c:6f:65:91:9e:86
storage_ip_address_2: NULL
storage_mac_address_2: NULL
storage_netmask_2: NULL
cluster_id: NULL
public_ip_address: 79.143.179.221
public_netmask: 255.255.255.0
public_mac_address: 1c:6f:65:91:9e:86
proxy_port: NULL
data_center_id: 1
pod_id: 1
cpu_sockets: 1
cpus: 12
speed: 3200
url: NULL
fs_type: NULL
hypervisor_type: KVM
hypervisor_version: NULL
ram: 24133316608
resource: NULL
version: 4.17.2.0
parent: NULL
total_size: NULL
capabilities: hvm,snapshot
guid: NULL
available: 1
setup: 0
dom0_memory: 0
last_ping: 1636346792
mgmt_server_id: NULL
disconnected: NULL
created: 2023-02-05 17:45:15
removed: 2023-02-05 17:51:21
update_count: 4
resource_state: Disabled
owner: NULL
lastUpdated: NULL
engine_state: Disabled
*************************** 2. row ***************************
id: 2
name: m0995.contaboserver.net
uuid: c9d3ffb7-46bc-4361-8343-98bf76652239
status: Removed
type: Routing
private_ip_address: 79.143.179.221
private_netmask: 255.255.255.0
private_mac_address: 1c:6f:65:91:9e:86
storage_ip_address: 79.143.179.221
storage_netmask: 255.255.255.0
storage_mac_address: 1c:6f:65:91:9e:86
storage_ip_address_2: NULL
storage_mac_address_2: NULL
storage_netmask_2: NULL
cluster_id: NULL
public_ip_address: 79.143.179.221
public_netmask: 255.255.255.0
public_mac_address: 1c:6f:65:91:9e:86
proxy_port: NULL
data_center_id: 1
pod_id: 1
cpu_sockets: 1
cpus: 12
speed: 3200
url: NULL
fs_type: NULL
hypervisor_type: KVM
hypervisor_version: NULL
ram: 24133316608
resource: NULL
version: 4.17.2.0
parent: NULL
total_size: NULL
capabilities: hvm,snapshot
guid: NULL
available: 1
setup: 0
dom0_memory: 0
last_ping: 1636347592
mgmt_server_id: NULL
disconnected: NULL
created: 2023-02-05 17:58:20
removed: 2023-02-05 18:02:33
update_count: 7
resource_state: Disabled
owner: NULL
lastUpdated: NULL
engine_state: Disabled
*************************** 3. row ***************************
id: 3
name: m0995.contaboserver.net
uuid: 9410b8b2-8a62-4a4a-9ece-8a5d765a2d42
status: Removed
type: Routing
private_ip_address: 79.143.179.221
private_netmask: 255.255.255.0
private_mac_address: 1c:6f:65:91:9e:86
storage_ip_address: 79.143.179.221
storage_netmask: 255.255.255.0
storage_mac_address: 1c:6f:65:91:9e:86
storage_ip_address_2: NULL
storage_mac_address_2: NULL
storage_netmask_2: NULL
cluster_id: NULL
public_ip_address: 79.143.179.221
public_netmask: 255.255.255.0
public_mac_address: 1c:6f:65:91:9e:86
proxy_port: NULL
data_center_id: 1
pod_id: 1
cpu_sockets: 1
cpus: 12
speed: 3200
url: NULL
fs_type: NULL
hypervisor_type: KVM
hypervisor_version: NULL
ram: 24133316608
resource: NULL
version: 4.17.2.0
parent: NULL
total_size: NULL
capabilities: hvm,snapshot
guid: NULL
available: 1
setup: 0
dom0_memory: 0
last_ping: 1636347849
mgmt_server_id: NULL
disconnected: NULL
created: 2023-02-05 18:03:18
removed: 2023-02-05 18:16:41
update_count: 4
resource_state: Disabled
owner: NULL
lastUpdated: NULL
engine_state: Disabled
*************************** 4. row ***************************
id: 4
name: m0995.contaboserver.net
uuid: ee605607-3ec7-46a1-8298-e5d2e4e7807e
status: Removed
type: Routing
private_ip_address: 79.143.179.221
private_netmask: 255.255.255.0
private_mac_address: 1c:6f:65:91:9e:86
storage_ip_address: 79.143.179.221
storage_netmask: 255.255.255.0
storage_mac_address: 1c:6f:65:91:9e:86
storage_ip_address_2: NULL
storage_mac_address_2: NULL
storage_netmask_2: NULL
cluster_id: NULL
public_ip_address: 79.143.179.221
public_netmask: 255.255.255.0
public_mac_address: 1c:6f:65:91:9e:86
proxy_port: NULL
data_center_id: 1
pod_id: 1
cpu_sockets: 1
cpus: 12
speed: 3200
url: NULL
fs_type: NULL
hypervisor_type: KVM
hypervisor_version: NULL
ram: 24133316608
resource: NULL
version: 4.17.2.0
parent: NULL
total_size: NULL
capabilities: hvm,snapshot
guid: NULL
available: 1
setup: 0
dom0_memory: 0
last_ping: 1636348692
mgmt_server_id: NULL
disconnected: NULL
created: 2023-02-05 18:17:41
removed: 2023-02-05 18:21:34
update_count: 4
resource_state: Disabled
owner: NULL
lastUpdated: NULL
engine_state: Disabled
*************************** 5. row ***************************
id: 5
name: m0995.contaboserver.net
uuid: b8b9ca48-878f-4d8b-bcd9-ebe126173806
status: Removed
type: Routing
private_ip_address: 79.143.179.221
private_netmask: 255.255.255.0
private_mac_address: 1c:6f:65:91:9e:86
storage_ip_address: 79.143.179.221
storage_netmask: 255.255.255.0
storage_mac_address: 1c:6f:65:91:9e:86
storage_ip_address_2: NULL
storage_mac_address_2: NULL
storage_netmask_2: NULL
cluster_id: NULL
public_ip_address: 79.143.179.221
public_netmask: 255.255.255.0
public_mac_address: 1c:6f:65:91:9e:86
proxy_port: NULL
data_center_id: 1
pod_id: 1
cpu_sockets: 1
cpus: 12
speed: 3200
url: NULL
fs_type: NULL
hypervisor_type: KVM
hypervisor_version: NULL
ram: 24133316608
resource: NULL
version: 4.17.2.0
parent: NULL
total_size: NULL
capabilities: hvm,snapshot
guid: NULL
available: 1
setup: 0
dom0_memory: 0
last_ping: 1636348988
mgmt_server_id: NULL
disconnected: NULL
created: 2023-02-05 18:22:44
removed: 2023-02-05 19:28:47
update_count: 4
resource_state: Disabled
owner: NULL
lastUpdated: NULL
engine_state: Disabled
*************************** 6. row ***************************
id: 6
name: m0995.contaboserver.net
uuid: 17de026e-9aeb-4c02-a8eb-162995206f89
status: Removed
type: Routing
private_ip_address: 79.143.179.221
private_netmask: 255.255.255.0
private_mac_address: 1c:6f:65:91:9e:86
storage_ip_address: 79.143.179.221
storage_netmask: 255.255.255.0
storage_mac_address: 1c:6f:65:91:9e:86
storage_ip_address_2: NULL
storage_mac_address_2: NULL
storage_netmask_2: NULL
cluster_id: NULL
public_ip_address: 79.143.179.221
public_netmask: 255.255.255.0
public_mac_address: 1c:6f:65:91:9e:86
proxy_port: NULL
data_center_id: 1
pod_id: 1
cpu_sockets: 1
cpus: 12
speed: 3200
url: NULL
fs_type: NULL
hypervisor_type: KVM
hypervisor_version: NULL
ram: 24133316608
resource: NULL
version: 4.17.2.0
parent: NULL
total_size: NULL
capabilities: hvm,snapshot
guid: NULL
available: 1
setup: 0
dom0_memory: 0
last_ping: 1636423998
mgmt_server_id: NULL
disconnected: NULL
created: 2023-02-05 19:29:37
removed: 2023-02-06 18:31:51
update_count: 7
resource_state: Disabled
owner: NULL
lastUpdated: NULL
engine_state: Disabled
*************************** 7. row ***************************
id: 7
name: m0995.contaboserver.net
uuid: b9cc9299-b2ff-4494-ad47-ebd221dfe102
status: Up
type: Routing
private_ip_address: 79.143.179.221
private_netmask: 255.255.255.0
private_mac_address: 1c:6f:65:91:9e:86
storage_ip_address: 79.143.179.221
storage_netmask: 255.255.255.0
storage_mac_address: 1c:6f:65:91:9e:86
storage_ip_address_2: NULL
storage_mac_address_2: NULL
storage_netmask_2: NULL
cluster_id: 1
public_ip_address: 79.143.179.221
public_netmask: 255.255.255.0
public_mac_address: 1c:6f:65:91:9e:86
proxy_port: NULL
data_center_id: 1
pod_id: 1
cpu_sockets: 1
cpus: 12
speed: 3200
url: NULL
fs_type: NULL
hypervisor_type: KVM
hypervisor_version: NULL
ram: 24133316608
resource: NULL
version: 4.17.2.0
parent: NULL
total_size: NULL
capabilities: hvm,snapshot
guid:
67284449-f954-3204-afdc-1057f885b1a2-LibvirtComputingResource
available: 1
setup: 0
dom0_memory: 0
last_ping: 1636496471
mgmt_server_id: 2934858251578
disconnected: NULL
created: 2023-02-06 18:33:23
removed: NULL
update_count: 7
resource_state: Enabled
owner: NULL
lastUpdated: NULL
engine_state: Disabled
--
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]