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(a)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(a)ovirt.org
>> To unsubscribe send an email to users-leave(a)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/QYCTXTBGPB2...
>> [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/QYCTXTBGPB2...