Removing filelock in nextcloud trough pgadmin or cli

[Fjeld]

Is there a way to remove filelock error when running occ scan file command.

I am using Nextcloud from charts:

nextcloud:27.1.3
nginx:1.23.3
postgres:13.1

I have PGadmin installed on the Scale server and localy but I cant figure out how to connect to the postgres server to make a
"DELETE FROM oc_file_locks WHERE 1; command.

My original problem very slow occ file scan leads me down the path where I think there are som files that are locked so it goes very slow.

This was a scan on a small group folder.

And with 60-70 tb of data this would take to long to even consider, so I am trying to find out what makes it so very very slow before I start using a VM instead.

The commands I have used from shell are:

su // to be able to type commands
su -m www-data -c "php /var/www/html/occ files:scan --all"

su -m www-data -c "php /var/www/html/occ groupfolders:scan -v --all"

Kind regards

Tomas

 

[Fjeld]

After some help from the Nextcloud forum and other searches I can see that the postgres server hits 99% straight away when running the occ command. So I need to find out what is happening with that and if it can be tweaked.