Mailing-List: contact cloudstack-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-users@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of davestyle@gmail.com designates
 209.85.212.47 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <50CE64F8.6090405@gmail.com>
References: 
 <CACb7MQVdw+4+GBGAAEPTx=uSJfKjynwcgAOd1cFRgrn8ncshhA@mail.gmail.com>
	<50CE64F8.6090405@gmail.com>
Date: Mon, 17 Dec 2012 00:24:57 +0000
Message-ID: 
 <CACb7MQWEb1H4Um+R7AdvA8ptC7rwKgE6mb71qN5ojyuE8nuzhg@mail.gmail.com>
Subject: Re: Damn time travel
From: David Comerford <davestyle@gmail.com>
To: cloudstack-users@incubator.apache.org
Content-Type: multipart/alternative; boundary=bcaec54d4bde38339904d101698f

--bcaec54d4bde38339904d101698f
Content-Type: text/plain; charset=ISO-8859-1

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;

--bcaec54d4bde38339904d101698f--