Fixing "File locked" Nextcloud errors

When syncing files with NextCloud, some might get stuck in a "locked" state. Here is how to unlock them.

First, get Bash access to the database container:

microk8s.kubectl exec --stdin --tty -n nextcloud mariadb-56ddf79d95-dspst -- /bin/bash

Log into the database

mysql -u root -p

Select the database

use nextcloud;

Delete the locks:

DELETE FROM oc_file_locks WHERE 1;