On 15 Jul 2019, at 15:11, Mitja Mihelič <mitja.mihelic(a)arnes.si <mailto:mitja.mihelic@arnes.si>> wrote: > Hi! > > We are graphing certain parameters we collect from the engine database. > We use following query to get the count of running VMs: > select count(*),cluster.name <http://cluster.name> as cluster from > vms, cluster where vms.cluster_id = cluster.cluster_id and vms.status > = 1 group by cluster; > > It would help extremely if we knew what the numeric VM status codes mean. https://github.com/oVirt/ovirt-engine/blob/master/backend/manager/modules... > For example, I know that "status = 1" means the VM is running. The > ones we can cause through the web interface are easy enough to figure > out. But there are error states, that cannot be produced by standard use. > > For instance, when the event log says "VM foobar has been paused due > to storage I/O problem." the following states get set in the DB > (Query used: select * from vm_dynamic where vm_guid =(select vm_guid > from vm_static where vm_name = 'foobar';): > status                 | 4 > exit_status            | 0 > pause_status           | 2 > guest_agent_status     | 0 > > What do they mean? > > If you could point me to a table somewhere with the state > descriptions it would be extremely helpful. > > Kind regards, > Mitja Mihelič > _______________________________________________ > Users mailing list -- users(a)ovirt.org <mailto:users@ovirt.org> > To unsubscribe send an email to users-leave(a)ovirt.org > <mailto:users-leave@ovirt.org> > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ > oVirt Code of Conduct: > https://www.ovirt.org/community/about/community-guidelines/ > List Archives: > https://lists.ovirt.org/archives/list/users@ovirt.org/message/ZBNGPWHGYHV...