occ command to clear all locks

[PVince81]

In some OC versions like OC < 9.0.2 in can happen that the database contains stray locks due to bugs.

We should write a repair step that clears these stray locks at update time.

@icewind1991 let's do this in the hardening phase of 9.1

CC @cmonteroluque

[ghost]

Fixes #21360

[simsala]

Still happening in version 9.0.2.
Lock table just keeps on growing and is never cleared.

[simsala]

Related to #20380 and #24507
Seeing both effects on my 9.0.2.
Details here and config can be found here:#20380

So this is affecting OC ≤ 9.0.2.

[PVince81]

@icewind1991 please have a look why there are still stray locks

[PVince81]

PR here #25064

[PVince81]

Closing due to #25064 (comment)

The TTL should already take care of this.
If the TTL doesn't work it's a different issue, there are already otherreports of stray locks staying longer than necessary.

[mdonges]

is it possible to trigger the repair step manually?

e.g via a new feature as
occ files:release-stary-locks

or ist there already an existing way?

I updated my instance to 9.1.4 but still could not get rid of the locks....

[PVince81]

An occ command is a good idea.

But a lock cannot be detected as stray as long as its timeout hasn't been reached.
So the command would rather clear ALL locks and should be run in maintenance mode to avoid disrupting transfers that might be in progress.