can you compare events for both the vms using select * from usage_event where type like 'VM%' and resource_id in (311, 752); May be a stop event is missing.
the same table is also present in cloud_usage database. compare the events in that table as well. ~Rajani On Wed, Aug 19, 2015 at 4:42 AM, raja sekhar <rajsekhar....@gmail.com> wrote: > Hi Rajani, > > Thanks for your reply. > i have created one testvm and manually destroyed from cloud ui. > the db entry in events table is: > > select * from usage_event where type='VM.DESTROY'\G > *************************** 519. row *************************** > id: 36520 > type: VM.DESTROY > account_id: 62 > created: 2015-07-21 07:53:45 > zone_id: 1 > resource_id: 752 > resource_name: testvm > offering_id: 78 > template_id: 333 > size: NULL > resource_type: XenServer > processed: 1 > virtual_size: NULL > > *i compared these entries to my vm:* > > select * from usage_event where resource_name='appserver'\G > *************************** 18. row *************************** > id: 30714 > type: VM.DESTROY > account_id: 29 > created: 2015-03-17 14:31:24 > zone_id: 1 > resource_id: 311 > resource_name: AppServer > offering_id: 34 > template_id: 257 > size: NULL > resource_type: XenServer > processed: 1 > virtual_size: NULL > > *i found that these two tables are same.* > *below are the few tables of the vm.* > *please suggest me what is the exact table to stop usage records.* > > select * from cloud_usage where vm_name='AppServer'\G > *************************** 1289. row *************************** > id: 679340 > zone_id: 1 > account_id: 29 > domain_id: 12 > description: AppServer running time (ServiceOffering: 34) (Template: > 257) > usage_display: 24 Hrs > usage_type: 1 > raw_usage: 24 > vm_instance_id: 311 > vm_name: AppServer > offering_id: 34 > template_id: 257 > usage_id: 311 > type: XenServer > size: NULL > network_id: NULL > start_date: 2015-08-17 00:00:00 > end_date: 2015-08-17 23:59:59 > virtual_size: NULL > > select * from vm_instance where name='appserver'\G > *************************** 2. row *************************** > id: 311 > name: AppServer > uuid: 0802d513-0bda-43d5-9600-20f705ca1ed7 > instance_name: i-29-311-VM > state: Expunging > vm_template_id: 257 > guest_os_id: 54 > private_mac_address: 02:00:4a:a8:00:04 > private_ip_address: 10.10.10.17 > pod_id: 1 > data_center_id: 1 > host_id: NULL > last_host_id: 14 > proxy_id: 299 > proxy_assign_time: 2013-08-26 21:11:17 > vnc_password: uPk1EIH5AmWi+djshYFcg7BtBXVzYHgQ866UT0/nV28= > ha_enabled: 0 > limit_cpu_use: 0 > update_count: 33 > update_time: 2015-03-17 14:32:35 > created: 2013-08-23 01:28:39 > removed: 2015-08-14 12:57:21 > type: User > vm_type: User > account_id: 29 > domain_id: 12 > service_offering_id: 34 > reservation_id: 99128765-61b1-4e9f-b703-f20715a10a78 > hypervisor_type: XenServer > disk_offering_id: NULL > cpu: NULL > ram: NULL > owner: 29 > speed: 1024 > host_name: AppServer > display_name: AppServer > desired_state: NULL > dynamically_scalable: 0 > display_vm: 1 > > mysql> select * from volumes where instance_id=311\G > *************************** 1. row *************************** > id: 427 > account_id: 29 > domain_id: 12 > pool_id: 208 > last_pool_id: NULL > instance_id: 311 > device_id: 0 > name: ROOT-311 > uuid: c253355e-a33c-4590-9b5e-74f7fa0c32cc > size: 53687091200 > folder: lvm > path: ed119650-671e-4328-9ff2-2aefaac625a9 > pod_id: 1 > data_center_id: 1 > iscsi_name: NULL > host_ip: NULL > volume_type: ROOT > pool_type: LVM > disk_offering_id: 34 > template_id: 257 > first_snapshot_backup_uuid: NULL > recreatable: 0 > created: 2013-08-23 01:28:39 > attached: NULL > updated: 2015-03-17 14:32:35 > removed: 2015-05-03 02:57:00 > state: Destroy > chain_info: NULL > update_count: 1025 > disk_type: NULL > vm_snapshot_chain_size: NULL > iso_id: NULL > display_volume: 1 > format: VHD > min_iops: NULL > max_iops: NULL > > > regards, > rajasekhar. > > On Tue, Aug 18, 2015 at 11:49 AM, Rajani Karuturi <raj...@apache.org> > wrote: > > > update the usage_event table with VM.DESTROY event for this vm. > > I would say create a vm, destroy it and observer the entries in > usage_event > > table. create a similar entry for the manually destroyed vm. > > > > > > ~Rajani > > > > On Tue, Aug 18, 2015 at 12:12 AM, raja sekhar <rajsekhar....@gmail.com> > > wrote: > > > > > Hi All, > > > > > > The usage records are still generating even if the vm is removed from > > > cloudstack. > > > The actual scenario is: > > > The xenserver host went to alert state and the vms in it are not > > > accessible. > > > we have removed the vms from backend by updating vm_instance,volume > > table. > > > can any one help me what is the exact table to update? > > > i am using cloudstack 4.2 > > > > > > waiting for your valuable suggestions. > > > > > > > > > regards, > > > rajasekhar. > > > > > >
