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)