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, <[email protected]> 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, <[email protected]> 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 -- [email protected] >>> To unsubscribe send an email to [email protected] >>> 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/[email protected]/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/[email protected]/messag >> e/QYCTXTBGPB25LZYVXGKROG6SSKOCODMQ/ >> >
_______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] 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/[email protected]/message/TEOCNI3FLOH3FC2CWVYNBQ6OQ3DE3N6T/
