engine=# SELECT status FROM command_entities;
       status
--------------------
 FAILED
 ENDED_SUCCESSFULLY
 FAILED
 FAILED
 UNKNOWN
 UNKNOWN
 ENDED_WITH_FAILURE
 ENDED_WITH_FAILURE
 ENDED_WITH_FAILURE
 ENDED_WITH_FAILURE
 ACTIVE
 ACTIVE
 SUCCEEDED
 SUCCEEDED
 ACTIVE
 ACTIVE
 ACTIVE
 SUCCEEDED
 SUCCEEDED
 SUCCEEDED
 ACTIVE
 SUCCEEDED
(22 rows)

Is it safe to just remove the events in this table?

Thanks

El 2018-06-25 08:43, Ala Hino escribió:

I'd look into command_entites table in the database. 
You will probably see several merge related commands that are not in
END_(SUCCESSFULLY/FAILED) status.

On Mon, Jun 25, 2018 at 10:30 AM, <nicolas@devels.es> wrote:

Hi,

We're running oVirt 4.1.9, recently we had an issue with snapshots
so we had to fix them manually. The issue is mostly solved but now
we're seeing a lot of events like this one:

   2018-06-25 07:58:06,637+01 ERROR

[org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]

(DefaultQuartzScheduler6) [91430fc5-284d-4c26-8d8d-b7bf4053a7e4]
EVENT_ID: USER_REMOVE_SNAPSHOT_FINISHED_FAILURE(357), Correlation
ID: 91430fc5-284d-4c26-8d8d-b7bf4053a7e4, Job ID:
da8120a4-9c6d-4379-ad67-a3808db1fd46, Call Stack: null, Custom ID:
null, Custom Event ID: -1, Message: Failed to delete snapshot
'<UNKNOWN>' for VM 'vmname'.

Which generates the following event in the manager:

   Failed to delete snapshot '<UNKNOWN>' for VM 'vmname'.

This event is being generated every 10 seconds, so it's kind of
annoying.

Any way to remove it manually? It doesn't matter if it entails
touching the DB directly.

Thanks.
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org

Privacy Statement: https://www.ovirt.org/site/privacy-policy/ [1]
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/ [2]
List Archives:

https://lists.ovirt.org/archives/list/users@ovirt.org/message/QYCTXTBGPB25LZYVXGKROG6SSKOCODMQ/

[3]

Links:
------
[1] https://www.ovirt.org/site/privacy-policy/
[2] https://www.ovirt.org/community/about/community-guidelines/
[3]
https://lists.ovirt.org/archives/list/users@ovirt.org/message/QYCTXTBGPB25LZYVXGKROG6SSKOCODMQ/