meta data for this page
  •  

This is an old revision of the document!


Issues

Too many requests

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

ERROR: deadlock detected

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