#Errors in DB since 1.96

1 messages · Page 1 of 1 (latest)

old schooner
silver falconBOT
#

:wave: Hey @old schooner,

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 using the buttons below or the /upload command.
  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.

steep dune
#

what is the user of your database?

old schooner
#

postgres

steep dune
#

can you show your .env content?

#

you can remove the password piece

old schooner
steep dune
#

Can you help pasting the content as text, I am on my phone?

old schooner
#

UPLOAD_LOCATION=/volume3/docker/immich/upload
IMMICH_VERSION=release
TYPESENSE_API_KEY=MrJackTypeSenseApiKey
DB_PASSWORD=*********
DB_HOSTNAME=immich_postgres
DB_USERNAME=postgres
DB_DATABASE_NAME=immich
REDIS_HOSTNAME=immich_redis

steep dune
#

Can you try restart the stack to see if it resolves the issue?

old schooner
#

I tried once. I'm going to restart one more time

steep dune
#

ok @white grove do you know what happen in this case?

old schooner
#

Restart doesn't fix, same error again

white grove
#

That error implies the geodata_places table somehow got dropped at some point

#

Or if you restored from a backup, the backup might not have created it

old schooner
#

Didn't restore any backup. Just update with Watchtowerr this night..

old schooner
#

Any tips to help me restore my database ?

steep dune
#

Do you have any database backup?

white grove
#

If this is the only issue with the DB, you can run these queries to re-create the table. But it might not work if this error is a symptom of something else being wrong

create table if not exists public.geodata_places
(
    id                 integer          not null
        constraint "PK_c29918988912ef4036f3d7fbff4"
            primary key,
    name               varchar(200)     not null,
    longitude          double precision not null,
    latitude           double precision not null,
    "countryCode"      char(2)          not null,
    "admin1Code"       varchar(20),
    "admin2Code"       varchar(80),
    "modificationDate" date             not null,
    "earthCoord"       earth generated always as (ll_to_earth(latitude, longitude)) stored,
    "admin1Key"        varchar generated always as (((("countryCode")::text || '.'::text) || ("admin1Code")::text)) stored,
    "admin2Key"        varchar generated always as ((
            (((("countryCode")::text || '.'::text) || ("admin1Code")::text) || '.'::text) ||
            ("admin2Code")::text)) stored
)
    with (fillfactor = 100);

alter table public.geodata_places
    owner to postgres;
old schooner
# steep dune Do you have any database backup?

I don't have any clean backup of my database. But I backup every files in my filesystem, every night, including volumes for docker. Do you think it could be possible to restore Immich DB by just copying back every files ?

steep dune
tight harness
#

I'm also encountering a problem with postgres and I can send an image. Sorry if irrelevant

steep dune
tight harness
#

Got it, it was pushed wrongly by the community version I'm using. Thanks anyway!

old schooner