[QA] Error messages while deleting files

[jnweiger]

Seen with ownCloud for QNAP 10.8.0 from ownCloud_10.8.0_arm-x41.qpkg (2021-07-21)

• Via web-ui, add 10 files
• Move them into a folder
• select all, delete
• three (out of 10) error messages pop up "delete failed(?)" and disappeared again.

The Server log has this

{"reqId":"t4upVa1NAWybSs3WDLAR","level":3,"time":"2021-07-28T11:30:19+00:00","remoteAddr":"172.30.12.1","user":"--","app":"PHP","method":"GET","url":"\/owncloud\/index.php","message":"include(layout.noscript.warning.php): failed to open stream: No such file or directory at \/var\/www\/owncloud\/apps\/theme-qnap\/core\/templates\/layout.guest.php#32"}
{"reqId":"t4upVa1NAWybSs3WDLAR","level":3,"time":"2021-07-28T11:30:19+00:00","remoteAddr":"172.30.12.1","user":"--","app":"PHP","method":"GET","url":"\/owncloud\/index.php","message":"include(): Failed opening 'layout.noscript.warning.php' for inclusion (include_path='\/var\/www\/owncloud\/apps:\/var\/www\/owncloud\/custom') at \/var\/www\/owncloud\/apps\/theme-qnap\/core\/templates\/layout.guest.php#32"}
{"reqId":"uAO98nlIuzkwByGwncNi","level":4,"time":"2021-07-28T11:30:24+00:00","remoteAddr":"172.30.12.1","user":"admin","app":"webdav","method":"DELETE","url":"\/owncloud\/remote.php\/dav\/files\/admin\/New%20folder\/20200507_181748.jpg","message":"Exception: An exception occurred while executing 'UPDATE \"oc_filecache\" SET \"mtime\" = GREATEST(\"mtime\", ?), \"etag\" = ? WHERE (\"storage\" = ?) AND (\"path_hash\" IN ('d41d8cd98f00b204e9800998ecf8427e', '45b963397aa40d4a0063e0d85e4fe7a1', '68a4509e71999ad6fce3444c6fc9cae5'))' with params [1627471823, \"61013fcf75654\", 1]:\n\nSQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\nDETAIL:  Process 9153 waits for ShareLock on transaction 140555; blocked by process 9152.\nProcess 9152 waits for ShareLock on transaction 140562; blocked by process 9153.\nHINT:  See server log for query details.\nCONTEXT:  while locking tuple (7,9) in relation \"oc_filecache\": {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DeadlockException\",\"Message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = GREATEST(\\\"mtime\\\", ?), \\\"etag\\\" = ? WHERE (\\\"storage\\\" = ?) AND (\\\"path_hash\\\" IN ('d41d8cd98f00b204e9800998ecf8427e', '45b963397aa40d4a0063e0d85e4fe7a1', '68a4509e71999ad6fce3444c6fc9cae5'))' with params [1627471823, \\\"61013fcf75654\\\", 1]:\\n\\nSQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\\nDETAIL:  Process 9153 waits for ShareLock on transaction 140555; blocked by process 9152.\\nProcess 9152 waits for ShareLock on transaction 140562; blocked by process 9153.\\nHINT:  See server log for query details.\\nCONTEXT:  while locking tuple (7,9) in relation \\\"oc_filecache\\\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(182): Doctrine\\\\DBAL\\\\Driver\\\\AbstractPostgreSQLDriver->convertException()\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(159): Doctrine\\\\DBAL\\\\DBALException::wrapException()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(2212): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1524): Doctrine\\\\DBAL\\\\Connection->handleExceptionDuringQuery()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Propagator.php(103): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/HomePropagator.php(47): OC\\\\Files\\\\Cache\\\\Propagator->propagateChange()\\n#9 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(219): OC\\\\Files\\\\Cache\\\\HomePropagator->propagateChange()\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Trashbin.php(345): OC\\\\Files\\\\Cache\\\\Updater->renameFromStorage()\\n#11 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(199): OCA\\\\Files_Trashbin\\\\Trashbin::move2trash()\\n#12 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(124): OCA\\\\Files_Trashbin\\\\Storage->doDelete()\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1226): OCA\\\\Files_Trashbin\\\\Storage->unlink()\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(776): OC\\\\Files\\\\View->basicOperation()\\n#15 \\\/var\\\/www\\\/owncloud\\\/lib\\\/public\\\/Events\\\/EventEmitterTrait.php(50): OC\\\\Files\\\\View->OC\\\\Files\\\\{closure}(*** sensitive parameters replaced ***)\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(786): OC\\\\Files\\\\View->emittingCall()\\n#17 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(424): OC\\\\Files\\\\View->unlink()\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Tree.php(179): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->delete()\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(281): Sabre\\\\DAV\\\\Tree->delete()\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpDelete()\\n#21 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#22 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#23 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Server.php(334): Sabre\\\\DAV\\\\Server->start()\\n#24 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#25 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#26 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractPostgreSQLDriver.php\",\"Line\":52}"}
{"reqId":"uAO98nlIuzkwByGwncNi","level":4,"time":"2021-07-28T11:30:24+00:00","remoteAddr":"172.30.12.1","user":"admin","app":"webdav","method":"DELETE","url":"\/owncloud\/remote.php\/dav\/files\/admin\/New%20folder\/20200507_181748.jpg","message":"Caused by: {\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\\nDETAIL:  Process 9153 waits for ShareLock on transaction 140555; blocked by process 9152.\\nProcess 9152 waits for ShareLock on transaction 140562; blocked by process 9153.\\nHINT:  See server log for query details.\\nCONTEXT:  while locking tuple (7,9) in relation \\\"oc_filecache\\\"\",\"Code\":\"40P01\",\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php(114): Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception::new()\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1513): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Propagator.php(103): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/HomePropagator.php(47): OC\\\\Files\\\\Cache\\\\Propagator->propagateChange()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(219): OC\\\\Files\\\\Cache\\\\HomePropagator->propagateChange()\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Trashbin.php(345): OC\\\\Files\\\\Cache\\\\Updater->renameFromStorage()\\n#9 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(199): OCA\\\\Files_Trashbin\\\\Trashbin::move2trash()\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(124): OCA\\\\Files_Trashbin\\\\Storage->doDelete()\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1226): OCA\\\\Files_Trashbin\\\\Storage->unlink()\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(776): OC\\\\Files\\\\View->basicOperation()\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/public\\\/Events\\\/EventEmitterTrait.php(50): OC\\\\Files\\\\View->OC\\\\Files\\\\{closure}(*** sensitive parameters replaced ***)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(786): OC\\\\Files\\\\View->emittingCall()\\n#15 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(424): OC\\\\Files\\\\View->unlink()\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Tree.php(179): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->delete()\\n#17 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(281): Sabre\\\\DAV\\\\Tree->delete()\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpDelete()\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#21 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Server.php(334): Sabre\\\\DAV\\\\Server->start()\\n#22 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#23 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#24 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDO\\\/Exception.php\",\"Line\":18}"}
{"reqId":"uAO98nlIuzkwByGwncNi","level":4,"time":"2021-07-28T11:30:24+00:00","remoteAddr":"172.30.12.1","user":"admin","app":"webdav","method":"DELETE","url":"\/owncloud\/remote.php\/dav\/files\/admin\/New%20folder\/20200507_181748.jpg","message":"Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\\nDETAIL:  Process 9153 waits for ShareLock on transaction 140555; blocked by process 9152.\\nProcess 9152 waits for ShareLock on transaction 140562; blocked by process 9153.\\nHINT:  See server log for query details.\\nCONTEXT:  while locking tuple (7,9) in relation \\\"oc_filecache\\\"\",\"Code\":\"40P01\",\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php(112): PDOStatement->execute()\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1513): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Propagator.php(103): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/HomePropagator.php(47): OC\\\\Files\\\\Cache\\\\Propagator->propagateChange()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(219): OC\\\\Files\\\\Cache\\\\HomePropagator->propagateChange()\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Trashbin.php(345): OC\\\\Files\\\\Cache\\\\Updater->renameFromStorage()\\n#9 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(199): OCA\\\\Files_Trashbin\\\\Trashbin::move2trash()\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(124): OCA\\\\Files_Trashbin\\\\Storage->doDelete()\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1226): OCA\\\\Files_Trashbin\\\\Storage->unlink()\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(776): OC\\\\Files\\\\View->basicOperation()\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/public\\\/Events\\\/EventEmitterTrait.php(50): OC\\\\Files\\\\View->OC\\\\Files\\\\{closure}(*** sensitive parameters replaced ***)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(786): OC\\\\Files\\\\View->emittingCall()\\n#15 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(424): OC\\\\Files\\\\View->unlink()\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Tree.php(179): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->delete()\\n#17 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(281): Sabre\\\\DAV\\\\Tree->delete()\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpDelete()\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#21 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Server.php(334): Sabre\\\\DAV\\\\Server->start()\\n#22 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#23 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#24 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php\",\"Line\":112}"}
{"reqId":"mx13pe7KRC0OUFC4Jbfh","level":4,"time":"2021-07-28T11:30:25+00:00","remoteAddr":"172.30.12.1","user":"admin","app":"webdav","method":"DELETE","url":"\/owncloud\/remote.php\/dav\/files\/admin\/New%20folder\/20200508_124147.jpg","message":"Exception: An exception occurred while executing 'UPDATE \"oc_filecache\" SET \"mtime\" = GREATEST(\"mtime\", ?), \"etag\" = ? WHERE (\"storage\" = ?) AND (\"path_hash\" IN ('d41d8cd98f00b204e9800998ecf8427e', '45b963397aa40d4a0063e0d85e4fe7a1', '68a4509e71999ad6fce3444c6fc9cae5'))' with params [1627471823, \"61013fcf7ba78\", 1]:\n\nSQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\nDETAIL:  Process 9155 waits for ShareLock on transaction 140555; blocked by process 9152.\nProcess 9152 waits for ShareLock on transaction 140564; blocked by process 9155.\nHINT:  See server log for query details.\nCONTEXT:  while rechecking updated tuple (7,9) in relation \"oc_filecache\": {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DeadlockException\",\"Message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = GREATEST(\\\"mtime\\\", ?), \\\"etag\\\" = ? WHERE (\\\"storage\\\" = ?) AND (\\\"path_hash\\\" IN ('d41d8cd98f00b204e9800998ecf8427e', '45b963397aa40d4a0063e0d85e4fe7a1', '68a4509e71999ad6fce3444c6fc9cae5'))' with params [1627471823, \\\"61013fcf7ba78\\\", 1]:\\n\\nSQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\\nDETAIL:  Process 9155 waits for ShareLock on transaction 140555; blocked by process 9152.\\nProcess 9152 waits for ShareLock on transaction 140564; blocked by process 9155.\\nHINT:  See server log for query details.\\nCONTEXT:  while rechecking updated tuple (7,9) in relation \\\"oc_filecache\\\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(182): Doctrine\\\\DBAL\\\\Driver\\\\AbstractPostgreSQLDriver->convertException()\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(159): Doctrine\\\\DBAL\\\\DBALException::wrapException()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(2212): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1524): Doctrine\\\\DBAL\\\\Connection->handleExceptionDuringQuery()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Propagator.php(103): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/HomePropagator.php(47): OC\\\\Files\\\\Cache\\\\Propagator->propagateChange()\\n#9 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(219): OC\\\\Files\\\\Cache\\\\HomePropagator->propagateChange()\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Trashbin.php(345): OC\\\\Files\\\\Cache\\\\Updater->renameFromStorage()\\n#11 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(199): OCA\\\\Files_Trashbin\\\\Trashbin::move2trash()\\n#12 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(124): OCA\\\\Files_Trashbin\\\\Storage->doDelete()\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1226): OCA\\\\Files_Trashbin\\\\Storage->unlink()\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(776): OC\\\\Files\\\\View->basicOperation()\\n#15 \\\/var\\\/www\\\/owncloud\\\/lib\\\/public\\\/Events\\\/EventEmitterTrait.php(50): OC\\\\Files\\\\View->OC\\\\Files\\\\{closure}(*** sensitive parameters replaced ***)\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(786): OC\\\\Files\\\\View->emittingCall()\\n#17 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(424): OC\\\\Files\\\\View->unlink()\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Tree.php(179): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->delete()\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(281): Sabre\\\\DAV\\\\Tree->delete()\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpDelete()\\n#21 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#22 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#23 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Server.php(334): Sabre\\\\DAV\\\\Server->start()\\n#24 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#25 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#26 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractPostgreSQLDriver.php\",\"Line\":52}"}
{"reqId":"mx13pe7KRC0OUFC4Jbfh","level":4,"time":"2021-07-28T11:30:25+00:00","remoteAddr":"172.30.12.1","user":"admin","app":"webdav","method":"DELETE","url":"\/owncloud\/remote.php\/dav\/files\/admin\/New%20folder\/20200508_124147.jpg","message":"Caused by: {\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\\nDETAIL:  Process 9155 waits for ShareLock on transaction 140555; blocked by process 9152.\\nProcess 9152 waits for ShareLock on transaction 140564; blocked by process 9155.\\nHINT:  See server log for query details.\\nCONTEXT:  while rechecking updated tuple (7,9) in relation \\\"oc_filecache\\\"\",\"Code\":\"40P01\",\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php(114): Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception::new()\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1513): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Propagator.php(103): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/HomePropagator.php(47): OC\\\\Files\\\\Cache\\\\Propagator->propagateChange()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(219): OC\\\\Files\\\\Cache\\\\HomePropagator->propagateChange()\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Trashbin.php(345): OC\\\\Files\\\\Cache\\\\Updater->renameFromStorage()\\n#9 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(199): OCA\\\\Files_Trashbin\\\\Trashbin::move2trash()\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(124): OCA\\\\Files_Trashbin\\\\Storage->doDelete()\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1226): OCA\\\\Files_Trashbin\\\\Storage->unlink()\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(776): OC\\\\Files\\\\View->basicOperation()\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/public\\\/Events\\\/EventEmitterTrait.php(50): OC\\\\Files\\\\View->OC\\\\Files\\\\{closure}(*** sensitive parameters replaced ***)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(786): OC\\\\Files\\\\View->emittingCall()\\n#15 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(424): OC\\\\Files\\\\View->unlink()\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Tree.php(179): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->delete()\\n#17 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(281): Sabre\\\\DAV\\\\Tree->delete()\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpDelete()\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#21 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Server.php(334): Sabre\\\\DAV\\\\Server->start()\\n#22 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#23 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#24 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDO\\\/Exception.php\",\"Line\":18}"}
{"reqId":"mx13pe7KRC0OUFC4Jbfh","level":4,"time":"2021-07-28T11:30:25+00:00","remoteAddr":"172.30.12.1","user":"admin","app":"webdav","method":"DELETE","url":"\/owncloud\/remote.php\/dav\/files\/admin\/New%20folder\/20200508_124147.jpg","message":"Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\\nDETAIL:  Process 9155 waits for ShareLock on transaction 140555; blocked by process 9152.\\nProcess 9152 waits for ShareLock on transaction 140564; blocked by process 9155.\\nHINT:  See server log for query details.\\nCONTEXT:  while rechecking updated tuple (7,9) in relation \\\"oc_filecache\\\"\",\"Code\":\"40P01\",\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php(112): PDOStatement->execute()\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1513): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Propagator.php(103): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/HomePropagator.php(47): OC\\\\Files\\\\Cache\\\\Propagator->propagateChange()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(219): OC\\\\Files\\\\Cache\\\\HomePropagator->propagateChange()\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Trashbin.php(345): OC\\\\Files\\\\Cache\\\\Updater->renameFromStorage()\\n#9 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(199): OCA\\\\Files_Trashbin\\\\Trashbin::move2trash()\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(124): OCA\\\\Files_Trashbin\\\\Storage->doDelete()\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1226): OCA\\\\Files_Trashbin\\\\Storage->unlink()\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(776): OC\\\\Files\\\\View->basicOperation()\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/public\\\/Events\\\/EventEmitterTrait.php(50): OC\\\\Files\\\\View->OC\\\\Files\\\\{closure}(*** sensitive parameters replaced ***)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(786): OC\\\\Files\\\\View->emittingCall()\\n#15 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(424): OC\\\\Files\\\\View->unlink()\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Tree.php(179): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->delete()\\n#17 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(281): Sabre\\\\DAV\\\\Tree->delete()\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpDelete()\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#21 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Server.php(334): Sabre\\\\DAV\\\\Server->start()\\n#22 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#23 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#24 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php\",\"Line\":112}"}
{"reqId":"G7AuFTVZvxFowgq2JAge","level":4,"time":"2021-07-28T11:30:26+00:00","remoteAddr":"172.30.12.1","user":"admin","app":"webdav","method":"DELETE","url":"\/owncloud\/remote.php\/dav\/files\/admin\/New%20folder\/20200508_114031%20(2).jpg","message":"Exception: An exception occurred while executing 'UPDATE \"oc_filecache\" SET \"mtime\" = GREATEST(\"mtime\", ?), \"etag\" = ? WHERE (\"storage\" = ?) AND (\"path_hash\" IN ('d41d8cd98f00b204e9800998ecf8427e', '45b963397aa40d4a0063e0d85e4fe7a1', '68a4509e71999ad6fce3444c6fc9cae5'))' with params [1627471823, \"61013fcf89736\", 1]:\n\nSQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\nDETAIL:  Process 9156 waits for ShareLock on transaction 140555; blocked by process 9152.\nProcess 9152 waits for ShareLock on transaction 140571; blocked by process 9156.\nHINT:  See server log for query details.\nCONTEXT:  while rechecking updated tuple (7,9) in relation \"oc_filecache\": {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DeadlockException\",\"Message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = GREATEST(\\\"mtime\\\", ?), \\\"etag\\\" = ? WHERE (\\\"storage\\\" = ?) AND (\\\"path_hash\\\" IN ('d41d8cd98f00b204e9800998ecf8427e', '45b963397aa40d4a0063e0d85e4fe7a1', '68a4509e71999ad6fce3444c6fc9cae5'))' with params [1627471823, \\\"61013fcf89736\\\", 1]:\\n\\nSQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\\nDETAIL:  Process 9156 waits for ShareLock on transaction 140555; blocked by process 9152.\\nProcess 9152 waits for ShareLock on transaction 140571; blocked by process 9156.\\nHINT:  See server log for query details.\\nCONTEXT:  while rechecking updated tuple (7,9) in relation \\\"oc_filecache\\\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(182): Doctrine\\\\DBAL\\\\Driver\\\\AbstractPostgreSQLDriver->convertException()\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(159): Doctrine\\\\DBAL\\\\DBALException::wrapException()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(2212): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1524): Doctrine\\\\DBAL\\\\Connection->handleExceptionDuringQuery()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Propagator.php(103): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/HomePropagator.php(47): OC\\\\Files\\\\Cache\\\\Propagator->propagateChange()\\n#9 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(219): OC\\\\Files\\\\Cache\\\\HomePropagator->propagateChange()\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Trashbin.php(345): OC\\\\Files\\\\Cache\\\\Updater->renameFromStorage()\\n#11 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(199): OCA\\\\Files_Trashbin\\\\Trashbin::move2trash()\\n#12 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(124): OCA\\\\Files_Trashbin\\\\Storage->doDelete()\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1226): OCA\\\\Files_Trashbin\\\\Storage->unlink()\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(776): OC\\\\Files\\\\View->basicOperation()\\n#15 \\\/var\\\/www\\\/owncloud\\\/lib\\\/public\\\/Events\\\/EventEmitterTrait.php(50): OC\\\\Files\\\\View->OC\\\\Files\\\\{closure}(*** sensitive parameters replaced ***)\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(786): OC\\\\Files\\\\View->emittingCall()\\n#17 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(424): OC\\\\Files\\\\View->unlink()\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Tree.php(179): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->delete()\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(281): Sabre\\\\DAV\\\\Tree->delete()\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpDelete()\\n#21 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#22 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#23 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Server.php(334): Sabre\\\\DAV\\\\Server->start()\\n#24 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#25 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#26 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractPostgreSQLDriver.php\",\"Line\":52}"}
{"reqId":"G7AuFTVZvxFowgq2JAge","level":4,"time":"2021-07-28T11:30:26+00:00","remoteAddr":"172.30.12.1","user":"admin","app":"webdav","method":"DELETE","url":"\/owncloud\/remote.php\/dav\/files\/admin\/New%20folder\/20200508_114031%20(2).jpg","message":"Caused by: {\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\\nDETAIL:  Process 9156 waits for ShareLock on transaction 140555; blocked by process 9152.\\nProcess 9152 waits for ShareLock on transaction 140571; blocked by process 9156.\\nHINT:  See server log for query details.\\nCONTEXT:  while rechecking updated tuple (7,9) in relation \\\"oc_filecache\\\"\",\"Code\":\"40P01\",\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php(114): Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception::new()\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1513): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Propagator.php(103): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/HomePropagator.php(47): OC\\\\Files\\\\Cache\\\\Propagator->propagateChange()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(219): OC\\\\Files\\\\Cache\\\\HomePropagator->propagateChange()\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Trashbin.php(345): OC\\\\Files\\\\Cache\\\\Updater->renameFromStorage()\\n#9 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(199): OCA\\\\Files_Trashbin\\\\Trashbin::move2trash()\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(124): OCA\\\\Files_Trashbin\\\\Storage->doDelete()\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1226): OCA\\\\Files_Trashbin\\\\Storage->unlink()\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(776): OC\\\\Files\\\\View->basicOperation()\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/public\\\/Events\\\/EventEmitterTrait.php(50): OC\\\\Files\\\\View->OC\\\\Files\\\\{closure}(*** sensitive parameters replaced ***)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(786): OC\\\\Files\\\\View->emittingCall()\\n#15 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(424): OC\\\\Files\\\\View->unlink()\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Tree.php(179): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->delete()\\n#17 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(281): Sabre\\\\DAV\\\\Tree->delete()\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpDelete()\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#21 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Server.php(334): Sabre\\\\DAV\\\\Server->start()\\n#22 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#23 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#24 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDO\\\/Exception.php\",\"Line\":18}"}
{"reqId":"G7AuFTVZvxFowgq2JAge","level":4,"time":"2021-07-28T11:30:26+00:00","remoteAddr":"172.30.12.1","user":"admin","app":"webdav","method":"DELETE","url":"\/owncloud\/remote.php\/dav\/files\/admin\/New%20folder\/20200508_114031%20(2).jpg","message":"Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\\nDETAIL:  Process 9156 waits for ShareLock on transaction 140555; blocked by process 9152.\\nProcess 9152 waits for ShareLock on transaction 140571; blocked by process 9156.\\nHINT:  See server log for query details.\\nCONTEXT:  while rechecking updated tuple (7,9) in relation \\\"oc_filecache\\\"\",\"Code\":\"40P01\",\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php(112): PDOStatement->execute()\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1513): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Propagator.php(103): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/HomePropagator.php(47): OC\\\\Files\\\\Cache\\\\Propagator->propagateChange()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(219): OC\\\\Files\\\\Cache\\\\HomePropagator->propagateChange()\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Trashbin.php(345): OC\\\\Files\\\\Cache\\\\Updater->renameFromStorage()\\n#9 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(199): OCA\\\\Files_Trashbin\\\\Trashbin::move2trash()\\n#10 \\\/var\\\/www\\\/owncloud\\\/apps\\\/files_trashbin\\\/lib\\\/Storage.php(124): OCA\\\\Files_Trashbin\\\\Storage->doDelete()\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(1226): OCA\\\\Files_Trashbin\\\\Storage->unlink()\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(776): OC\\\\Files\\\\View->basicOperation()\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/public\\\/Events\\\/EventEmitterTrait.php(50): OC\\\\Files\\\\View->OC\\\\Files\\\\{closure}(*** sensitive parameters replaced ***)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Files\\\/View.php(786): OC\\\\Files\\\\View->emittingCall()\\n#15 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(424): OC\\\\Files\\\\View->unlink()\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Tree.php(179): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->delete()\\n#17 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(281): Sabre\\\\DAV\\\\Tree->delete()\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpDelete()\\n#19 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#20 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#21 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Server.php(334): Sabre\\\\DAV\\\\Server->start()\\n#22 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#23 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#24 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php\",\"Line\":112}"}
{"reqId":"fFMesUljqX3tM70Uv5Kd","level":3,"time":"2021-07-28T11:30:49+00:00","remoteAddr":"172.30.12.1","user":"--","app":"PHP","method":"GET","url":"\/owncloud\/index.php","message":"include(layout.noscript.warning.php): failed to open stream: No such file or directory at \/var\/www\/owncloud\/apps\/theme-qnap\/core\/templates\/layout.guest.php#32"}
{"reqId":"fFMesUljqX3tM70Uv5Kd","level":3,"time":"2021-07-28T11:30:49+00:00","remoteAddr":"172.30.12.1","user":"--","app":"PHP","method":"GET","url":"\/owncloud\/index.php","message":"include(): Failed opening 'layout.noscript.warning.php' for inclusion (include_path='\/var\/www\/owncloud\/apps:\/var\/www\/owncloud\/custom') at \/var\/www\/owncloud\/apps\/theme-qnap\/core\/templates\/layout.guest.php#32"}

• Despite these messages, the folder was empty afterwards, and all files were found in the trashbin, as expected.

[wkloucek]

Looks like a QNAP specific error (caused by bad timing, RAID being slow!?). I tested it on my local machine and it just works fine but that also uses SSD... On the QNAP devices it also just happens sometimes...

The database error is:

db_1        | 2021-08-10 07:54:45.169 UTC [657] ERROR:  duplicate key value violates unique constraint "fs_storage_path_hash"
db_1        | 2021-08-10 07:54:45.169 UTC [657] DETAIL:  Key (storage, path_hash)=(1, 3014a771cbe30761f2e9ff3272110dbf) already exists.
db_1        | 2021-08-10 07:54:45.169 UTC [657] STATEMENT:  INSERT INTO "oc_filecache" ("mimepart", "mimetype", "mtime", "size", "etag", "storage_mtime", "permissions", "checksum", "parent", "path_hash", "path", "name", "storage") VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
db_1        | 2021-08-10 07:54:45.298 UTC [657] ERROR:  current transaction is aborted, commands ignored until end of transaction block
db_1        | 2021-08-10 07:54:45.298 UTC [657] STATEMENT:  UPDATE "oc_filecache" SET "mimepart" = $1, "mimetype" = $2, "mtime" = $3, "size" = $4, "etag" = $5, "storage_mtime" = $6, "permissions" = $7, "checksum" = $8, "parent" = $9, "path_hash" = $10, "path" = $11, "name" = $12, "storage" = $13 WHERE ("storage" = '1') AND ("path_hash" = '3014a771cbe30761f2e9ff3272110dbf')

EDIT: After further testing, I couldn't reproduce this anymore on any of the QNAP devices.

[wkloucek]

@JammingBen @janackermann have you seen an error like this before? (you have been experimenting with persistent connections on PostgreSQL)

db_1        | 2021-08-10 07:54:45.169 UTC [657] ERROR:  duplicate key value violates unique constraint "fs_storage_path_hash"
db_1        | 2021-08-10 07:54:45.169 UTC [657] DETAIL:  Key (storage, path_hash)=(1, 3014a771cbe30761f2e9ff3272110dbf) already exists.
db_1        | 2021-08-10 07:54:45.169 UTC [657] STATEMENT:  INSERT INTO "oc_filecache" ("mimepart", "mimetype", "mtime", "size", "etag", "storage_mtime", "permissions", "checksum", "parent", "path_hash", "path", "name", "storage") VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
db_1        | 2021-08-10 07:54:45.298 UTC [657] ERROR:  current transaction is aborted, commands ignored until end of transaction block
db_1        | 2021-08-10 07:54:45.298 UTC [657] STATEMENT:  UPDATE "oc_filecache" SET "mimepart" = $1, "mimetype" = $2, "mtime" = $3, "size" = $4, "etag" = $5, "storage_mtime" = $6, "permissions" = $7, "checksum" = $8, "parent" = $9, "path_hash" = $10, "path" = $11, "name" = $12, "storage" = $13 WHERE ("storage" = '1') AND ("path_hash" = '3014a771cbe30761f2e9ff3272110dbf')

[jnweiger]

Retested with https://github.com/owncloud/qnap-packaging/releases/download/v10.8.0.0-rc3/ several times on both the slow arm machine and the faster x86 machine.
Cannot reproduce on any of the machines today. 🤷‍♂️

@oC-Chriddel I'd suggest this is not a blocker, on the condition that we give recommendation against using the slower arm hardware with owncloud..