owncloud / qnap Goto Github PK
View Code? Open in Web Editor NEWApp for qnap - license defines number of allowed users - this app disables those over the limit
License: GNU General Public License v2.0
App for qnap - license defines number of allowed users - this app disables those over the limit
License: GNU General Public License v2.0
Device: TS-431X
Firmware: 5.0.0.1932 Build 20220129
ownCloud app: across all versions
The ownCloud app is usable when not stopped and started during device runtime. But if one stops and starts the ownCloud app, it is no longer usable. In order to make it work again, the device needs to be rebooted.
https://<your-device-ip>/owncloud
https://<your-device-ip>/owncloud
Instead of stopping and starting ownCloud in step 2) and 3) you can just install the ownCloud app again. It will have the same effect.
After a reboot the iptables rules look like this:
$ iptables -S
-P INPUT ACCEPT
-P FORWARD ACCEPT
-P OUTPUT ACCEPT
-N CSFORWARD
-N DOCKER
-N DOCKER-ISOLATION-STAGE-1
-N DOCKER-ISOLATION-STAGE-2
-N DOCKER-USER
-N SYSDOCKER
-N SYSDOCKER-ISOLATION-STAGE-1
-N SYSDOCKER-ISOLATION-STAGE-2
-N SYSDOCKER-USER
-A FORWARD -j SYSDOCKER-USER
-A FORWARD -j SYSDOCKER-ISOLATION-STAGE-1
-A FORWARD -o br-51e490a6b23f -m conntrack --ctstate RELATED,ESTABLISHED -j ACCEPT
-A FORWARD -o br-51e490a6b23f -j SYSDOCKER
-A FORWARD -i br-51e490a6b23f ! -o br-51e490a6b23f -j ACCEPT
-A FORWARD -i br-51e490a6b23f -o br-51e490a6b23f -j ACCEPT
-A FORWARD -j DOCKER-USER
-A FORWARD -j DOCKER-ISOLATION-STAGE-1
-A FORWARD -o lxcbr0 -m conntrack --ctstate RELATED,ESTABLISHED -j ACCEPT
-A FORWARD -o lxcbr0 -j DOCKER
-A FORWARD -i lxcbr0 ! -o lxcbr0 -j ACCEPT
-A FORWARD -i lxcbr0 -o lxcbr0 -j ACCEPT
-A FORWARD -o docker0 -m conntrack --ctstate RELATED,ESTABLISHED -j ACCEPT
-A FORWARD -o docker0 -j SYSDOCKER
-A FORWARD -i docker0 ! -o docker0 -j ACCEPT
-A FORWARD -i docker0 -o docker0 -j ACCEPT
-A FORWARD -j CSFORWARD
-A OUTPUT -m set --match-set BRNOIPSET src,dst -j DROP
-A CSFORWARD -i br-49db839ef112 -o br-49db839ef112 -j ACCEPT
-A CSFORWARD -i br-1c27f5ce4a89 -o br-1c27f5ce4a89 -j ACCEPT
-A CSFORWARD -i lxcbr0 -o lxcbr0 -j ACCEPT
-A CSFORWARD -i docker0 -o docker0 -j ACCEPT
-A CSFORWARD -o docker0 -m conntrack --ctstate INVALID,NEW -j DROP
-A CSFORWARD -o lxcbr0 -m conntrack --ctstate INVALID,NEW -j DROP
-A CSFORWARD -o br-1c27f5ce4a89 -m conntrack --ctstate INVALID,NEW -j DROP
-A CSFORWARD -o br-49db839ef112 -m conntrack --ctstate INVALID,NEW -j DROP
-A DOCKER-ISOLATION-STAGE-1 -i lxcbr0 ! -o lxcbr0 -j DOCKER-ISOLATION-STAGE-2
-A DOCKER-ISOLATION-STAGE-1 -j RETURN
-A DOCKER-ISOLATION-STAGE-2 -o lxcbr0 -j DROP
-A DOCKER-ISOLATION-STAGE-2 -j RETURN
-A DOCKER-USER
-A DOCKER-USER -j RETURN
-A SYSDOCKER -d 172.30.52.4/32 ! -i br-51e490a6b23f -o br-51e490a6b23f -p tcp -m tcp --dport 8080 -j ACCEPT
-A SYSDOCKER-ISOLATION-STAGE-1 -i br-51e490a6b23f ! -o br-51e490a6b23f -j SYSDOCKER-ISOLATION-STAGE-2
-A SYSDOCKER-ISOLATION-STAGE-1 -i docker0 ! -o docker0 -j SYSDOCKER-ISOLATION-STAGE-2
-A SYSDOCKER-ISOLATION-STAGE-1 -j RETURN
-A SYSDOCKER-ISOLATION-STAGE-2 -o br-51e490a6b23f -j DROP
-A SYSDOCKER-ISOLATION-STAGE-2 -o docker0 -j DROP
-A SYSDOCKER-ISOLATION-STAGE-2 -j RETURN
-A SYSDOCKER-USER -j RETURN
After stopping and starting the ownCloud app, the iptables rules look like this:
$ iptables -S
-P INPUT ACCEPT
-P FORWARD ACCEPT
-P OUTPUT ACCEPT
-N CSFORWARD
-N DOCKER
-N DOCKER-ISOLATION-STAGE-1
-N DOCKER-ISOLATION-STAGE-2
-N DOCKER-USER
-N SYSDOCKER
-N SYSDOCKER-ISOLATION-STAGE-1
-N SYSDOCKER-ISOLATION-STAGE-2
-N SYSDOCKER-USER
-A FORWARD -j SYSDOCKER-USER
-A FORWARD -j SYSDOCKER-ISOLATION-STAGE-1
-A FORWARD -o br-62b303a51bf2 -m conntrack --ctstate RELATED,ESTABLISHED -j ACCEPT
-A FORWARD -o br-62b303a51bf2 -j SYSDOCKER
-A FORWARD -i br-62b303a51bf2 ! -o br-62b303a51bf2 -j ACCEPT
-A FORWARD -i br-62b303a51bf2 -o br-62b303a51bf2 -j ACCEPT
-A FORWARD -j DOCKER-USER
-A FORWARD -j DOCKER-ISOLATION-STAGE-1
-A FORWARD -o lxcbr0 -m conntrack --ctstate RELATED,ESTABLISHED -j ACCEPT
-A FORWARD -o lxcbr0 -j DOCKER
-A FORWARD -i lxcbr0 ! -o lxcbr0 -j ACCEPT
-A FORWARD -i lxcbr0 -o lxcbr0 -j ACCEPT
-A FORWARD -o docker0 -m conntrack --ctstate RELATED,ESTABLISHED -j ACCEPT
-A FORWARD -o docker0 -j SYSDOCKER
-A FORWARD -i docker0 ! -o docker0 -j ACCEPT
-A FORWARD -i docker0 -o docker0 -j ACCEPT
-A FORWARD -j CSFORWARD
-A OUTPUT -m set --match-set BRNOIPSET src,dst -j DROP
-A CSFORWARD -i br-62b303a51bf2 -o br-62b303a51bf2 -j ACCEPT
-A CSFORWARD -i br-49db839ef112 -o br-49db839ef112 -j ACCEPT
-A CSFORWARD -i br-1c27f5ce4a89 -o br-1c27f5ce4a89 -j ACCEPT
-A CSFORWARD -i lxcbr0 -o lxcbr0 -j ACCEPT
-A CSFORWARD -i docker0 -o docker0 -j ACCEPT
-A CSFORWARD -o docker0 -m conntrack --ctstate INVALID,NEW -j DROP
-A CSFORWARD -o lxcbr0 -m conntrack --ctstate INVALID,NEW -j DROP
-A CSFORWARD -o br-1c27f5ce4a89 -m conntrack --ctstate INVALID,NEW -j DROP
-A CSFORWARD -o br-49db839ef112 -m conntrack --ctstate INVALID,NEW -j DROP
-A CSFORWARD -o br-62b303a51bf2 -m conntrack --ctstate INVALID,NEW -j DROP
-A DOCKER-ISOLATION-STAGE-1 -i lxcbr0 ! -o lxcbr0 -j DOCKER-ISOLATION-STAGE-2
-A DOCKER-ISOLATION-STAGE-1 -j RETURN
-A DOCKER-ISOLATION-STAGE-2 -o lxcbr0 -j DROP
-A DOCKER-ISOLATION-STAGE-2 -j RETURN
-A DOCKER-USER
-A DOCKER-USER -j RETURN
-A SYSDOCKER -d 172.30.52.4/32 ! -i br-51e490a6b23f -o br-51e490a6b23f -p tcp -m tcp --dport 8080 -j ACCEPT
-A SYSDOCKER -d 172.30.56.4/32 ! -i br-62b303a51bf2 -o br-62b303a51bf2 -p tcp -m tcp --dport 8080 -j ACCEPT
-A SYSDOCKER-ISOLATION-STAGE-1 -i br-62b303a51bf2 ! -o br-62b303a51bf2 -j SYSDOCKER-ISOLATION-STAGE-2
-A SYSDOCKER-ISOLATION-STAGE-1 -i docker0 ! -o docker0 -j SYSDOCKER-ISOLATION-STAGE-2
-A SYSDOCKER-ISOLATION-STAGE-1 -j RETURN
-A SYSDOCKER-ISOLATION-STAGE-2 -o br-62b303a51bf2 -j DROP
-A SYSDOCKER-ISOLATION-STAGE-2 -o docker0 -j DROP
-A SYSDOCKER-ISOLATION-STAGE-2 -j RETURN
-A SYSDOCKER-USER -j RETURN
The diff shows that iptables look different. Normally only the interface name should have been changed.
16,19c16,19
< -A FORWARD -o br-51e490a6b23f -m conntrack --ctstate RELATED,ESTABLISHED -j ACCEPT
< -A FORWARD -o br-51e490a6b23f -j SYSDOCKER
< -A FORWARD -i br-51e490a6b23f ! -o br-51e490a6b23f -j ACCEPT
< -A FORWARD -i br-51e490a6b23f -o br-51e490a6b23f -j ACCEPT
---
> -A FORWARD -o br-62b303a51bf2 -m conntrack --ctstate RELATED,ESTABLISHED -j ACCEPT
> -A FORWARD -o br-62b303a51bf2 -j SYSDOCKER
> -A FORWARD -i br-62b303a51bf2 ! -o br-62b303a51bf2 -j ACCEPT
> -A FORWARD -i br-62b303a51bf2 -o br-62b303a51bf2 -j ACCEPT
31a32
> -A CSFORWARD -i br-62b303a51bf2 -o br-62b303a51bf2 -j ACCEPT
39a41
> -A CSFORWARD -o br-62b303a51bf2 -m conntrack --ctstate INVALID,NEW -j DROP
47c49,50
< -A SYSDOCKER-ISOLATION-STAGE-1 -i br-51e490a6b23f ! -o br-51e490a6b23f -j SYSDOCKER-ISOLATION-STAGE-2
---
> -A SYSDOCKER -d 172.30.56.4/32 ! -i br-62b303a51bf2 -o br-62b303a51bf2 -p tcp -m tcp --dport 8080 -j ACCEPT
> -A SYSDOCKER-ISOLATION-STAGE-1 -i br-62b303a51bf2 ! -o br-62b303a51bf2 -j SYSDOCKER-ISOLATION-STAGE-2
50c53
< -A SYSDOCKER-ISOLATION-STAGE-2 -o br-51e490a6b23f -j DROP
---
> -A SYSDOCKER-ISOLATION-STAGE-2 -o br-62b303a51bf2 -j DROP
Seen with ownCloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg (dated 2021-07-19)
The installed system has 0.2.0
This makes it diffcult to say, if a current version is actually installed. Thus all bug reports relating to this app may be considered invalid.
Expected behaviour:
ownCloud10.8.0_q1.4.0_arm.qpkg
)Seen with owncloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg
using Firefox 89.0.2
undefined
in the GET command.GET /owncloud/apps/files/ undefined
Host: 10.90.4.178
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:89.0) Gecko/20100101 Firefox/89.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Connection: keep-alive
Cookie: ocrpqgcia1h2=ik1r7rlkn1jjvbu05e7e9cp9nt; oc_sessionPassphrase=GsCkj5FBLoPUhXqtFKHjVM8Ys%2BYwXXoIhQP659jK1n7S%2BdoKxK6OI2UEbUk2n3%2FihfErb1oKoDoCmx2sVPu3b0jDnWGta%2BZNsC0xI%2FCZbjf1dbx7tiYqJiSCJya7flWo
Upgrade-Insecure-Requests: 1
With a shift reload, the request turns into GET /owncloud/apps/files/ HTTP/1.1
and succeeds.
Using http://10.90.4.178:8080/owncloud for the initial login works immeditely
Seen with owncloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg
My QR-code app needs many attempts to scan the first one, and fewert attempts with the second.
Expected behaviour: Have enough redundancy in the QR code, so that a mouse-pointer does not matter and scans would succeed on every scan.
Seen with ownCloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg
No clear steps to reproduce. Happens ca. once per day.
Today, after not using the server for several hours, it now only responds with HTTP 599.
curl -i -k http://10.90.4.178:8080/owncloud
HTTP/1.1 599 Broken
Date: Tue, 27 Jul 2021 12:06:34 GMT
Server:
X-Frame-Options: SAMEORIGIN
Content-Security-Policy: script-src 'self' 'unsafe-inline' 'unsafe-eval' ; object-src 'self' ; worker-src 'self' blob:
X-Content-Type-Options: nosniff
X-XSS-Protection: 1; mode=block
X-Robots-Tag: none
X-Frame-Options: SAMEORIGIN
X-Download-Options: noopen
X-Permitted-Cross-Domain-Policies: none
Content-Length: 0
Content-Type: text/html; charset=UTF-8
Strict-Transport-Security: max-age=0
Same on https://10.90.4.178/owncloud
Nothing is logged in /mnt/data/files/owncloud.log
Also nothing in QNAP Notificaiton Center -> View the System logs
Workaround: A reboot of the qnap host brings back owncloud.
Release Candidate for testing: https://github.com/owncloud/qnap-packaging/releases/tag/v10.9.1.0-rc2
Testplan: https://github.com/owncloud/QA/blob/master/Integrations/Test_Plan_QNAP.md
Previous version: https://github.com/owncloud/qnap-packaging/releases/tag/v10.8.0.0
Seen with owncloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg
Expected behaviour: the log-level can be adjusted as advertised.
Seen with ownCloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg
Inside the qnap host, DNS works as expected, but inside the owncloud docker container, it does not:
ssh [email protected]
[~] # ping -c 3 marketplace.owncloud.com
PING pearl.owncloud.com (5.9.68.237): 56 data bytes
64 bytes from 5.9.68.237: icmp_seq=0 ttl=58 time=7.3 ms
64 bytes from 5.9.68.237: icmp_seq=1 ttl=58 time=6.9 ms
64 bytes from 5.9.68.237: icmp_seq=2 ttl=58 time=7.1 ms
[~] # system-docker exec -ti owncloud_owncloud_1 bash
root@9ad7cdb5b5e6: /var/www/owncloud # ping -c 3 marketplace.owncloud.com
ping: marketplace.owncloud.com: Temporary failure in name resolution
root@9ad7cdb5b5e6: /var/www/owncloud # cat /etc/resolv.conf
nameserver 127.0.0.11
options ndots:0
root@9ad7cdb5b5e6: /var/www/owncloud # echo 'nameserver 1.1.1.1' >> /etc/resolv.conf
root@9ad7cdb5b5e6: /var/www/owncloud # ping -c 3 marketplace.owncloud.com
PING pearl.owncloud.com (5.9.68.237) 56(84) bytes of data.
64 bytes from pearl.owncloud.com (5.9.68.237): icmp_seq=1 ttl=57 time=7.29 ms
64 bytes from pearl.owncloud.com (5.9.68.237): icmp_seq=2 ttl=57 time=7.05 ms
64 bytes from pearl.owncloud.com (5.9.68.237): icmp_seq=3 ttl=57 time=7.35 ms
Workaround as shown above: put 1.1.1.1 into /etc/resolv.conf
This issue prevents using a hostname as a mail relay. must use IP address.
This issue prevents us from installing apps, as the DNS name marketplace.owncloud.com
is hardcoded.
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.
Array
(
[qnap] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\MissingSignatureException
[message] => Signature data not found.
)
)
)
Taken from https://github.com/owncloud-docker/qnap
PHP Fatal error: Class OCA\QNAP\QnapLicense contains 1 abstract method and must therefore be declared abstract or implement the remaining methods (OC\License\ILicense::getProtectedMethods)
I need to run an update through occ
According to the documentation, this should work with
docker exec --user www-data <owncloud-container-name> php occ <your-command>
Output of system-docker ps
gives:
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
95341d768bdb owncloud/qnap:10.8.0-amd64 "/usr/bin/entrypoint…" 45 hours ago Up 45 hours (healthy) 127.0.0.1:11409->8080/tcp owncloud_owncloud_1
7d9eb37ae8c4 redis:6.2.5-alpine "docker-entrypoint.s…" 45 hours ago Up 45 hours 6379/tcp owncloud_redis_1
1a0e8f158e7d postgres:13.4-alpine "docker-entrypoint.s…" 45 hours ago Up 45 hours 5432/tcp owncloud_db_1
But when I run
docker exec --user www-data owncloud_owncloud_1 php occ
,
I get
Error: No such container: owncloud_owncloud_1
Seen with owncloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg
Expected behaviour: ownCloud can be seen there, (or remove the Container Station dependency from ownCloud)
Seen with ownCloud for QNAP 10.8.0 from ownCloud_10.8.0_arm-x41.qpkg (2021-07-21)
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"}
Template: https://github.com/owncloud/QA/blob/master/Integrations/Test_Plan_QNAP.md
Run the testplan template twice: first x86, second arm7, see below.
Seen with ownCloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg
The link refers to https://software.qnap.com/owncloud.html. and results in a 404
Seen with ownCloud for QNAP 10.8.0 from ownCloud_10.8.0_arm-x41.qpkg
(dated 2021-07-27)
Intentionally enabled 7 users while only a 5 user license was active
A minute later the admin user got logged out :-(
root@e642b8e5209a: /var/www/owncloud # occ user:list -a enabled -a lastLogin -a email
- admin:
- enabled: false
- lastLogin: 1627400695
- email: [email protected]
- [email protected]:
- enabled: true
- lastLogin: 1627392401
- email: [email protected]
- user1:
- enabled: true
- lastLogin: 0
- email: [email protected]
- user2:
- enabled: false
- lastLogin: 0
- email: [email protected]
- user3:
- enabled: true
- lastLogin: 1627342138
- email: [email protected]
- user4:
- enabled: true
- lastLogin: 1627342197
- email: [email protected]
- user5:
- enabled: true
- lastLogin: 0
- email: [email protected]
- user6:
- enabled: true
- lastLogin: 1627342285
- email: u6@ex
The Apache proxy on the QNAP devices lacks a proper X-Forwarded-Proto setup.
cat /etc/apache-sys-proxy-ssl.conf
<VirtualHost _default_:443>
<IfModule proxy_module>
### CloudConnector3 section
Include /mnt/ext/opt/CloudConnector3/conf/apache-fastcgi.conf
</IfModule>
RequestHeader set X-Apache-Proxy "https"
Header always add Server " "
ServerName localhost
ServerAlias *.myqnapcloud.com
SSLEngine on
SSLProxyEngine on
SSLProxyCheckPeerName off
SSLProxyCheckPeerCN off
SSLHonorCipherOrder off
SSLCipherSuite EECDH+CHACHA20:EECDH+AES
SSLProtocol All -SSLv2 -SSLv3 -TLSv1 -TLSv1.1
SSLCertificateFile "/etc/stunnel/stunnel.pem"
#SSLCertificateChainFile "/etc/stunnel/uca.pem"
Proxy100Continue off
ProxyRequests Off
ProxyBadHeader Ignore
ProxyPreserveHost On
<directory proxy:*>
Require all granted
</directory>
RewriteEngine on
RewriteCond %{HTTP_HOST} ^([^:]+)(:[0-9]+)?$
RewriteRule (^\/gq\/v1\/.*) /scale-out-manager$1 [PT,L]
Include /etc/default_config/apache-alias.conf
...
Include /etc/app_proxy.conf
...
</VirtualHost>
has a RequestHeader set X-Apache-Proxy "https"
directive and ownCloud would need a RequestHeader set X-Forwarded-Proto "https"
directive to function properly.
@DeepDiver1975
I know that this is always a p* in the a* 😃 but could you improve a litte bit the current readme.md?
Maybe 2 sentences what it is about?
It is very hard to guess what is meant with" QNAP license app for ownCloud".
Because there is a info.xml file present and filled with data, there is the possibility that this app could be published to marketplace at some time. A improved readme could help identifying what this app is about.
Sincerely,
Your Chief Continuity Officer
🍻
Guest users:
Seen with ownCloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg
The code integrity checker complains:
Results
=======
- qnap
- EXCEPTION
- OC\IntegrityCheck\Exceptions\MissingSignatureException
- Signature data not found.
- theme-qnap
- EXCEPTION
- OC\IntegrityCheck\Exceptions\MissingSignatureException
- Signature data not found.
Initial user limit must be 5 users.
After creating a share for a guest user, he or she will receive the email and can also call up the link for setting the password, but the automatic forwarding (after clicking on "Set Password") does not work because it is apparently redirected from https to http.
I suspect the password is not saved in the database because the previously set password does not work after calling the login link.
Seen with with ownCloud for QNAP 10.8.0 from ownCloud_10.8.0_arm-x41.qpkg (dated 2021-07-27)
After a fresh install, config.php has this:
...
'overwritewebroot' => '/owncloud',
'overwrite.cli.url' => 'http://localhost/',
'htaccess.RewriteBase' => '/',
...
Expected behaviour: overwrite.cli.url should say either https://10.90.4.178/owncloud
or http://10.90.4.178:8080/owncloud
(The trusted_domains setting in config.php looks odd with the port number included, but it is not effective. It is a wildcard setting as defined in overwrite.config.php -- GOOD.)
Seen with owncloud for QNAP 10.8.0 RC1
The package is currently named ownCloud_10.8.0_arm-x41.qpkg
Expected behaviour: Pre-release version (beta, RC) are clearly marked as such.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.