Logged out of Nextcloud on a regular basis

[KenBW2]

Steps to reproduce

1. Log in to Nextcloud
2. Come back after an as yet indeterminate time. It seems random but it's probably dependent on the last access
3. See the login page

Expected behavior

Once I'm logged in, I should stay logged in forever

Actual behavior

I end up being faced with the login page on a roughly daily basis

When I try to log in, the first time it doesn't matter what I enter as the password - it just loads the login screen again with no error

Host OS

Ubuntu

Nextcloud AIO version

Manual install compose.yml

Nextcloud Hub 5 (27.0.2)

Other valuable info

Cookies are valid for 15 days:

No values for session configs

$ sudo docker exec --user www-data -it nextcloud-1 php occ config:system:get session_keepalive
$ sudo docker exec --user www-data -it nextcloud-1 php occ config:system:get session_lifetime
$ sudo docker exec --user www-data -it nextcloud-1 php occ config:system:get remember_login_cookie_lifetime

The default 1440 for session.gc_maxlifetime

45d6a22374d4:/var/www/html$ php -i | grep gc_maxlifetime
session.gc_maxlifetime => 1440 => 1440

[szaimen]

Will be answered in #3673

[KenBW2]

Just been presented with the login page again following rebooting my desktop. In case it's relevant, the desktop crashed and I had to force reboot, therefore not closing Firefox gracefully.

Notably I run my NC on two domains with two users. I am still logged in to the same NC instance on a different domain and NC user. It's only affected the primary domain/user

@szaimen The answer in #3673 points to a bug which seems to be to do with MySQL. I'm using postgres

I also don't get the could not verify token error specified in the issue nextcloud/server#37492

Cookies before I attempt the first login

Cookies after I attempt the first login

Cookies after I attempt the second login

Here's some logs from after I saw the login page and before I logged back in to NC. The issue happened around Mon Nov 6 17:46:08 UTC 2023

PostgreSQL

$ sudo docker logs nextcloud-aio-database-1
Setting max connections...
chmod: /var/run/postgresql: Operation not permitted

PostgreSQL Database directory appears to contain a database; Skipping initialization

2023-10-25 12:27:50.249 BST [12] LOG:  starting PostgreSQL 15.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit
2023-10-25 12:27:50.249 BST [12] LOG:  listening on IPv4 address "**.**.**.**", port 5432
2023-10-25 12:27:50.249 BST [12] LOG:  listening on IPv6 address "::", port 5432
2023-10-25 12:27:50.251 BST [12] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-10-25 12:27:50.260 BST [22] LOG:  database system was shut down at 2023-10-25 12:27:39 BST
2023-10-25 12:27:50.269 BST [12] LOG:  database system is ready to accept connections
2023-10-25 12:44:00.966 BST [436] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-25 12:44:00.966 BST [436] DETAIL:  Key (fileid)=(37152) already exists.
2023-10-25 12:44:00.966 BST [436] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-25 15:23:14.349 BST [4002] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-25 15:23:14.349 BST [4002] DETAIL:  Key (fileid)=(37407) already exists.
2023-10-25 15:23:14.349 BST [4002] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-26 13:17:37.636 BST [34107] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-26 13:17:37.636 BST [34107] DETAIL:  Key (fileid)=(37407) already exists.
2023-10-26 13:17:37.636 BST [34107] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-27 18:17:33.075 BST [74264] ERROR:  duplicate key value violates unique constraint "oc_twofactor_providers_pkey"
2023-10-27 18:17:33.075 BST [74264] DETAIL:  Key (provider_id, uid)=(totp, **USER1**) already exists.
2023-10-27 18:17:33.075 BST [74264] STATEMENT:  INSERT INTO "oc_twofactor_providers" ("provider_id", "uid", "enabled") VALUES($1, $2, $3)
2023-10-27 18:17:47.939 BST [74266] ERROR:  duplicate key value violates unique constraint "oc_twofactor_providers_pkey"
2023-10-27 18:17:47.939 BST [74266] DETAIL:  Key (provider_id, uid)=(totp, **USER2**) already exists.
2023-10-27 18:17:47.939 BST [74266] STATEMENT:  INSERT INTO "oc_twofactor_providers" ("provider_id", "uid", "enabled") VALUES($1, $2, $3)
2023-10-30 19:32:25.645 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-30 19:32:25.645 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
2023-10-30 19:32:25.645 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-30 19:35:25.160 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-30 19:35:25.160 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
2023-10-30 19:35:25.160 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-30 19:36:04.034 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-30 19:36:04.034 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
2023-10-30 19:36:04.034 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-30 19:36:28.361 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-30 19:36:28.361 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
2023-10-30 19:36:28.361 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-30 19:36:33.686 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-30 19:36:33.686 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
2023-10-30 19:36:33.686 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-30 19:36:45.890 GMT [175649] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-30 19:36:45.890 GMT [175649] DETAIL:  Key (fileid)=(35235) already exists.
2023-10-30 19:36:45.890 GMT [175649] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-30 19:37:00.257 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-30 19:37:00.257 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
2023-10-30 19:37:00.257 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-30 19:37:24.866 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-30 19:37:24.866 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
2023-10-30 19:37:24.866 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
2023-10-31 00:13:58.700 GMT [181972] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
2023-10-31 00:13:58.700 GMT [181972] DETAIL:  Key (fileid)=(35235) already exists.
2023-10-31 00:13:58.700 GMT [181972] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)

Nextcloud container

$ sudo docker logs nextcloud-aio-nextcloud-1
              now              
-------------------------------
 2023-10-25 12:27:52.779283+01
(1 row)

User required to trust additional CA certificates, running 'update-ca-certificates.'
+ '[' -f /dev-dri-group-was-added ']'
++ find /dev -maxdepth 1 -mindepth 1 -name dri
+ '[' -n '' ']'
+ set +x
Installing imagemagick via apk...
Enabling Imagick...
Configuring Redis as session handler...
Setting php max children...
Applying one-click-instance settings...
System config value one-click-instance set to boolean true
System config value one-click-instance.user-limit set to integer 100
System config value one-click-instance.link set to string https://nextcloud.com/all-in-one/
support already enabled
Adjusting log files...
System config value upgrade.cli-upgrade-link set to string https://github.com/nextcloud/all-in-one/discussions/2726
System config value logfile set to string /var/www/html/data/nextcloud.log
Config value logfile for app admin_audit set to /var/www/html/data/audit.log
System config value updatedirectory set to string /nc-updater
Applying network settings...
System config value davstorage.request_timeout set to integer 3600
System config value trusted_domains => 1 set to string nextcloud.********.***
System config value overwrite.cli.url set to string https://nextcloud.********.***/
System config value htaccess.RewriteBase set to string /
.htaccess has been updated
System config value dbpersistent set to boolean true
System config value files_external_allow_create_new_local set to boolean true
System config value trusted_proxies => 0 set to string **.**.**.**
System config value trusted_proxies => 1 set to string ::1
Config value base_endpoint for app notify_push set to https://nextcloud.********.***/push
Config value wopi_url for app richdocuments set to https://nextcloud.********.***/
System config value allow_local_remote_servers set to boolean true
No ipv6-address found for nextcloud.********.***.
Config value wopi_allowlist for app richdocuments set to **.**.**.**,**.**.**.**/8,**.**.**.**/16,**.**.**.**/12,**.**.**.**/8,fd00::/8,::1
Config value recording_servers of app spreed deleted
[25-Oct-2023 12:28:25] NOTICE: fpm is running, pid 415
[25-Oct-2023 12:28:25] NOTICE: ready to handle connections
Activating Collabora config...
Activated any config changes
[30-Oct-2023 12:16:50] WARNING: [pool www] child 137805 exited on signal 13 (SIGPIPE) after 0.549125 seconds from start
[30-Oct-2023 12:16:50] NOTICE: [pool www] child 137808 started

Docker compose logs

$ sudo docker compose logs -t | grep -v "aborting with incomplete response" | grep -v "looking up info for HTTP challenge"
WARN[0000] Found multiple config files with supported names: compose.yml, docker-compose.yml 
WARN[0000] Using compose.yml 
WARN[0000] Found multiple config files with supported names: compose.yml, docker-compose.yml 
WARN[0000] Using compose.yml 
aio-manual-install-nextcloud-aio-redis-1  | 2023-10-25T11:27:49.843714351Z Memory overcommit is disabled but necessary for safe operation
aio-manual-install-nextcloud-aio-redis-1  | 2023-10-25T11:27:49.843761345Z See https://github.com/nextcloud/all-in-one/discussions/1731 how to enable overcommit
aio-manual-install-nextcloud-aio-redis-1  | 2023-10-25T11:27:49.863116308Z 1:C 25 Oct 2023 12:27:49.857 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
aio-manual-install-nextcloud-aio-redis-1  | 2023-10-25T11:27:49.863136733Z 1:C 25 Oct 2023 12:27:49.860 # Redis version=7.0.12, bits=64, commit=00000000, modified=0, pid=1, just started
aio-manual-install-nextcloud-aio-redis-1  | 2023-10-25T11:27:49.863141564Z 1:C 25 Oct 2023 12:27:49.860 # Configuration loaded
aio-manual-install-nextcloud-aio-redis-1  | 2023-10-25T11:27:49.865369373Z 1:M 25 Oct 2023 12:27:49.864 # Server initialized
aio-manual-install-nextcloud-aio-redis-1  | 2023-10-25T11:27:49.865390688Z 1:M 25 Oct 2023 12:27:49.864 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
aio-manual-install-nextcloud-aio-notify-push-1  | 2023-10-25T11:27:52.290233991Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-notify-push-1  | 2023-10-25T11:27:57.304392754Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-notify-push-1  | 2023-10-25T11:28:02.308388952Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-notify-push-1  | 2023-10-25T11:28:07.312933396Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-notify-push-1  | 2023-10-25T11:28:12.315429241Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-notify-push-1  | 2023-10-25T11:28:17.318537451Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-notify-push-1  | 2023-10-25T11:28:22.321264215Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.056506816Z Setting max connections...
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.087410635Z chmod: /var/run/postgresql: Operation not permitted
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.089289121Z 
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.089314619Z PostgreSQL Database directory appears to contain a database; Skipping initialization
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.089320070Z 
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.249875506Z 2023-10-25 12:27:50.249 BST [12] LOG:  starting PostgreSQL 15.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.249898957Z 2023-10-25 12:27:50.249 BST [12] LOG:  listening on IPv4 address "**.**.**.**", port 5432
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.249903609Z 2023-10-25 12:27:50.249 BST [12] LOG:  listening on IPv6 address "::", port 5432
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.251152593Z 2023-10-25 12:27:50.251 BST [12] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.261340778Z 2023-10-25 12:27:50.260 BST [22] LOG:  database system was shut down at 2023-10-25 12:27:39 BST
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:27:50.276143514Z 2023-10-25 12:27:50.269 BST [12] LOG:  database system is ready to accept connections
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:44:00.966882739Z 2023-10-25 12:44:00.966 BST [436] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:44:00.967043175Z 2023-10-25 12:44:00.966 BST [436] DETAIL:  Key (fileid)=(37152) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T11:44:00.967052197Z 2023-10-25 12:44:00.966 BST [436] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T14:23:14.349270990Z 2023-10-25 15:23:14.349 BST [4002] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T14:23:14.349615142Z 2023-10-25 15:23:14.349 BST [4002] DETAIL:  Key (fileid)=(37407) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-25T14:23:14.349629771Z 2023-10-25 15:23:14.349 BST [4002] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-26T12:17:37.641677146Z 2023-10-26 13:17:37.636 BST [34107] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-26T12:17:37.643896420Z 2023-10-26 13:17:37.636 BST [34107] DETAIL:  Key (fileid)=(37407) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-26T12:17:37.643907958Z 2023-10-26 13:17:37.636 BST [34107] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-27T17:17:33.075828164Z 2023-10-27 18:17:33.075 BST [74264] ERROR:  duplicate key value violates unique constraint "oc_twofactor_providers_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-27T17:17:33.076133121Z 2023-10-27 18:17:33.075 BST [74264] DETAIL:  Key (provider_id, uid)=(totp, ***USER1***) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-27T17:17:33.076143905Z 2023-10-27 18:17:33.075 BST [74264] STATEMENT:  INSERT INTO "oc_twofactor_providers" ("provider_id", "uid", "enabled") VALUES($1, $2, $3)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-27T17:17:47.940297791Z 2023-10-27 18:17:47.939 BST [74266] ERROR:  duplicate key value violates unique constraint "oc_twofactor_providers_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-27T17:17:47.940351065Z 2023-10-27 18:17:47.939 BST [74266] DETAIL:  Key (provider_id, uid)=(totp, ***USER2***) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-27T17:17:47.940370217Z 2023-10-27 18:17:47.939 BST [74266] STATEMENT:  INSERT INTO "oc_twofactor_providers" ("provider_id", "uid", "enabled") VALUES($1, $2, $3)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:32:25.645533283Z 2023-10-30 19:32:25.645 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:32:25.645667778Z 2023-10-30 19:32:25.645 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:32:25.645687115Z 2023-10-30 19:32:25.645 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:35:25.160990062Z 2023-10-30 19:35:25.160 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:35:25.161025288Z 2023-10-30 19:35:25.160 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:35:25.161030776Z 2023-10-30 19:35:25.160 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:04.034613963Z 2023-10-30 19:36:04.034 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:04.034644213Z 2023-10-30 19:36:04.034 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:04.034649659Z 2023-10-30 19:36:04.034 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:28.361458584Z 2023-10-30 19:36:28.361 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:28.361487213Z 2023-10-30 19:36:28.361 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:28.361493008Z 2023-10-30 19:36:28.361 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:33.686431807Z 2023-10-30 19:36:33.686 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:33.686459428Z 2023-10-30 19:36:33.686 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:33.686464403Z 2023-10-30 19:36:33.686 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:45.890177392Z 2023-10-30 19:36:45.890 GMT [175649] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:45.890201119Z 2023-10-30 19:36:45.890 GMT [175649] DETAIL:  Key (fileid)=(35235) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:36:45.890206404Z 2023-10-30 19:36:45.890 GMT [175649] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:37:00.257388745Z 2023-10-30 19:37:00.257 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:37:00.257419224Z 2023-10-30 19:37:00.257 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:37:00.257424568Z 2023-10-30 19:37:00.257 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:37:24.866906344Z 2023-10-30 19:37:24.866 GMT [175438] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:37:24.866958542Z 2023-10-30 19:37:24.866 GMT [175438] DETAIL:  Key (fileid)=(35235) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-30T19:37:24.866966115Z 2023-10-30 19:37:24.866 GMT [175438] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-database-1     | 2023-10-31T00:13:58.700707905Z 2023-10-31 00:13:58.700 GMT [181972] ERROR:  duplicate key value violates unique constraint "oc_filecache_extended_pkey"
aio-manual-install-nextcloud-aio-database-1     | 2023-10-31T00:13:58.700763058Z 2023-10-31 00:13:58.700 GMT [181972] DETAIL:  Key (fileid)=(35235) already exists.
aio-manual-install-nextcloud-aio-database-1     | 2023-10-31T00:13:58.700768622Z 2023-10-31 00:13:58.700 GMT [181972] STATEMENT:  INSERT INTO "oc_filecache_extended" ("fileid", "upload_time") VALUES($1, $2)
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.784964981Z               now              
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.785013859Z -------------------------------
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.785019499Z  2023-10-25 12:27:52.779283+01
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.785024198Z (1 row)
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.785028753Z 
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.788560670Z User required to trust additional CA certificates, running 'update-ca-certificates.'
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.924253000Z + '[' -f /dev-dri-group-was-added ']'
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.925952095Z ++ find /dev -maxdepth 1 -mindepth 1 -name dri
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.927697646Z + '[' -n '' ']'
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.927714715Z + set +x
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:52.943578836Z Installing imagemagick via apk...
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:55.595684015Z Enabling Imagick...
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:57.236651433Z Configuring Redis as session handler...
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:57.238933998Z Setting php max children...
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:59.336383189Z Applying one-click-instance settings...
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:27:59.984504041Z System config value one-click-instance set to boolean true
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:00.732213448Z System config value one-click-instance.user-limit set to integer 100
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:01.477309797Z System config value one-click-instance.link set to string https://nextcloud.com/all-in-one/
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:02.653237987Z support already enabled
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:03.076338882Z Adjusting log files...
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:27:51.165312886Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:27:56.166355286Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:28:01.170203112Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:28:06.180470857Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:28:11.183629180Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:28:16.186495531Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:28:21.204526338Z Waiting for Nextcloud to start...
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:28:28.032237055Z {"level":"info","ts":1698233308.031294,"msg":"using provided configuration","config_file":"/tmp/Caddyfile","config_adapter":""}
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:28:28.046264002Z [Wed Oct 25 12:28:28.045895 2023] [mpm_event:notice] [pid 49:tid 140278888196936] AH00489: Apache/2.4.57 (Unix) configured -- resuming normal operations
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-25T11:28:28.046343589Z [Wed Oct 25 12:28:28.045976 2023] [core:notice] [pid 49:tid 140278888196936] AH00094: Command line: '/usr/local/apache2/bin/httpd -D FOREGROUND'
aio-manual-install-nextcloud-aio-apache-1       | 2023-10-30T12:45:16.679303519Z [Mon Oct 30 12:45:16 2023] [error] [client: **.**.**.**, **.**.**.**] [AH01797: client denied by server configuration: /var/www/html/config/aws.yml] [Mozlila/5.0 (Linux; Android 7.0; SM-G892A Bulid/NRD90M; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/**.**.**.** Moblie Safari/537.36]
aio-manual-install-nextcloud-aio-apache-1       | 2023-11-05T01:56:56.976530448Z {"level":"error","ts":1699149416.975956,"logger":"http.log.error","msg":"readfrom tcp [::1]:37608->[::1]:8000: write tcp [::1]:37608->[::1]:8000: use of closed network connection","request":{"remote_ip":"**.**.**.**","remote_port":"35990","client_ip":"**.**.**.**","proto":"HTTP/1.1","method":"PROPFIND","host":"nextcloud.********.***","uri":"/remote.php/webdav/.../compose.yml","headers":{"Apply-To-Redirect-Ref":["T"],"Content-Type":["application/xml"],"X-Forwarded-Host":["nextcloud.********.***"],"X-Forwarded-Proto":["https"],"User-Agent":["gvfs/1.52.0"],"Content-Length":["235"],"Accept-Language":["en-gb, en;q=0.9"],"Accept-Encoding":["gzip, deflate, br"],"Cookie":[],"Depth":["0"],"Authorization":[],"X-Forwarded-For":["**.**.**.**"]}},"duration":0.00639843,"status":502,"err_id":"by7damq8x","err_trace":"reverseproxy.statusError (reverseproxy.go:1248)"}
aio-manual-install-nextcloud-aio-apache-1       | 2023-11-05T20:05:25.911221335Z {"level":"error","ts":1699214725.9102933,"logger":"http.log.error","msg":"EOF","request":{"remote_ip":"**.**.**.**","remote_port":"33210","client_ip":"**.**.**.**","proto":"HTTP/1.1","method":"PROPFIND","host":"nextcloud.********.***","uri":"/remote.php/webdav/.../.env","headers":{"Accept-Language":["en-gb, en;q=0.9"],"X-Forwarded-Host":["nextcloud.********.***"],"User-Agent":["gvfs/1.52.0"],"Content-Type":["application/xml"],"Cookie":[],"Apply-To-Redirect-Ref":["T"],"Authorization":[],"Depth":["0"],"X-Forwarded-Proto":["https"],"Content-Length":["235"],"Accept-Encoding":["gzip, deflate, br"],"X-Forwarded-For":["**.**.**.**"]}},"duration":0.00084216,"status":502,"err_id":"hst1vs498","err_trace":"reverseproxy.statusError (reverseproxy.go:1248)"}
aio-manual-install-nextcloud-aio-apache-1       | 2023-11-05T20:22:15.917912054Z {"level":"error","ts":1699215735.915524,"logger":"http.log.error","msg":"EOF","request":{"remote_ip":"**.**.**.**","remote_port":"36366","client_ip":"**.**.**.**","proto":"HTTP/1.1","method":"PROPFIND","host":"nextcloud.********.***","uri":"/remote.php/webdav/.../compose.yml","headers":{"Depth":["0"],"User-Agent":["gvfs/1.52.0"],"Content-Length":["235"],"Content-Type":["application/xml"],"Cookie":[],"Accept-Language":["en-gb, en;q=0.9"],"X-Forwarded-Proto":["https"],"Accept-Encoding":["gzip, deflate, br"],"Apply-To-Redirect-Ref":["T"],"Authorization":[],"X-Forwarded-For":["**.**.**.**"],"X-Forwarded-Host":["nextcloud.********.***"]}},"duration":0.000984137,"status":502,"err_id":"rdr7zkmja","err_trace":"reverseproxy.statusError (reverseproxy.go:1248)"}
aio-manual-install-nextcloud-aio-apache-1       | 2023-11-05T23:04:30.890701283Z {"level":"error","ts":1699225470.8898358,"logger":"http.log.error","msg":"readfrom tcp [::1]:55846->[::1]:8000: write tcp [::1]:55846->[::1]:8000: use of closed network connection","request":{"remote_ip":"**.**.**.**","remote_port":"49838","client_ip":"**.**.**.**","proto":"HTTP/1.1","method":"PROPFIND","host":"nextcloud.********.***","uri":"/remote.php/webdav/.../.env","headers":{"X-Forwarded-Proto":["https"],"Content-Length":["235"],"Accept-Encoding":["gzip, deflate, br"],"Authorization":[],"Content-Type":["application/xml"],"Depth":["0"],"Cookie":[],"X-Forwarded-For":["**.**.**.**"],"X-Forwarded-Host":["nextcloud.********.***"],"Apply-To-Redirect-Ref":["T"],"User-Agent":["gvfs/1.52.0"],"Accept-Language":["en-gb, en;q=0.9"]}},"duration":0.000600808,"status":502,"err_id":"bx9cpg4w9","err_trace":"reverseproxy.statusError (reverseproxy.go:1248)"}
aio-manual-install-nextcloud-aio-apache-1       | 2023-11-06T00:39:03.897160224Z {"level":"error","ts":1699231143.8965757,"logger":"http.log.error","msg":"EOF","request":{"remote_ip":"**.**.**.**","remote_port":"48010","client_ip":"**.**.**.**","proto":"HTTP/1.1","method":"PROPFIND","host":"nextcloud.********.***","uri":"/remote.php/webdav/.../.env","headers":{"X-Forwarded-Proto":["https"],"User-Agent":["gvfs/1.52.0"],"Accept-Encoding":["gzip, deflate, br"],"Authorization":[],"Content-Type":["application/xml"],"Cookie":[],"X-Forwarded-For":["**.**.**.**"],"Depth":["0"],"Content-Length":["235"],"X-Forwarded-Host":["nextcloud.********.***"],"Accept-Language":["en-gb, en;q=0.9"],"Apply-To-Redirect-Ref":["T"]}},"duration":0.000428783,"status":502,"err_id":"nr1x98k80","err_trace":"reverseproxy.statusError (reverseproxy.go:1248)"}
aio-manual-install-nextcloud-aio-apache-1       | 2023-11-06T00:49:11.892372820Z {"level":"error","ts":1699231751.8915114,"logger":"http.log.error","msg":"EOF","request":{"remote_ip":"**.**.**.**","remote_port":"48010","client_ip":"**.**.**.**","proto":"HTTP/1.1","method":"PROPFIND","host":"nextcloud.********.***","uri":"/remote.php/webdav/.../.env","headers":{"X-Forwarded-For":["**.**.**.**"],"X-Forwarded-Proto":["https"],"User-Agent":["gvfs/1.52.0"],"Content-Length":["235"],"Apply-To-Redirect-Ref":["T"],"Content-Type":["application/xml"],"Accept-Encoding":["gzip, deflate, br"],"Cookie":[],"Accept-Language":["en-gb, en;q=0.9"],"Authorization":[],"Depth":["0"],"X-Forwarded-Host":["nextcloud.********.***"]}},"duration":0.000182123,"status":502,"err_id":"ifgxgmhnu","err_trace":"reverseproxy.statusError (reverseproxy.go:1248)"}
aio-manual-install-nextcloud-aio-apache-1       | 2023-11-06T13:57:16.893585685Z {"level":"error","ts":1699279036.8927605,"logger":"http.log.error","msg":"EOF","request":{"remote_ip":"**.**.**.**","remote_port":"44336","client_ip":"**.**.**.**","proto":"HTTP/1.1","method":"PROPFIND","host":"nextcloud.********.***","uri":"/remote.php/webdav/.../compose.yml","headers":{"Depth":["0"],"X-Forwarded-Proto":["https"],"Apply-To-Redirect-Ref":["T"],"Accept-Encoding":["gzip, deflate, br"],"Authorization":[],"X-Forwarded-For":["**.**.**.**"],"X-Forwarded-Host":["nextcloud.********.***"],"Content-Length":["235"],"Accept-Language":["en-gb, en;q=0.9"],"Content-Type":["application/xml"],"Cookie":[],"User-Agent":["gvfs/1.52.0"]}},"duration":0.000499962,"status":502,"err_id":"dsmtpekgc","err_trace":"reverseproxy.statusError (reverseproxy.go:1248)"}
aio-manual-install-nextcloud-aio-apache-1       | 2023-11-06T14:12:06.895768937Z {"level":"error","ts":1699279926.8953001,"logger":"http.log.error","msg":"EOF","request":{"remote_ip":"**.**.**.**","remote_port":"45898","client_ip":"**.**.**.**","proto":"HTTP/1.1","method":"PROPFIND","host":"nextcloud.********.***","uri":"/remote.php/webdav/.../compose.yml","headers":{"X-Forwarded-For":["**.**.**.**"],"X-Forwarded-Proto":["https"],"Content-Length":["235"],"Apply-To-Redirect-Ref":["T"],"Authorization":[],"Cookie":[],"X-Forwarded-Host":["nextcloud.********.***"],"User-Agent":["gvfs/1.52.0"],"Accept-Encoding":["gzip, deflate, br"],"Accept-Language":["en-gb, en;q=0.9"],"Content-Type":["application/xml"],"Depth":["0"]}},"duration":0.000367051,"status":502,"err_id":"gtnqgrg9c","err_trace":"reverseproxy.statusError (reverseproxy.go:1248)"}
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:03.892600767Z System config value upgrade.cli-upgrade-link set to string https://github.com/nextcloud/all-in-one/discussions/2726
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:04.712825005Z System config value logfile set to string /var/www/html/data/nextcloud.log
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:05.671046360Z Config value logfile for app admin_audit set to /var/www/html/data/audit.log
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:06.321518111Z System config value updatedirectory set to string /nc-updater
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:06.347437097Z Applying network settings...
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:06.958957870Z System config value davstorage.request_timeout set to integer 3600
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:07.595547006Z System config value trusted_domains => 1 set to string nextcloud.********.***
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:08.254687961Z System config value overwrite.cli.url set to string https://nextcloud.********.***/
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:08.947654812Z System config value htaccess.RewriteBase set to string /
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:09.579115312Z .htaccess has been updated
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:10.222078326Z System config value dbpersistent set to boolean true
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:10.845737806Z System config value files_external_allow_create_new_local set to boolean true
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:14.231255503Z System config value trusted_proxies => 0 set to string **.**.**.**
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:14.852976046Z System config value trusted_proxies => 1 set to string ::1
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:15.495543429Z Config value base_endpoint for app notify_push set to https://nextcloud.********.***/push
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:17.468965975Z Config value wopi_url for app richdocuments set to https://nextcloud.********.***/
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:18.123368243Z System config value allow_local_remote_servers set to boolean true
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:18.987767451Z No ipv6-address found for nextcloud.********.***.
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:19.603663681Z Config value wopi_allowlist for app richdocuments set to **.**.**.**,**.**.**.**/8,**.**.**.**/16,**.**.**.**/12,**.**.**.**/8,fd00::/8,::1
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:23.628947890Z Config value recording_servers of app spreed deleted
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:25.955878395Z [25-Oct-2023 12:28:25] NOTICE: fpm is running, pid 415
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:25.955924750Z [25-Oct-2023 12:28:25] NOTICE: ready to handle connections
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:35.730958079Z Activating Collabora config...
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-25T11:28:36.835373153Z Activated any config changes
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-30T12:16:50.305554201Z [30-Oct-2023 12:16:50] WARNING: [pool www] child 137805 exited on signal 13 (SIGPIPE) after 0.549125 seconds from start
aio-manual-install-nextcloud-aio-nextcloud-1    | 2023-10-30T12:16:50.305815500Z [30-Oct-2023 12:16:50] NOTICE: [pool www] child 137808 started

The most recent entry from nextcloud.log:

Note that it's from several days ago, when I did legit type my password wrong

{"reqId":"*******","level":2,"time":"2023-11-03T22:15:51+00:00","remoteAddr":"**.**.**.**","user":"--","app":"no app in context","method":"POST","url":"/login","message":"Login failed: ***USER1*** (Remote IP: **.**.**.**)","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"**.**.**.**","data":[]}

[KenBW2]

Interestingly a different laptop which has been in suspend for a number of days, overlapping the above, was logged in as soon as I returned to it this evening

[KenBW2]

@szaimen Can I have this ticket reopened? I've had this happen twice today

Nothing in the Nextcloud Logging page. I'm happy to peruse other logs

[szaimen]

See #3673 (comment)