On 03/23/2015 09:00 PM, Jay Pipes wrote: > On Mon, Mar 23, 2015 at 11:18:28AM +0530, Deepthi Dharwar wrote: >> All the VM information is stored in the instances table. >> This includes all the time related field like scheduled_at, launched_at etc. >> >> After upgrading to Juno, I have noticed that my 'scheduled_at' field >> is not getting reflected at all in the database. I do see my VMs >> being spawned and running just fine. However, the 'launched_at' time >> does get reflected rightly. >> >> >> MariaDB [nova]> select created_at, deleted_at, host,scheduled_at, >> launched_at from instances; >> +---------------------+---------------------+-----------------------+--------------+---------------------+ >> | created_at | deleted_at | host | >> scheduled_at | launched_at | >> +---------------------+---------------------+-----------------------+--------------+---------------------+ >> | 2015-03-09 20:00:41 | 2015-03-10 17:12:11 | localhost | NULL >> | 2015-03-09 20:01:30 | >> | 2015-03-11 05:53:13 | NULL | localhost | >> NULL | 2015-03-18 19:48:12 | >> >> >> Can anyone let me know if this is a genuine issue or have there been >> a recent change in regard to updating this field ? >> >> I am basically trying to find as to how long a particular VM is running on a >> given host. >> I was using the current time - scheduled time for the same. >> Is there a better way to get this value ? > > Use current_time - launched_at.
'launched_at' will give me the time a particular VM came into being. In a scenario where the VM was launched on host H1, later migrated on to a different host H2, 'launched_at' will not give the time the VM has been running on host H2, where as 'scheduled_at' would have addressed this issue or will it ? Regards, Deepthi > > Best, > -jay > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > __________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev