Yes, I did it, not working in my case.

This is explanation from Benny:

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.


> On 8 Aug 2022, at 15:30, Jirka Simon <[email protected]> wrote:
> 
> Hi Andrei 
> 
> have you cecked locked entries here ?
> 
> /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh -t all  -qc
> 
> it helped to me to unlock snapshots and disks and then restart VM.  but yes, 
> there is a chance to damage VM, 
> 
> 
> 
> Jirka
> 
> On 8/8/22 08:33, Andrei Verovski wrote:
>> 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]> 
>>> <mailto:[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]> 
>>> <mailto:[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]> 
>>>>> <mailto:[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]> 
>>>>> <mailto:[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] <mailto:[email protected]>
>>>>>> To unsubscribe send an email to [email protected] 
>>>>>> <mailto:[email protected]>
>>>>>> Privacy Statement: https://www.ovirt.org/privacy-policy.html 
>>>>>> <https://www.ovirt.org/privacy-policy.html>
>>>>>> oVirt Code of Conduct: 
>>>>>> https://www.ovirt.org/community/about/community-guidelines/ 
>>>>>> <https://www.ovirt.org/community/about/community-guidelines/>
>>>>>> List Archives: 
>>>>>> https://lists.ovirt.org/archives/list/[email protected]/message/P2TVMLHC53JWCLDJNK6UXLZ7ZAUOSYFJ/
>>>>>>  
>>>>>> <https://lists.ovirt.org/archives/list/[email protected]/message/P2TVMLHC53JWCLDJNK6UXLZ7ZAUOSYFJ/>
>> _______________________________________________
>> Users mailing list -- [email protected] <mailto:[email protected]>
>> To unsubscribe send an email to [email protected] 
>> <mailto:[email protected]>
>> Privacy Statement: https://www.ovirt.org/privacy-policy.html 
>> <https://www.ovirt.org/privacy-policy.html>
>> oVirt Code of Conduct: 
>> https://www.ovirt.org/community/about/community-guidelines/ 
>> <https://www.ovirt.org/community/about/community-guidelines/>
>> List Archives: 
>> https://lists.ovirt.org/archives/list/[email protected]/message/RCB2URNPYZGAFCARZX367C54TTNHBH5U/
>>  
>> <https://lists.ovirt.org/archives/list/[email protected]/message/RCB2URNPYZGAFCARZX367C54TTNHBH5U/>

_______________________________________________
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/5TSYYT2CH42LL75NUDSKQYVKUICJ2LPL/

Reply via email to