No, you cannot remove the events from this table.
You will have to check ACTIVE commands, and find those that are correlated
with the merge snapshots commands that failed and manually fixed.

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

> 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, <nico...@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-le...@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/messag
>> e/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/messag
>> e/QYCTXTBGPB25LZYVXGKROG6SSKOCODMQ/
>>
>
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/TEOCNI3FLOH3FC2CWVYNBQ6OQ3DE3N6T/

Reply via email to