Unable to update WordPress as another update is in progress

Hello,

when my website tries to run a wordpress update as in ver 5.8.2, it gives out an error saying that there is another update in progress. Tried fixing it in the phpMyAdmin by deleting the core_updater.lock but didn’t solve it. Also tried ‘fix another update in progress’ app but without success.

Reached out to my hosting support and this is what they said:

When the site tries to run an update, it executes the following MySQL command:

INSERT INTO wrd_options ( option_name, option_value, autoload ) VALUES (‘core_updater.lock’, 1592768373, ‘no’)

If this fails, WordPress assumes it’s because the entry already exists, indicating an update is in progress. However, when I run the command on your database, it fails for a different reason: #1062 – Duplicate entry ‘0’ for key ‘PRIMARY’

This error is causing the update to think there is one already happening. Unfortunately, it’s not something we are able to address from the server/system side, as this is very much an application issues.

Is there a way you would help me resolve the issue? Plugins seem to be able to update. But core theme plugins also fail to update as the ones found in Appearance/Install Plugins.

Thank you for your help.