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]

Reply via email to