Error while System Update - Already existing lock

[former_member865500]

Error while System Update - Already existing lock

While trying to do System update from hac, getting the following error:

"System update can not be performed, there is already existing lock : 'System update' on 'master' tenant and cluster id 2"

[Harish_Vatsa · Accepted solution]

Hello charan_nalli,

To resolve the issue, please follow these steps:

1. Shutdown all Hybris application servers.

2. Check the database for any existing locks related to the system update. If any locks are found, remove them manually.

3. Start only one Hybris application server.

4. Perform the System Update on the single running application server.

5. Once the System Update is completed successfully, restart all the remaining Hybris application servers.

By following these steps, you can ensure a controlled and sequential process for the System Update, allowing for proper handling of locks and minimizing any potential conflicts.

--

Regards,

H.V.

[former_member865500 · Accepted solution]

thanks for your response harishvatsa

in systeminit table it is showing locked values as 1 (systeminit table is updated with a date for lockdate and the value of locked is updated to 1. ) can you please help me how to update the values as 0

can you please help me to solve this..?

[Harish_Vatsa · Accepted solution]

Hi charan_nalli,

Can you please try executing the below query to release the lock:

UPDATE systeminit SET locked = 0;

[former_member865500 · Accepted solution]

Hi harishvatsa

where i need to execute the above query can you please guide me

tried the same query under section and choosen SQL query but its not working

[Harish_Vatsa · Accepted solution]

Dear charan_nalli,

Please login to HAC then go to console --> FlexibleSearch --> SQL query

and run the following query:

UPDATE systeminit SET locked=0

[former_member865500 · Accepted solution]

thank you for your help harishvatsa

the query is working fine and now iam able to update the system