File is locked - how to unlock

[rhua]

Since it has been up to 39 months since the quoted users have submitted a post on this topic, I believe that it is necessary to ask for an update: has anyone experienced any problems as a result of disabling file lock? The admin is making a cautious decision regarding the file lock configuration on an installation with one user on Notes, Calendar, and Deck at a time. Please provide the version numbers in your reply to provide readers a more informed decision.

@mwallace

'filelocking.enabled' => false,

@castillo92

Shared hosting (others who can’t install redis): You can disable the file locking, edit your configuration file config/config.php:

‘filelocking.enabled’ => false,

However, disabling is not a good solution. You can run into problems when several processes try to write to a file (especially online editors in the web-interface). In single-user and single-client environments, it’s probably less of a problem.

@webunraveling

If I remember right, that error is caused by a locked file. Take a look at the following URL, under " Manually disable locking state ".
[from Error when deleting file or folder]

[imit_L]

Is it written like this? ?
‘Filelocking.enabled’ => false
After I add it, my php can’t be used directly

[francois-ferrandis]

Hello all! I have a question.

The usual solution given to wipe stale locks is the following:

1. DELETE all the rows from oc_file_locks
2. Run occ files:scan --all

I am thus wondering why it would not be reasonable to set lock to 0 on all non-zero rows, like this :

UPDATE `oc_file_locks` 
SET `oc_file_locks`.`lock` = 0
WHERE `oc_file_locks`.`lock` != 0;

Would that be asking for trouble? (given maintenance mode is enabled, of course)

[rhua]

Nextcloud 19.0.1 Problem with deleting files/folders

I first tried following the next instruction: Which at step one resulted in mayor errors and the process being killed: Starting scan for user 1 out of 3 (Some_user_without_groupfolder_access) Starting scan for user 2 out of 3 (Some_user_with_Groupfolder_access) Exception during scan: An exception occurred while executing 'SELECT `fileid` FROM `oc_filecache` WHERE (`storage` = ?) AND (`path_hash` = ?)' with params [1, "1e6013faa7e8570d55f5164261dc1b4d"]: SQLSTATE[HY000]: General error: 2…

[vatolin]

@tflidd

DELETE FROM oc_file_locks WHERE 1

If

DELETE FROM oc_file_locks WHERE 1

results in:

ERROR: argument of WHERE must be type boolean, not type integer LINE 1: DELETE FROM oc_file_locks WHERE 1

modify the command:

DELETE FROM oc_file_locks WHERE true

[headingwest]

My site is hosted on Cloudways. This automatically installs the Varnish Cache which turns out not to work with nextcloud. Turning off Varnish in the Cloudways settings resolved this for me.

[InerTier]

I am experiencing issues with locked files that I cannot delete or move, but I have a subscription with a provider and thus have no admin access. Is there really no end-user-accessible way to escape from this situation? If so, any chance at getting one added?

[marcymurli]

I’m having similar problems. First of all, I have to say my head is spinning a bit from looking at these help pages because I am a total novice when it comes to coding and stuff like that. I didn’t think I’d have to know such things when I left Google Drive for NextCloud.

I’m having problems moving folders. I keep getting messages that say “could not move” and sometimes “target exists.”

Can someone help me figure this out in simple English?

Thank you so much!

[Vadmin]

I have exactly the same problem.
Moreover, when synchronizing a large file, somewhere around 180GB through the Nextcloud client. Error message 423 Locked appears, and after a while everything starts to synchronize all over again. In the log I see the following error "Error PHP Error: fopen (/ var / nextcloud / uploads / 1939388670/00000839): failed to open stream: No such file or directory at / var / www / nextcloud / lib / private / Files / Storage / Local.php # 354 "
What to do with it? in php.ini the maximum time is 10400.

[czsz]

@tflidd

You can’t access files because they are locked

Make sense…

" Empty table oc_file_locks"
Oh ok. It’s nice if you wrote how to do it, because it’s not written anywhere …
One problem generates another. Opensource world.

[simonspa]

Please be respectful. The description of how to perform exactly this action is described in detail by @tflidd in the post you are quoting from.

[czsz]

Do you think if that was a solution, I would still be writing here?

[simonspa]

Yes I do think that this is the solution:

@tflidd

Empty table oc_file_locks: Use tools such as phpmyadmin or connect directly to your database and run (the default table prefix is oc_, this prefix can be different or even empty):
DELETE FROM oc_file_locks WHERE 1

Cheers
/S

[szaimen]

Another temporary solution is to set filelocking to false in your config.php:
'filelocking.enabled' => false,

[rubo77]

@janvlug

I did some further investigations and noted that the owncloud.file_locks table had some more rows where the lock was <> 0, but not 1:
SELECT * FROM owncloud.file_locks WHERE file_locks.lock<>0;

On Nextcloud 21 in a docker container you would need this command:

docker exec nextyourdomain_db_1 mysql nextcloud -p$MYSQL_ROOT_PASSWORD -e "SELECT * FROM oc_file_locks WHERE \`lock\`<>0;"

[EE35lJo1UNAhrCaS4Yum]

Hi,

we had the same issue several times already but the solutions described so far cannot be applied: the lock table is empty, so the SQL statements will not work. Disabling filelocking is not a solution for us.

We came up with a different solution which workes just fine:

• Log on as with an admin account via ssh
• Go to the directory where the file should be, check for any partially uploaded files and delete them
• Upload the file via scp and move it to the destination directory
• Change owner and group to www-data
• run occ files: scan

Regards

[eaglegamma]

Thank you for this useful post!

[Agterbosch]

It’s now nearly 6 years later, yet here we are, the bug still persists, this is ridiculous… Just give us a gui option for admins to unlock the files

[syncup]

If it helps, I “solved” this problem as follows: I can't rename files...(Não consigo renomear arquivos) Help me please!

[tkonto]

To the point!
Thank you.