HI, OK, how to properly remove this lock? Right now VM is locked and is unmanageable at all in any way. I suppose its with some SQL commands in Postgres.
Thanks. > On 5 Aug 2022, at 11:34, Benny Zlotnik <[email protected]> wrote: > > So based on your logs the lock you are seeing is a memory lock, > unlock_entity.sh can't really help with these. > Also, the job table is used mainly for presentation so removing an > entry from will not help. > > Do you have the logs from when this snapshot operation started, you > can use the correlation id (28353fa0-5e36-4fe8-8609-e74cd1da6d36) to > search? Also, do you have the vdsm logs (SPM at the time and the host > running the VM), same correlation id can be used for this as well > > The table that's used to coordinate this is command_entities, so in > theory removing the entries with this correlation id can help, but I'd > like to see what led to this first > > On Fri, Aug 5, 2022 at 8:37 AM Andrei Verovski <[email protected]> wrote: >> >> Hi, Benny, >> >> I have sent log on your mailbox, its too big to post here on mailing list. >> >> Looks like ghost task is still running, anything else need to be removed >> from Postgres DB? >> >> BTW, frozen dead snapshot is in invalid state, is there any way to get rid >> of it? I think it's actually exists, but due to invalid state its not >> possible to do anything with it. >> >> >> —— >> >> Log file still shows zombie task: >> >> 2022-08-04 20:57:30,145+03 INFO >> [org.ovirt.engine.core.bll.SerialChildCommandsExecutionCallback] >> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-24) >> [28353fa0-5e36-4fe8-8609-e74cd1da6d36] Command 'CreateSnapshotForVm' (id: >> '2f8b32d8-fd3c-46c9-90e9-4863d63c0530') waiting on child command id: >> 'ed816f9d-e25c-4b58-8c8f-fd0393abda2f' type:'CreateLiveSnapshotForVm' to >> complete >> 2022-08-04 20:57:40,176+03 INFO >> [org.ovirt.engine.core.bll.SerialChildCommandsExecutionCallback] >> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-85) >> [28353fa0-5e36-4fe8-8609-e74cd1da6d36] Command 'CreateSnapshotForVm' (id: >> '2f8b32d8-fd3c-46c9-90e9-4863d63c0530') waiting on child command id: >> 'ed816f9d-e25c-4b58-8c8f-fd0393abda2f' type:'CreateLiveSnapshotForVm' to >> complete >> 2022-08-04 20:57:50,252+03 INFO >> [org.ovirt.engine.core.bll.SerialChildCommandsExecutionCallback] >> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-66) >> [28353fa0-5e36-4fe8-8609-e74cd1da6d36] Command 'CreateSnapshotForVm' (id: >> '2f8b32d8-fd3c-46c9-90e9-4863d63c0530') waiting on child command id: >> 'ed816f9d-e25c-4b58-8c8f-fd0393abda2f' type:'CreateLiveSnapshotForVm' to >> complete >> >> >>> On 4 Aug 2022, at 19:06, Benny Zlotnik <[email protected]> wrote: >>> >>> can you share the logs after restarting ovirt-engine? >>> >>> On Thu, Aug 4, 2022 at 4:58 PM Andrei Verovski <[email protected]> wrote: >>>> >>>> Hi, >>>> >>>> >>>> Creating snapshot of one of the VM vailed, and zombie tasks was killed >>>> with: >>>> >>>> su postgres >>>> psql -d engine -U postgres >>>> select * from job order by start_time desc; >>>> >>>> select DeleteJob('UUID_FROZEN_TASK_ID’); >>>> >>>> >>>> However, VM remains in locked state (with lock sign left-below red “DOWN” >>>> arrow in status column of web interface. >>>> >>>> I run: >>>> /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t all >>>> >>>> then rebooted engine VM, still no luck. Can’t do anything with that VM. >>>> >>>> Please advise how to fix. >>>> Thanks in advance. >>>> _______________________________________________ >>>> Users mailing list -- [email protected] >>>> To unsubscribe send an email to [email protected] >>>> Privacy Statement: https://www.ovirt.org/privacy-policy.html >>>> oVirt Code of Conduct: >>>> https://www.ovirt.org/community/about/community-guidelines/ >>>> List Archives: >>>> https://lists.ovirt.org/archives/list/[email protected]/message/P2TVMLHC53JWCLDJNK6UXLZ7ZAUOSYFJ/ >>> >> > _______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/[email protected]/message/RCB2URNPYZGAFCARZX367C54TTNHBH5U/

