Error when deleting file from Linux desktop client

[benis]

Hi dear community,

I get a “fatal error” when I delete files in the Nextcloud desktop client (Linux, Ubuntu). Any ideas what might be wrong? Running Nextcloud 19.0.3 in Docker.

It looks like this:

[webdav] Fatal: Doctrine\DBAL\Exception\DeadlockException: An exception occurred while executing ‘UPDATE oc_filecache SET size = ? WHERE (fileid = ?) AND ((size <> ?) OR (size IS NULL))’ with params [202704267200, 68139, 202704267200]:

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at <>

0. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
   Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(“An exception oc … n”, Doctrine\DBAL\Dr … ]})
1. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
   Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “An exception oc … n”)
2. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1063
   Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “UPDATE `oc_file … )”, {1: 202704267200 … 0})
3. /var/www/html/lib/private/DB/Connection.php line 214
   Doctrine\DBAL\Connection->executeUpdate(“UPDATE `oc_file … )”, [202704267200,"* … 0], [2,1,2])
4. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 203
   OC\DB\Connection->executeUpdate(“UPDATE `oc_file … )”, {dcValue1: "*** … 0}, {dcValue1: 1,dcValue2: 2,dcValue3: 2})
5. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 216
   Doctrine\DBAL\Query\QueryBuilder->execute()
6. /var/www/html/lib/private/Files/Cache/Cache.php line 363
   OC\DB\QueryBuilder\QueryBuilder->execute()
7. /var/www/html/lib/private/Files/Cache/Cache.php line 898
   OC\Files\Cache\Cache->update(“*** sensitive parameters replaced ***”)
8. /var/www/html/lib/private/Files/Cache/HomeCache.php line 43
   OC\Files\Cache\Cache->calculateFolderSize(“files/Pictures/ … r”, OC\Files\Cache\CacheEntry {})
9. /var/www/html/lib/private/Files/Cache/Cache.php line 830
   OC\Files\Cache\HomeCache->calculateFolderSize(“files/Pictures/ … r”, null)
10. /var/www/html/lib/private/Files/Cache/Cache.php line 842
    OC\Files\Cache\Cache->correctFolderSize(“files/Pictures/ … r”)
11. /var/www/html/lib/private/Files/Cache/Cache.php line 842
    OC\Files\Cache\Cache->correctFolderSize(“files/Pictures/ … n”)
12. /var/www/html/lib/private/Files/Cache/Updater.php line 217
    OC\Files\Cache\Cache->correctFolderSize(“files/Pictures/ … 4”)
13. /var/www/html/apps/files_trashbin/lib/Trashbin.php line 289
    OC\Files\Cache\Updater->renameFromStorage(OCA\Files_Trashb … }}, “files/Pictures/ … 4”, “files_trashbin/ … 7”)
14. /var/www/html/apps/files_trashbin/lib/Trash/LegacyTrashBackend.php line 108
    OCA\Files_Trashbin\Trashbin::move2trash(“Pictures/2019/( … 4”)
15. /var/www/html/apps/files_trashbin/lib/Trash/TrashManager.php line 103
    OCA\Files_Trashbin\Trash\LegacyTrashBackend->moveToTrash(OCA\Files_Trashb … }}, “files/Pictures/ … 4”)
16. /var/www/html/apps/files_trashbin/lib/Storage.php line 192
    OCA\Files_Trashbin\Trash\TrashManager->moveToTrash(OCA\Files_Trashb … }}, “files/Pictures/ … 4”)
17. /var/www/html/apps/files_trashbin/lib/Storage.php line 99
    OCA\Files_Trashbin\Storage->doDelete(“files/Pictures/ … 4”, “unlink”)
18. /var/www/html/lib/private/Files/View.php line 1161
    OCA\Files_Trashbin\Storage->unlink(“files/Pictures/ … 4”)
19. /var/www/html/lib/private/Files/View.php line 718
    OC\Files\View->basicOperation(“unlink”, “/Pictures/2019/ … 4”, [“delete”])
20. /var/www/html/apps/dav/lib/Connector/Sabre/File.php line 458
    OC\Files\View->unlink(“/Pictures/2019/ … 4”)
21. /var/www/html/3rdparty/sabre/dav/lib/DAV/Tree.php line 183
    OCA\DAV\Connector\Sabre\File->delete()
22. /var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 295
    Sabre\DAV\Tree->delete(“files/benjamin/ … 4”)
23. /var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpDelete(Sabre\HTTP\Request {}, Sabre\HTTP\Response {})
24. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 474
    Sabre\DAV\Server->emit(“method:DELETE”, [Sabre\HTTP\Requ … }])
25. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 251
    Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Request {}, Sabre\HTTP\Response {})
26. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 319
    Sabre\DAV\Server->start()
27. /var/www/html/apps/dav/lib/Server.php line 320
    Sabre\DAV\Server->exec()
28. /var/www/html/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
29. /var/www/html/remote.php line 167
    require_once(“/var/www/html/a … p”)

DELETE /remote.php/dav/files/benjamin/Pictures/2019/(2019-08-01)%20Dreamtrip%202019/GoPro/L%C3%A4nder/5%20Italien/GOPR9670.MP4
from 172.18.0.2 by benjamin at 2020-10-19T09:09:37+00:00

[floa]

Hei benis,
maybe the file is locked. Did you try to unlock?

[benis]

Hi @floa,
How do I do that? Unlock a file I mean?

[floa]

In your database, there is a table oc_file_lock
Delete all entries with value lock that are not 0
Easiest way is to use phpmyadmin (but you can also use SQL CLI when you have ssh access to your server)
This is the SQL command:

DELETE FROM `nextcloud`.`oc_file_locks` WHERE `oc_file_locks`.`lock` != 0;

Make sure you have the ; at the end of the line

Tell me if you need help with phpmyadmin or SQL CLI

[benis]

Thanks again!

I look in the database (using DBeaver) and no locked files what I can see:

Just four rows and nothing “1” under “lock” column.

I will monitor this table when deleting a lot of files (10+).

[floa]

ok, that seems not to be the case for your problem.

What happens if you try to delete the file in the webinterface of your nextcloud instance?

If you cannot delete the file there too, next step you can try to find the file you want to delete in your data directory in the server and delete it manually there.
After that, run “occ files:scan --path=”

[benis]

It seems like I can delete files - my “only” issue is the errors in the log. Weird I think?

[floa]

yeah, really weired. so i am sorry, i cannot help here any further.
Maybe another member can read your log in a more precise way then i do.