Issues

Sabre\DAV\Exception\BadRequest: Expected filesize of 1153433600 bytes but read (from Nextcloud client) and wrote (to Nextcloud storage) 0 bytes. Could either be a network problem on the sending side or a problem writing to the storage on the server side.

Reason: Nextcloud docker v 24.0.3-apache is based on docker php:8.0-apache-bullseye.

In the meantime Apache change default LimitRequestBody value from unlimited to 1GB: LimitRequestBody Directive

compatibility: In Apache HTTP Server 2.4.53 and earlier, the default value was 0 (unlimited)

Apache images built after ~mid June 2022 introduce 1GB upload limit #1796

NextCloud v20 in Docker. Nginx rev proxy.

./occ.sh security:bruteforce:reset 127.0.0.1

Install app: Brute-force IP whitelist Add whitelist IPs under security settings –> Brute-Force IP-Whitelist

Fatal	webdav	Doctrine\DBAL\Exception\DeadlockException: An exception occurred while executing 'UPDATE "oc_filecache" SET "mtime" = GREATEST("mtime", ?), "etag" = ? WHERE ("storage" = ?)
...
SQLSTATE[40P01]: Deadlock detected: 7 ERROR: deadlock detected DETAIL: Process 18318 waits for ShareLock on transaction 6602719; blocked by process 18319. Process 18319 waits for ShareLock on transaction 6602716; blocked by process 18318. HINT: See server log for query details. CONTEXT: while rechecking updated tuple (2338,25) in relation "oc_filecache"

db_1          | 2020-12-07 16:40:03.260 UTC [18491] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
db_1          | 2020-12-07 16:40:03.260 UTC [18491] DETAIL:  Key (fileid)=(114826) already exists.
db_1          | 2020-12-07 16:40:03.260 UTC [18491] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)

dont hold a transaction during the move to trash