[openstack-dev] [nova] Updating 'scheduled_at' field of nova instances in the database.
Deepthi Dharwar
deepthi at linux.vnet.ibm.com
Mon Mar 23 05:48:28 UTC 2015
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 ?
Regards,
More information about the OpenStack-dev
mailing list