cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Comerford <davest...@gmail.com>
Subject Re: Damn time travel
Date Mon, 17 Dec 2012 00:24:57 GMT
Hey Kirk,

In answer to your question...

mysql> select * from vm_instance where id = 620 \G;
*************************** 1. row ***************************
                 id: 620
               name: a1a470ef-368b-45fe-99c7-1b92eabd3d78
               uuid: a1a470ef-368b-45fe-99c7-1b92eabd3d78
      instance_name: i-75-620-VM
              state: Expunging
     vm_template_id: 329
        guest_os_id: 54
private_mac_address: 02:00:36:f4:00:0a
 private_ip_address: 10.10.4.252
             pod_id: 1
     data_center_id: 1
            host_id: NULL
       last_host_id: 3
           proxy_id: NULL
  proxy_assign_time: NULL
       vnc_password: kDMRgyJht3Lvx1UKDUv9MIxPkmRt1GyZusCvl8DbnRw=
         ha_enabled: 1
      limit_cpu_use: 0
       update_count: 25263
        update_time: 2012-12-17 00:20:04
            created: 2012-12-04 14:46:54
            removed: NULL
               type: User
            vm_type: User
         account_id: 75
          domain_id: 53
service_offering_id: 31
     reservation_id: NULL
    hypervisor_type: XenServer
1 row in set (0.00 sec)


mysql> select * from volumes where instance_id = 620 \G;
*************************** 1. row ***************************
                        id: 654
                account_id: 75
                 domain_id: 53
                   pool_id: 203
              last_pool_id: NULL
               instance_id: 620
                 device_id: 0
                      name: ROOT-620
                      uuid: 562b17fe-3d17-48e4-8690-1169dc137862
                      size: 64424509440
                    folder: /vol/primary4
                      path: ec060ab6-fdf6-4696-b8b3-75723a289c42
                    pod_id: 1
            data_center_id: 1
                iscsi_name: NULL
                   host_ip: NULL
               volume_type: ROOT
                 pool_type: NetworkFilesystem
          disk_offering_id: 31
               template_id: 329
first_snapshot_backup_uuid: NULL
               recreatable: 0
                   created: 2012-12-04 14:46:54
                  attached: NULL
                   updated: 2012-12-04 14:51:52
                   removed: NULL
                     state: Ready
                chain_info: NULL
              update_count: 3
1 row in set (0.00 sec)


On 17 December 2012 00:19, Kirk Kosinski <kirkkosinski@gmail.com> wrote:

> select * from vm_instance where id = 620;

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message