owncloud / qnap Goto Github PK

View Code? Open in Web Editor NEW

3.0 20.0 3.0 320 KB

App for qnap - license defines number of allowed users - this app disables those over the limit

License: GNU General Public License v2.0

PHP 28.82% Makefile 4.43% JavaScript 16.17% Starlark 50.58%

owncloud-app

qnap's Introduction

QNAP license app for ownCloud

qnap's People

Contributors

Stargazers

Watchers

Forkers

xtuden-com stjordanis

qnap's Issues

ownCloud only working after a reboot

Description

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.

Steps to reproduce

check, that you can use the ownCloud app at https://<your-device-ip>/owncloud
stop the ownCloud app
start the ownCloud app
see an error on https://<your-device-ip>/owncloud
reboot the device
ownCloud app is usable

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.

Analysis

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

[QA] version number of the owncloud/qnap app mismatches

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

Github release has v1.4.0

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:

The version numbers match, and get incremented after every update.
The version of this app should be also visible in the ownCloud_10.8.0_*.qpkg package names. (E.g. as ownCloud10.8.0_q1.4.0_arm.qpkg)

[QA] First login of admin user fails using HTTPS://

Seen with owncloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg using Firefox 89.0.2

with a fresh browser session (no cookies) visit https://10.90.4.178/owncloud
Enter credentials for user admin.
The browser redirects to https://10.90.4.178/owncloud/apps/files, but violates the HTTP protocol:
The Request has 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

[QA] more redundancy needed in QR codes to compensate for mouse cursor

Seen with owncloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg

The login screen shows QR codes that do not work unless enlarged.
Users can enlarge them by a) hovering the mouse over the apple or android logo, or b) hovering the mouse over the QR code itself.
In case a) the QR codes work flawless, in case b) the QR codes work too, but sometimes one needs to move the mouse a bit.

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.

[QA] the owncloud server randomly disappears

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 QNAP 10.9.1.0

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

[QA] Cannot change loglevel

Seen with owncloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg

The loglevel is per default at: "Warnings, errors and fatal issues"
The admin can change this in the general tab and receives a green confirmation message "Updated log level"

Contrary to this indication, the log level was not changed.
Reloading the page shows that we are still at:

Root cause: owncloud/core#38535

Expected behaviour: the log-level can be adjusted as advertised.

[QA] DNS resolver does not work in the onwcloud container

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.

App not signed.

Technical information

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.

Results

qnap
- EXCEPTION
  - OC\IntegrityCheck\Exceptions\MissingSignatureException
  - Signature data not found.

Raw output

Array
(
[qnap] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\MissingSignatureException
[message] => Signature data not found.
)

)

Taken from https://github.com/owncloud-docker/qnap

not compatible with oc 10.8

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)

running occ commands does not work as documented

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

[QA] QNAP App Container Station does not show a running ownCloud container

Seen with owncloud for QNAP 10.8.0 RC1 from ownCloud_10.8.0_arm-x41.qpkg

Install ownCloud -> verify it is running, by logging in admin user.
Visit App Center -> Container Station
the running ownCloud container is not visible in the Container Station dialog.

Expected behaviour: ownCloud can be seen there, (or remove the Container Station dependency from ownCloud)

[QA] Error messages while deleting files

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.

[QA] Filesystem check crashes the machines

Seen on both QNAP machines in the office:

Admin logs in,
(Sometimes) A requester appears:
"Check Now" kills the machine. No more HTTP or SSH connections.

A powercycle brings back the system.

QNAP Testplan

Template: https://github.com/owncloud/QA/blob/master/Integrations/Test_Plan_QNAP.md

Run the testplan template twice: first x86, second arm7, see below.

[QA] link in license exceded mail includes trailing `.`

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

[QA] admin user gets disabled, when user limit is reached

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

missing X-Forwarded-Proto configuration

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.

Readme.md needs improvement

@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 are treated as normal users

Guest users:

must not count as normal users (you can always have unlimited guest users)
must never be deactivated if the licensed user count is exceeded

Check allowed user count in License

[QA] owncloud apps qnap and theme-qnap are not signed, and other admin warnings

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.

Reduce initial user limit to 5 users

Initial user limit must be 5 users.

Rework texts and ensure translation

Guests app does not work due to incorrect forwarding

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.

[QA] config setting overwrite.cli.url does not match

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.)

[QA] qpkg package of RC1 should have RC1 in its name

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.

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.