#immich_postgres spamming error log

1 messages · Page 1 of 1 (latest)

languid musk
#

Hi,

My immich_postgres container has recently (unclear exactly when but for a few weeks at least) been spamming the following log:

immich_postgres          | 2024-08-03 23:46:39.250 UTC [2292] ERROR:  relation "system_config" does not exist at character 128
immich_postgres          | 2024-08-03 23:46:39.250 UTC [2292] STATEMENT:  SELECT "SystemConfigEntity"."key" AS "SystemConfigEntity_key", "SystemConfigEntity"."value" AS "SystemConfigEntity_value" FROM "system_config" "SystemConfigEntity"
immich_postgres          | 2024-08-03 23:46:42.078 UTC [2297] ERROR:  relation "system_config" does not exist at character 128
immich_postgres          | 2024-08-03 23:46:42.078 UTC [2297] STATEMENT:  SELECT "SystemConfigEntity"."key" AS "SystemConfigEntity_key", "SystemConfigEntity"."value" AS "SystemConfigEntity_value" FROM "system_config" "SystemConfigEntity"

I've tried restarting the entire stack with docker-compose, pulled the latest images, checked the admin settings for any issues and so far I can't find anything. Anyone have an idea why this is happening? Thanks!

rare cradleBOT
#

:wave: Hey @languid musk,

Thanks for reaching out to us. Please follow the recommended actions below; this will help us be more effective in our support effort and leave more time for building Immich immich.

References

Checklist

  1. :ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
  2. :ballot_box_with_check: I have read applicable release notes.
  3. :ballot_box_with_check: I have reviewed the FAQs for known issues.
  4. :ballot_box_with_check: I have reviewed Github for known issues.
  5. :ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
  6. :ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files, making sure to use code formatting.
  7. :ballot_box_with_check: I have tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable

(an item can be marked as "complete" by reacting with the appropriate number)

If this ticket can be closed you can use the /close command, and re-open it later if needed.

languid musk
# 
# docker-compose ps
NAME                      IMAGE                                                                                                                    COMMAND                  SERVICE                   CREATED          STATUS                  PORTS
immich_machine_learning   ghcr.io/immich-app/immich-machine-learning:release                                                                       "./start.sh"             immich-machine-learning   26 minutes ago   Up 26 minutes
immich_microservices      ghcr.io/immich-app/immich-server:release                                                                                 "start.sh microservi…"   immich-microservices      2 months ago     Up Less than a second
immich_postgres           registry.hub.docker.com/tensorchord/pgvecto-rs@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0   "postgres -c shared_…"   database                  26 minutes ago   Up 26 minutes
immich_redis              registry.hub.docker.com/library/redis@sha256:51d6c56749a4243096327e3fb964a48ed92254357108449cb6e23999c37773c5            "redis-server"           redis                     26 minutes ago   Up 26 minutes
immich_server             ghcr.io/immich-app/immich-server:release                                                                                 "start.sh"               immich-server             26 minutes ago   Up 26 minutes           3001/tcp
#

I'm able to access and use immich just fine via the web ui and app.

rare cradleBOT
languid musk
#

Just to emphasize the spamming, here's the last 25 logs from the postgres container:

📎 message.txt