OCA\DAV\Connector\Sabre\Exception\FileLocked - DB race condition

Steps to reproduce

1. Create a new user via admin user
2. Login with new user
3. Try to delete the files

Expected behaviour

All files should be deleted

Actual behaviour

All files, except "Nextcloud Manual.pdf" gets deleted

I checked my db for the "locked" table, but all files are set to "0"
Yes, this always happens
Yes, this also happend with other files, as well when I tried to rename files

All tests passed and cron works correct

Server configuration

Operating system: Ubuntu 16.04.3 LTS

Web server: Apache/2.4.29

Database: MySQL 5.7.21

PHP version: 7.2.2

Nextcloud version: 13

Updated from an older Nextcloud/ownCloud or fresh install: clean install

Where did you install Nextcloud from: wget, clean install

Logging

OCA\DAV\Connector\Sabre\Exception\FileLocked: "Nextcloud Manual.pdf" is locked
/var/www/html/cloud/3rdparty/sabre/dav/lib/DAV/Tree.php - line 179: OCA\DAV\Connector\Sabre\File->delete()
/var/www/html/cloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 287: Sabre\DAV\Tree->delete('Nextcloud Manua...')
[internal function] Sabre\DAV\CorePlugin->httpDelete(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/cloud/3rdparty/sabre/event/lib/EventEmitterTrait.php - line 105: call_user_func_array(Array, Array)
/var/www/html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 479: Sabre\Event\EventEmitter->emit('method DELETE', Array)
/var/www/html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 254: Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/cloud/apps/dav/appinfo/v1/webdav.php - line 80: Sabre\DAV\Server->exec()
/var/www/html/cloud/remote.php - line 164: require_once('/var/www/html/c...')
{main}

[FriedCircuits]

I have the same exact issue. Mine started when I removed a directory while it was still syncing. I had to fix the php file size and now if it put it back it won't sync or if I deleted it I can't delete the empty folder on the server. The data store has a bunch of file parts. But the error in the log is the same as above whenever I try and delete the folder in the UI.

I am on php 7.0 and NC 13.

[FriedCircuits]

Just FYI I fixed it by deleting the file from the filecache table and then deleting the folder manually. Hope that helps you. Then ran scan files for the user to be sure everything was well.

Edit: Seems like I can't use the folder name again. If I do the problem comes back and it won't sync and get the same error above again in the logs.

[nickvergessen]

are you using database file locking of nextcloud? Please post the output of ./occ config:list system

[FriedCircuits]

Sorry for the delay. I haven't seen the error since but in my case it looks like file locking is enabled.

"filelocking.enabled": true,

[castillo92]

Me too, waiting for response.

NextCloud v13.0.1

EDIT:

Well, I fix it adding this line to the config file....

sudo nano /var/www/nextcloud/config/config.php

'filelocking.enabled' => false,

[major5012]

@nickvergessen I have a number of these errors also.

"OCA\DAV\Connector\Sabre\Exception\FileLocked"

NC 13.0.2
PHP 5.6.35

./occ config:list system

    "memcache.local": "\\OC\\Memcache\\APCu",
    "filelocking.enabled": "true",
    "memcache.locking": "\\OC\\Memcache\\Redis",
    "redis": {
        "host": "***REMOVED SENSITIVE VALUE***",
        "port": 6379,
        "timeout": 0
    },

[dinkonin]

Same problem with Nextcloud 13.0.4 , php 7.1.18 , redis 4.0.9 with this settings

  'memcache.local' => '\\OC\\Memcache\\APCu',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
   array (
    'host' => 'localhost',
    'port' => 6379,
  ),

[stephanedupont]

Same problem since I updated to Nextcloud 13.0.4. Was working fine before. Now if I'm doing some stuff like updating/deleting a file that was just created moments ago, I have this error.

Fixed by adding

'filelocking.enabled' => false,

... but what does that imply? Is it safe to disable file locking?

[tapete]

Same problem since I updated to Nextcloud 13.0.4. Was working fine before.

Exactly the same problem with my nextcloud instance. It also came with the 13.0,4 update. It seems that the error occurs only if a file is synced, which is locked at my local NTFS file system.

[bl4ckOut]

Same here since 13.0.4. Disabling file locking is not a solution for me.

@linucksrox
I can confirm that oc_file_locks table is empty. Only temporary solution which works for me is to:

• occ files:cleanup
• occ files:scan -all
• occ maintenance:repair

(currently my repair.sh)

[linucksrox]

I have tried the solution outlined on the Nextcloud forums (https://help.nextcloud.com/t/file-is-locked-how-to-unlock/1883) but it doesn't help with our issue. We also tried rebooting the client's machine and rebooting the Nextcloud server to no avail.
Another interesting note is that there are 0 records in the oc_file_locks table but the client is still complaining that the files are locked and new entries are still appearing in the server log.

Can confirm. Still the same error.