How to release the lock of a canceled task?

[lfu]

"Required lock is already taken by other running tasks" error after forcefully cancelling sync task on a repo

Problem: After forcefully canceling a hanging repo sync task (maybe not the best idea), whenever I try to interact with that repo in Foreman, I receive a “Required lock is already taken by other running tasks” error message with a link to the task that I forcefully canceled. The linked task is in a stopped state, not running. I assume the error is caused by orphaned lock files, but am unsure of the process I need to follow to clear the lock files. Expected outcome: Lock files are cleared and …