Cannot delete or rename folders

ℹ️ Support
,
1

Nextcloud version: 11.0.1
Operating system and version: Debian GNU/Linux 8
Apache or nginx version: nginx/1.6.2
PHP version: 5.6.29
Is this the first time you’ve seen this error and can you replicate it?: yes

The issue you are facing:
We have a very strange Problem with one of our Customers. I am not able to delete ANY folder. If I sign on as Administrator and try to delete a folder (no matter if this folder is shared or not, no matter if empty or not) the error message "Fehler beim Löschen der Datei “test2"” appers. I created a empty folder test. Inside this folder I created a new folder called test2. Not i cannot delete any of these two. Renaming does also not work.

The output of your Nextcloud log in Admin > Logging:
Fatal webdav OCA\DAV\Connector\Sabre\Exception\FileLocked: HTTP/1.1 423 “test/test2” is locked 2017-02-24T08:53:45+0100
Fatal webdav Sabre\DAV\Exception\ServiceUnavailable: HTTP/1.1 503 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘UPDATE oc_mounts SET storage_id = ?, mount_point = ?, mount_id = ? WHERE (user_id = ?) AND (root_id = ?)’ with params [“1”, “/LRA/files/ABZH/”, null, “LRA”, 11264]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction 2017-02-24T08:51:42+0100
Error no app in context Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘UPDATE oc_mounts SET storage_id = ?, mount_point = ?, mount_id = ? WHERE (user_id = ?) AND (root_id = ?)’ with params [“1”, “/LRA/files/ABZH/”, null, “LRA”, 11264]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction 2017-02-24T08:51:42+0100
Fatal webdav Sabre\DAV\Exception\ServiceUnavailable: HTTP/1.1 503 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘UPDATE oc_mounts SET storage_id = ?, mount_point = ?, mount_id = ? WHERE (user_id = ?) AND (root_id = ?)’ with params [“1”, “/LRA/files/ABLU/”, null, “LRA”, 1059]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction 2017-02-24T08:50:43+0100
Error no app in context Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘UPDATE oc_mounts SET storage_id = ?, mount_point = ?, mount_id = ? WHERE (user_id = ?) AND (root_id = ?)’ with params [“1”, “/LRA/files/ABLU/”, null, “LRA”, 1059]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction 2017-02-24T08:50:43+0100
Fatal webdav Sabre\DAV\Exception\ServiceUnavailable: HTTP/1.1 503 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘UPDATE oc_mounts SET storage_id = ?, mount_point = ?, mount_id = ? WHERE (user_id = ?) AND (root_id = ?)’ with params [“1”, “/LRA/files/ABZH/”, null, “LRA”, 11264]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction 2017-02-24T08:49:35+0100
Error no app in context Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘UPDATE oc_mounts SET storage_id = ?, mount_point = ?, mount_id = ? WHERE (user_id = ?) AND (root_id = ?)’ with params [“1”, “/LRA/files/ABZH/”, null, “LRA”, 11264]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction 2017-02-24T08:49:35+0100
Fatal webdav Sabre\DAV\Exception\ServiceUnavailable: HTTP/1.1 503 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘UPDATE oc_mounts SET storage_id = ?, mount_point = ?, mount_id = ? WHERE (user_id = ?) AND (root_id = ?)’ with params [“1”, “/DSC/files/ABZH/”, null, “DSC”, 11264]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

The output of your config.php file:

<?php $CONFIG = array ( 'memcache.local' => '\\OC\\Memcache\\APCu', 'instanceid' => 'ocfefka6wthy', 'passwordsalt' => 'thisisnotmypassword', 'secret' => 'thisisnotmysecret', 'trusted_domains' => array ( 0 => 'customername.ourdomain.ch', ), 'datadirectory' => '/var/www/owncloud/data', 'overwrite.cli.url' => 'https://customername.ourdomain.ch', 'dbtype' => 'mysql', 'version' => '11.0.1.2', 'dbname' => 'ocdb', 'dbhost' => '10.64.51.5', 'dbport' => '', 'dbtableprefix' => 'oc_', 'dbuser' => 'ocuser', 'dbpassword' => 'thisisnotmypassword', 'logtimezone' => 'Europe/Zurich', 'installed' => true, 'updatechecker' => 'false', 'default_language' => 'de', 'log_rotate_size' => '104857600', 'maintenance' => false, 'theme' => '', 'loglevel' => 2, ); **The output of your nginx log:** 10.64.51.1 - LRA [24/Feb/2017:09:08:27 +0100] "PROPFIND /remote.php/webdav/ HTTP/1.0" 207 409 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - DSC [24/Feb/2017:09:08:27 +0100] "PROPFIND /remote.php/webdav/ABLU/Kunden/LUKB/Archiv_LUKB/2014%20Curling%20Trophy/Finanzen HTTP/1.0" 207 1564 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - ARU [24/Feb/2017:09:08:27 +0100] "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Logos/Iconsammlung HTTP/1.0" 500 0 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - DSC [24/Feb/2017:09:08:28 +0100] "PROPFIND /remote.php/webdav/ABLU/Kunden/LUKB/Archiv_LUKB/2014%20Curling%20Trophy/Logo HTTP/1.0" 207 2251 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - DSC [24/Feb/2017:09:08:28 +0100] "PROPFIND /remote.php/webdav/ABLU/Kunden/LUKB/Archiv_LUKB/2014%20Curling%20Trophy/Projektorganisation HTTP/1.0" 207 5162 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - DSC [24/Feb/2017:09:08:29 +0100] "PROPFIND /remote.php/webdav/ABLU/Kunden/LUKB/Archiv_LUKB/2014%20Curling%20Trophy/Restaurant%20Aqua HTTP/1.0" 207 3053 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - DSC [24/Feb/2017:09:08:29 +0100] "PROPFIND /remote.php/webdav/ABLU/Kunden/LUKB/Archiv_LUKB/2014%20Curling%20Trophy/Restaurant%20Aqua/ersetzt HTTP/1.0" 207 1599 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - DSC [24/Feb/2017:09:08:29 +0100] "PROPFIND /remote.php/webdav/ABLU/Kunden/LUKB/Archiv_LUKB/2014%20Curling%20Trophy/Technik HTTP/1.0" 502 166 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - ARU [24/Feb/2017:09:08:30 +0100] "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Kundenanleitungen%20GV%20Saison%202015%2006042015/screenshots HTTP/1.0" 500 0 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - ARU [24/Feb/2017:09:08:30 +0100] "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Logos/Logos_Gesellschaften HTTP/1.0" 500 0 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - ARU [24/Feb/2017:09:08:31 +0100] "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Logos/Iconsammlung HTTP/1.0" 500 0 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 2017/02/24 09:08:16 [error] 70#0: *98250 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 77 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104" while reading response header from upstream, client: 10.64.51.1, server: , request: "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Logos/Logos_Gesellschaften HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 2017/02/24 09:08:16 [error] 70#0: *98254 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 77 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104" while reading response header from upstream, client: 10.64.51.1, server: , request: "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Logos/Iconsammlung HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 2017/02/24 09:08:19 [error] 70#0: *98274 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 77 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104" while reading response header from upstream, client: 10.64.51.1, server: , request: "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Kundenanleitungen%20GV%20Saison%202015%2006042015/screenshots HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 2017/02/24 09:08:26 [error] 70#0: *98300 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 10.64.51.1, server: , request: "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 2017/02/24 09:08:26 [error] 70#0: *98276 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 77 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104" while reading response header from upstream, client: 10.64.51.1, server: , request: "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Logos/Logos_Gesellschaften HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 2017/02/24 09:08:27 [error] 70#0: *98282 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 77 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104" while reading response header from upstream, client: 10.64.51.1, server: , request: "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Logos/Iconsammlung HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 2017/02/24 09:08:29 [error] 72#0: *98320 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 10.64.51.1, server: , request: "PROPFIND /remote.php/webdav/ABLU/Kunden/LUKB/Archiv_LUKB/2014%20Curling%20Trophy/Technik HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 2017/02/24 09:08:30 [error] 70#0: *98296 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 7 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104" while reading response header from upstream, client: 10.64.51.1, server: , request: "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Kundenanleitungen%20GV%20Saison%202015%2006042015/screenshots HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 2017/02/24 09:08:30 [error] 72#0: *98308 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 32 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104" while reading response header from upstream, client: 10.64.51.1, server: , request: "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Logos/Logos_Gesellschaften HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 2017/02/24 09:08:31 [error] 72#0: *98312 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 77 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104" while reading response header from upstream, client: 10.64.51.1, server: , request: "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Logos/Iconsammlung HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" 10.64.51.1 - LRA [24/Feb/2017:09:08:32 +0100] "PROPFIND /remote.php/webdav/ HTTP/1.0" 207 408 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - LRA [24/Feb/2017:09:08:33 +0100] "GET /ocs/v2.php/apps/notifications/api/v1/notifications?format=json HTTP/1.0" 200 452 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 10.64.51.1 - ARU [24/Feb/2017:09:08:33 +0100] "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Kundenanleitungen%20GV%20Saison%202015%2006042015/screenshots HTTP/1.0" 500 0 "-" "Mozilla/5.0 (Macintosh) mirall/2.2.4 (build 1) (Nextcloud)" 2017/02/24 09:08:33 [error] 72#0: *98322 FastCGI sent in stderr: "PHP message: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 7 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104" while reading response header from upstream, client: 10.64.51.1, server: , request: "DELETE /remote.php/webdav/easy%20Services%20AG/4%20Software/Kundenanleitungen%20GV%20Saison%202015%2006042015/screenshots HTTP/1.0", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "customer.ourdomain.ch" **What i already tried:** - Upgrade from Nextcloud 11.0.0 to 11.0.1 - occ 'files:scan --all' - Verify that I use TRANSACTION_READ_COMMITTED transaction isolation level. **This Customer has:** 14 users 159215 files **What I try next:** I will raise the memory limit in my php.ini from memory_limit = 128M to memory_limit = 512M
2

Done! The memory errors are gone. But I am still unable to delete any folder :frowning:

1 Like
3

We have FAQ article for file-locking issues. Did you try the tricks there (redis)?

4

No I did not, thanks for the hint. I will try to instrall and configure redis for file-locking.

5

Hi @tflidd

Unfortunately did the installation and configuration of redis not solve my problems. I am still unable to delete any folder :frowning:

The only difference is that there are no error messages at the nextcloud log. What should I do next? Its really not a good solution to tell the customer that hes just not able anymore to delete any folder :wink:

Thanks a lot! Cheers zisuu

6

Did you place files manually in the data folder? Perhaps some of the permissions in the file system are wrong?

7

Thanks @tflidd for your answere

I did run the permission script from https://docs.nextcloud.com/server/11/admin_manual/installation/installation_wizard.html#setting-strong-directory-permissions

Now i was able to delete the folder.

But there are again a lot of error messages poping up :hushed: : http://pastebin.com/94ATFwYR

Sum of what I did so far:

Please let me know if you need more informations. Thanks a lot! :slight_smile:

8

There is still one folder we are not able to delete:

{“reqId”:“SYz2mwSVfNMwBFv0SDBp”,“remoteAddr”:“10.64.51.1”,“app”:“webdav”,“message”:“Exception: {“Message”:“HTTP\/1.1 423 \“easy\/4 Software\” is locked”,“Exception”:“OCA\\DAV\\Connector\\Sabre\\Exception\\FileLocked”,“Code”:0,“Trace”:”#0 \/var\/www\/owncloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Tree.php(179): OCA\\DAV\\Connector\\Sabre\\Directory->delete()\n#1 \/var\/www\/owncloud\/3rdparty\/sabre\/dav\/lib\/DAV\/CorePlugin.php(287): Sabre\\DAV\\Tree->delete(‘easy…’)\n#2 [internal function]: Sabre\\DAV\\CorePlugin->httpDelete(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#3 \/var\/www\/owncloud\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#4 \/var\/www\/owncloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(479): Sabre\\Event\\EventEmitter->emit(‘method:DELETE’, Array)\n#5 \/var\/www\/owncloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(254): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#6 \/var\/www\/owncloud\/apps\/dav\/appinfo\/v1\/webdav.php(60): Sabre\\DAV\\Server->exec()\n#7 \/var\/www\/owncloud\/remote.php(165): require_once(’\/var\/www\/ownclo…’)\n#8 {main}",“File”:"\/var\/www\/owncloud\/apps\/dav\/lib\/Connector\/Sabre\/Directory.php",“Line”:284,“User”:“adminman”}",“level”:4,“time”:“2017-03-01T13:34:19+01:00”,“method”:“DELETE”,“url”:"/remote.php/webdav/easy/4%20Software",“user”:“adminman”,“version”:“11.0.1.2”}

Should I try with Nextcloud v. 11.0.2?

9

The Folder has been deleted over night. :slight_smile: I guess it just did take some time. But the Error logs http://pastebin.com/94ATFwYR still pop up every new second… What could that be? How can I fix this?

10

11.0.2 could fix some issues. You can also take a look at the repair commands via occ-command:
https://docs.nextcloud.com/server/11/admin_manual/configuration_server/occ_command.html#maintenance-commands-label

11

No, i did just extract the tar file after the download and edit some memory values with sed. Check my comment above.

Thanks I will try the repair commands.

12

We have the same problem. No matter how high we set the memory_limit, the folder does not get deleted. It seems like some kind of memory leak.
I have done all the steps described above and also running 11.0.2, however to no avail.

Anyone got another idea?

[Thu Mar 09 14:06:58.799936 2017] [:error] [pid 52873] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 128 bytes) in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 104
[Thu Mar 09 14:09:04.458057 2017] [:error] [pid 52884] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 72 bytes) in /var/www/owncloud/lib/private/Files/Cache/Cache.php on line 616

13

Hi joris

I could fix this error message with increasing the memory limit in the “.user.ini” file in “/var/www/owncloud/”:

sed -i \
    -e 's/^memory_limit=.*/memory_limit=2048M/g' \
    /var/www/owncloud/.user.ini

But after editing this file I had a new problem: Integrity check problems with .user.ini and docker

Please note: the /var/www/owncloud folder is just because we migrated from owncloud to nextcloud :wink:

14

Thanks for your suggestion.
Unfortunately increasing the memory_limit does not help. It is already at 1GB here and it still gives the error.
For deleting an empty folder, such a high limit should not be needed anyways. For some reason it is leaking memory till it reaches the limit.

15

Hello together

Looks like the same Issue with NC 11.0.2
The file was uploaded with the WebGUI

Fatal webdav OCA\DAV\Connector\Sabre\Exception\FileLocked: HTTP/1.1 423 “Dir/Movie/test.avi” is locked

Error 423 Locked (WebDAV; RFC 4918)
The resource that is being accessed is locked.[15]

/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php - line 179: OCA\DAV\Connector\Sabre\File->delete()
/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 287: Sabre\DAV\Tree->delete('Dir/Movie/te...')
[internal function] Sabre\DAV\CorePlugin->httpDelete(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php - line 105: call_user_func_array(Array, Array)
/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 479: Sabre\Event\EventEmitter->emit('method DELETE', Array)
/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 254: Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/nextcloud/apps/dav/appinfo/v1/webdav.php - line 60: Sabre\DAV\Server->exec()
/var/www/html/nextcloud/remote.php - line 165: require_once('/var/www/html/n...')
{main}

2017-03-10T23:48:55+0100

Info admin_audit File deleted: “/Privat/Filme/test.avi” 2017-03-10T23:48:55+0100
Fatal webdav Sabre\DAV\Exception: HTTP/1.1 500 Could not write file contents

16

I agree, I am still fighting with the same locking problems:

{"reqId":"iImRCZieFQnTZNu+DHb\/","remoteAddr":"10.64.4.1","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 423 \\\"AB\\\/IT\\\/ABZH\\\/externer Server_baloon\\\/Test\\\" is locked\",\"Exception\":\"OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Exception\\\\FileLocked\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(642): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\ObjectTree->move('AB\\\/IT\\\/ABZH\\\/exte...', 'AB\\\/IT\\\/ABZH\\\/exte...')\\n#1 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpMove(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#2 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:MOVE', Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#5 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(60): Sabre\\\\DAV\\\\Server->exec()\\n#6 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#7 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/ObjectTree.php\",\"Line\":277,\"User\":\"adminman\"}","level":4,"time":"2017-04-12T15:33:54+02:00","method":"MOVE","url":"\/remote.php\/webdav\/AB\/IT\/ABZH\/externer%20Server_baloon\/Test","user":"adminman","version":"11.0.2.7"}

Sum of what I did so far:

17

I’ve got a new error message:

{"reqId":"yCFbKUtYim9K3ubwKdKn","remoteAddr":"","app":"core","message":"Error while running background job (class: OCA\\Files_Sharing\\DeleteOrphanedSharesJob, arguments: ): {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'DELETE FROMoc_shareWHEREitem_typein ('file', 'folder') AND NOT EXISTS (SELECTfileidFROMoc_filecacheWHEREfile_source=fileid)':\\n\\nSQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(996): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'DELETE FROMoc…’, Array)\n#2 \/var\/www\/owncloud\/lib\/private\/DB\/Connection.php(215): Doctrine\\DBAL\\Connection->executeUpdate(‘DELETE FROM oc...', Array, Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_sharing\\\/lib\\\/DeleteOrphanedSharesJob.php(62): OC\\\\DB\\\\Connection->executeUpdate('DELETE FROM*P…’)\n#4 \/var\/www\/owncloud\/lib\/private\/BackgroundJob\/Job.php(53): OCA\\Files_Sharing\\DeleteOrphanedSharesJob->run(NULL)\n#5 \/var\/www\/owncloud\/lib\/private\/BackgroundJob\/TimedJob.php(54): OC\\BackgroundJob\\Job->execute(Object(OC\\BackgroundJob\\JobList), Object(OC\\Log))\n#6 \/var\/www\/owncloud\/cron.php(128): OC\\BackgroundJob\\TimedJob->execute(Object(OC\\BackgroundJob\\JobList), Object(OC\\Log))\n#7 {main}",“File”:"\/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php",“Line”:116}",“level”:3,“time”:“2017-04-12T17:45:53+02:00”,“method”:"–",“url”:"–",“user”:"–",“version”:“11.0.2.7”}`

18

Hi people

After all I did not found any long term solution. I have these sync issues and errors since more than 2 years now, no matter which Owncloud or Nextcloud Version. It affects only big customers with redis cache active. My workaround at the moment is to run a daily cronjob during the night, performing these steps:

  • occ ‘files:scan --all’
  • occ ‘files:cleanup’
  • occ ‘maintenance:mode --on’
  • mysql -u root -p’inheregoesyourpassword’ -D ocdb -e ‘delete from oc_file_locks where 1’
  • occ ‘maintenance:mode --off’

Since I launched this cronjob, I did not have any sync or lock Issues.

Good Luck, Cheers zisuu

3 Likes
19

Would someone please explain the meaning of SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, found in this one entry in my error log :

"level":3 "time":"2020-07-30T15:46:21+00:00"  "user":"r129" "app":"index" "method":"GET" 
"url":"/nextcloud/index.php/core/preview?fileId=28109&c=5f22eb47a3009&x=313&y=313&forceIcon=0" 
"message":{"Exception":"Doctrine\\DBAL\\Exception\\DeadlockException"   
  `ttl` = ? WHERE `key` = ? AND `lock` >= 0' with params [1596127581  \"files\\/6c9da58cd5771a20ed28e32cf36e0c8a\"]:\n\n

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction" "Code":0 "Trace":[{"file":"/home/ssh-user/domain.tld/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php" "line":169 "function":"convertException" "class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver" "type":"->" "args":["An exception occurred while executing 'UPDATE `oc_file_locks` SET `lock` = `lock` + 1  `ttl` = ? WHERE `key` = ? AND `lock` >= 0' with params [1596127581  \"files\\/6c9da58cd5771a20ed28e32cf36e0c8a\"]:\n\n
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction" {"errorInfo":["40001" 1213 "Deadlock found when trying to get lock; try restarting transaction"] "__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]} 

{"file":"/home/ssh-user/domain.tld/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php" "line":145 "function":"wrapException" "class":"Doctrine\\DBAL\\DBALException" "type":"::" "args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"} {"errorInfo":["40001" 1213 "Deadlock found when trying to get lock; try restarting transaction"] "__class__":"Doctrine\\DBAL\\Driver\\PDOException"} "An exception occurred while executing 'UPDATE `oc_file_locks` SET `lock` = `lock` + 1  `ttl` = ? WHERE `key` = ? AND `lock` >= 0' with params [1596127581  \"files\\/6c9da58cd5771a20ed28e32cf36e0c8a\"]:\n\n

 SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php" "line":1063 "function":"driverExceptionDuringQuery" "class":"Doctrine\\DBAL\\DBALException" "type":"::" "args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"} {"errorInfo":["40001" 1213 "Deadlock found when trying to get lock; try restarting transaction"] "__class__":"Doctrine\\DBAL\\Driver\\PDOException"} "UPDATE `oc_file_locks` SET `lock` = `lock` + 1  `ttl` = ? WHERE `key` = ? AND `lock` >= 0" {"1":1596127581 "2":"files/6c9da58cd5771a20ed28e32cf36e0c8a"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/DB/Connection.php" "line":220 "function":"executeUpdate" "class":"Doctrine\\DBAL\\Connection" "type":"->" "args":["UPDATE `oc_file_locks` SET `lock` = `lock` + 1  `ttl` = ? WHERE `key` = ? AND `lock` >= 0" [1596127581 "files/6c9da58cd5771a20ed28e32cf36e0c8a"] []]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Lock/DBLockingProvider.php" "line":191 "function":"executeUpdate" "class":"OC\\DB\\Connection" "type":"->" "args":["UPDATE `oc_file_locks` SET `lock` = `lock` + 1  `ttl` = ? WHERE `key` = ? AND `lock` >= 0" [1596127581 "files/6c9da58cd5771a20ed28e32cf36e0c8a"]]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Common.php" "line":747 "function":"acquireLock" "class":"OC\\Lock\\DBLockingProvider" "type":"->" "args":["files/6c9da58cd5771a20ed28e32cf36e0c8a" 1]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Common" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":1947 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":2059 "function":"lockPath" "class":"OC\\Files\\View" "type":"->" "args":["/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 false]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":1142 "function":"lockFile" "class":"OC\\Files\\View" "type":"->" "args":["/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":996 "function":"basicOperation" "class":"OC\\Files\\View" "type":"->" "args":["fopen" "/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" ["read"] "r"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Node/File.php" "line":114 "function":"fopen" "class":"OC\\Files\\View" "type":"->" "args":["/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" "r"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/ProviderV2.php" "line":86 "function":"fopen" "class":"OC\\Files\\Node\\File" "type":"->" "args":["r"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/Image.php" "line":50 "function":"getLocalFile" "class":"OC\\Preview\\ProviderV2" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/GeneratorHelper.php" "line":62 "function":"getThumbnail" "class":"OC\\Preview\\Image" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 4096 4096]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/Generator.php" "line":205 "function":"getThumbnail" "class":"OC\\Preview\\GeneratorHelper" "type":"->" "args":[{"__class__":"OC\\Preview\\PNG"} {"__class__":"OC\\Files\\Node\\File"} 4096 4096]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/Generator.php" "line":127 "function":"getMaxPreview" "class":"OC\\Preview\\Generator" "type":"->" "args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"} {"__class__":"OC\\Files\\Node\\File"} "image/png" ""]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/PreviewManager.php" "line":185 "function":"getPreview" "class":"OC\\Preview\\Generator" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 313 313 true "fill" "image/png"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/core/Controller/PreviewController.php" "line":172 "function":"getPreview" "class":"OC\\PreviewManager" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 313 313 true "fill"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/core/Controller/PreviewController.php" "line":144 "function":"fetchPreview" "class":"OC\\Core\\Controller\\PreviewController" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 313 313 false false "fill"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/Http/Dispatcher.php" "line":170 "function":"getPreviewByFileId" "class":"OC\\Core\\Controller\\PreviewController" "type":"->" "args":[28109 313 313 false false "fill"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/Http/Dispatcher.php" "line":99 "function":"executeController" "class":"OC\\AppFramework\\Http\\Dispatcher" "type":"->" "args":[{"__class__":"OC\\Core\\Controller\\PreviewController"} "getPreviewByFileId"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/App.php" "line":125 "function":"dispatch" "class":"OC\\AppFramework\\Http\\Dispatcher" "type":"->" "args":[{"__class__":"OC\\Core\\Controller\\PreviewController"} "getPreviewByFileId"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php" "line":47 "function":"main" "class":"OC\\AppFramework\\App" "type":"::" "args":["OC\\Core\\Controller\\PreviewController" "getPreviewByFileId" {"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"} {"_route":"core.Preview.getPreviewByFileId"}]} {"function":"__invoke" "class":"OC\\AppFramework\\Routing\\RouteActionHandler" "type":"->" "args":[{"_route":"core.Preview.getPreviewByFileId"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Route/Router.php" "line":299 "function":"call_user_func" "args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"} {"_route":"core.Preview.getPreviewByFileId"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/base.php" "line":1008 "function":"match" "class":"OC\\Route\\Router" "type":"->" "args":["/core/preview"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/index.php" "line":38 "function":"handleRequest" "class":"OC" "type":"::" "args":[]}] "File":"/home/ssh-user/domain.tld/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php" "Line":34 "Previous":

{"Exception":"Doctrine\\DBAL\\Driver\\PDOException" 
"Message":"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction" "Code":"40001" "Trace":[
{"file":"/home/ssh-user/domain.tld/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php" "line":1056 "function":"execute" "class":"Doctrine\\DBAL\\Driver\\PDOStatement" "type":"->" "args":[[1596127581 "files/6c9da58cd5771a20ed28e32cf36e0c8a"]]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/DB/Connection.php" "line":220 "function":"executeUpdate" "class":"Doctrine\\DBAL\\Connection" "type":"->" "args":["UPDATE `oc_file_locks` SET `lock` = `lock` + 1  `ttl` = ? WHERE `key` = ? AND `lock` >= 0" [1596127581 "files/6c9da58cd5771a20ed28e32cf36e0c8a"] []]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Lock/DBLockingProvider.php" "line":191 "function":"executeUpdate" "class":"OC\\DB\\Connection" "type":"->" "args":["UPDATE `oc_file_locks` SET `lock` = `lock` + 1  `ttl` = ? WHERE `key` = ? AND `lock` >= 0" [1596127581 "files/6c9da58cd5771a20ed28e32cf36e0c8a"]]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Common.php" "line":747 "function":"acquireLock" "class":"OC\\Lock\\DBLockingProvider" "type":"->" "args":["files/6c9da58cd5771a20ed28e32cf36e0c8a" 1]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Common" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":1947 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":2059 "function":"lockPath" "class":"OC\\Files\\View" "type":"->" "args":["/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 false]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":1142 "function":"lockFile" "class":"OC\\Files\\View" "type":"->" "args":["/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":996 "function":"basicOperation" "class":"OC\\Files\\View" "type":"->" "args":["fopen" "/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" ["read"] "r"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Node/File.php" "line":114 "function":"fopen" "class":"OC\\Files\\View" "type":"->" "args":["/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" "r"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/ProviderV2.php" "line":86 "function":"fopen" "class":"OC\\Files\\Node\\File" "type":"->" "args":["r"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/Image.php" "line":50 "function":"getLocalFile" "class":"OC\\Preview\\ProviderV2" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/GeneratorHelper.php" "line":62 "function":"getThumbnail" "class":"OC\\Preview\\Image" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 4096 4096]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/Generator.php" "line":205 "function":"getThumbnail" "class":"OC\\Preview\\GeneratorHelper" "type":"->" "args":[{"__class__":"OC\\Preview\\PNG"} {"__class__":"OC\\Files\\Node\\File"} 4096 4096]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/Generator.php" "line":127 "function":"getMaxPreview" "class":"OC\\Preview\\Generator" "type":"->" "args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"} {"__class__":"OC\\Files\\Node\\File"} "image/png" ""]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/PreviewManager.php" "line":185 "function":"getPreview" "class":"OC\\Preview\\Generator" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 313 313 true "fill" "image/png"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/core/Controller/PreviewController.php" "line":172 "function":"getPreview" "class":"OC\\PreviewManager" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 313 313 true "fill"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/core/Controller/PreviewController.php" "line":144 "function":"fetchPreview" "class":"OC\\Core\\Controller\\PreviewController" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 313 313 false false "fill"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/Http/Dispatcher.php" "line":170 "function":"getPreviewByFileId" "class":"OC\\Core\\Controller\\PreviewController" "type":"->" "args":[28109 313 313 false false "fill"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/Http/Dispatcher.php" "line":99 "function":"executeController" "class":"OC\\AppFramework\\Http\\Dispatcher" "type":"->" "args":[{"__class__":"OC\\Core\\Controller\\PreviewController"} "getPreviewByFileId"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/App.php" "line":125 "function":"dispatch" "class":"OC\\AppFramework\\Http\\Dispatcher" "type":"->" "args":[{"__class__":"OC\\Core\\Controller\\PreviewController"} "getPreviewByFileId"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php" "line":47 "function":"main" "class":"OC\\AppFramework\\App" "type":"::" "args":["OC\\Core\\Controller\\PreviewController" "getPreviewByFileId" {"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"} {"_route":"core.Preview.getPreviewByFileId"}]} {"function":"__invoke" "class":"OC\\AppFramework\\Routing\\RouteActionHandler" "type":"->" "args":[{"_route":"core.Preview.getPreviewByFileId"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Route/Router.php" "line":299 "function":"call_user_func" "args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"} {"_route":"core.Preview.getPreviewByFileId"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/base.php" "line":1008 "function":"match" "class":"OC\\Route\\Router" "type":"->" "args":["/core/preview"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/index.php" "line":38 "function":"handleRequest" "class":"OC" "type":"::" "args":[]}] "File":"/home/ssh-user/domain.tld/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php" "Line":119 "Previous":

{"Exception":"PDOException" "Message":"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction" "Code":"40001" "Trace":[
{"file":"/home/ssh-user/domain.tld/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php" "line":117 "function":"execute" "class":"PDOStatement" "type":"->" "args":[[1596127581 "files/6c9da58cd5771a20ed28e32cf36e0c8a"]]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php" "line":1056 "function":"execute" "class":"Doctrine\\DBAL\\Driver\\PDOStatement" "type":"->" "args":[[1596127581 "files/6c9da58cd5771a20ed28e32cf36e0c8a"]]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/DB/Connection.php" "line":220 "function":"executeUpdate" "class":"Doctrine\\DBAL\\Connection" "type":"->" "args":["UPDATE `oc_file_locks` SET `lock` = `lock` + 1  `ttl` = ? WHERE `key` = ? AND `lock` >= 0" [1596127581 "files/6c9da58cd5771a20ed28e32cf36e0c8a"] []]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Lock/DBLockingProvider.php" "line":191 "function":"executeUpdate" "class":"OC\\DB\\Connection" "type":"->" "args":["UPDATE `oc_file_locks` SET `lock` = `lock` + 1  `ttl` = ? WHERE `key` = ? AND `lock` >= 0" [1596127581 "files/6c9da58cd5771a20ed28e32cf36e0c8a"]]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Common.php" "line":747 "function":"acquireLock" "class":"OC\\Lock\\DBLockingProvider" "type":"->" "args":["files/6c9da58cd5771a20ed28e32cf36e0c8a" 1]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Common" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.phppper.php" "line":593 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":1947 "function":"acquireLock" "class":"OC\\Files\\Storage\\Wrapper\\Wrapper" "type":"->" "args":["fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 {"__class__":"OC\\Lock\\DBLockingProvider"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":2059 "function":"lockPath" "class":"OC\\Files\\View" "type":"->" "args":["/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1 false]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":1142 "function":"lockFile" "class":"OC\\Files\\View" "type":"->" "args":["/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" 1]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/View.php" "line":996 "function":"basicOperation" "class":"OC\\Files\\View" "type":"->" "args":["fopen" "/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" ["read"] "r"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Files/Node/File.php" "line":114 "function":"fopen" "class":"OC\\Files\\View" "type":"->" "args":["/r129/files/finances/fidel-InfoSrv_nur-signups/fid3.1.3Welcome_x7030/Screenshot from 2020-05-29 15-37-27.png" "r"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/ProviderV2.php" "line":86 "function":"fopen" "class":"OC\\Files\\Node\\File" "type":"->" "args":["r"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/Image.php" "line":50 "function":"getLocalFile" "class":"OC\\Preview\\ProviderV2" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/GeneratorHelper.php" "line":62 "function":"getThumbnail" "class":"OC\\Preview\\Image" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 4096 4096]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/Generator.php" "line":205 "function":"getThumbnail" "class":"OC\\Preview\\GeneratorHelper" "type":"->" "args":[{"__class__":"OC\\Preview\\PNG"} {"__class__":"OC\\Files\\Node\\File"} 4096 4096]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Preview/Generator.php" "line":127 "function":"getMaxPreview" "class":"OC\\Preview\\Generator" "type":"->" "args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"} {"__class__":"OC\\Files\\Node\\File"} "image/png" ""]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/PreviewManager.php" "line":185 "function":"getPreview" "class":"OC\\Preview\\Generator" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 313 313 true "fill" "image/png"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/core/Controller/PreviewController.php" "line":172 "function":"getPreview" "class":"OC\\PreviewManager" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 313 313 true "fill"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/core/Controller/PreviewController.php" "line":144 "function":"fetchPreview" "class":"OC\\Core\\Controller\\PreviewController" "type":"->" "args":[{"__class__":"OC\\Files\\Node\\File"} 313 313 false false "fill"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/Http/Dispatcher.php" "line":170 "function":"getPreviewByFileId" "class":"OC\\Core\\Controller\\PreviewController" "type":"->" "args":[28109 313 313 false false "fill"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/Http/Dispatcher.php" "line":99 "function":"executeController" "class":"OC\\AppFramework\\Http\\Dispatcher" "type":"->" "args":[{"__class__":"OC\\Core\\Controller\\PreviewController"} "getPreviewByFileId"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/App.php" "line":125 "function":"dispatch" "class":"OC\\AppFramework\\Http\\Dispatcher" "type":"->" "args":[{"__class__":"OC\\Core\\Controller\\PreviewController"} "getPreviewByFileId"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php" "line":47 "function":"main" "class":"OC\\AppFramework\\App" "type":"::" "args":["OC\\Core\\Controller\\PreviewController" "getPreviewByFileId" {"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"} {"_route":"core.Preview.getPreviewByFileId"}]} {"function":"__invoke" "class":"OC\\AppFramework\\Routing\\RouteActionHandler" "type":"->" "args":[{"_route":"core.Preview.getPreviewByFileId"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/private/Route/Router.php" "line":299 "function":"call_user_func" "args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"} {"_route":"core.Preview.getPreviewByFileId"}]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/lib/base.php" "line":1008 "function":"match" "class":"OC\\Route\\Router" "type":"->" "args":["/core/preview"]} 
{"file":"/home/ssh-user/domain.tld/nextcloud/index.php" "line":38 "function":"handleRequest" "class":"OC" "type":"::" "args":[]}] "File":"/home/ssh-user/domain.tld/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php" "Line":117}} "CustomMessage":"--"} 

"version":"18.0.7.1"}