I
Immich•4mo ago
Meltea

Migration failing on bump from 1.119.1 to 1.125.2

I have a migration failing on 
  query: 'DROP INDEX "IDX_day_of_month"',
  parameters: undefined,
  driverError: error: tuple concurrently updated
  query: 'DROP INDEX "IDX_day_of_month"',
  parameters: undefined,
  driverError: error: tuple concurrently updated
https://github.com/immich-app/immich/blob/main/server/src/migrations/1734574016301-AddTimeBucketIndices.ts Has anyone seen this error? I didn't see anything interesting in the changelog between versions...
14 Replies
Immich
Immich•4mo ago
:wave: Hey @Meltea, Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:. References - Container Logs: docker compose logs docs - Container Status: docker ps -a docs - Reverse Proxy: https://immich.app/docs/administration/reverse-proxy - Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA
Immich
Immich•4mo ago
Checklist I have... 1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time). 2. :ballot_box_with_check: read applicable release notes. 3. :blue_square: reviewed the FAQs for known issues. 4. :blue_square: reviewed Github for known issues. 5. :blue_square: tried accessing Immich via local ip (without a custom reverse proxy). 6. :blue_square: uploaded the relevant information (see below). 7. :blue_square: 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) Information In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider: - Your docker-compose.yml and .env files. - Logs from all the containers and their status (see above). - All the troubleshooting steps you've tried so far. - Any recent changes you've made to Immich or your system. - Details about your system (both software/OS and hardware). - Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h). - The version of the Immich server, mobile app, and other relevant pieces. - Any other information that you think might be relevant. Please paste files and logs with proper code formatting, and especially avoid blurry screenshots. Without the right information we can't work out what the problem is. Help us help you ;) If this ticket can be closed you can use the /close command, and re-open it later if needed.
GitHub
immich-app immich · Discussions
Explore the GitHub Discussions forum for immich-app immich. Discuss code, ask questions & collaborate with the developer community.
FAQ | Immich
User
GitHub
Issues · immich-app/immich
High performance self-hosted photo and video management solution. - Issues · immich-app/immich
Meltea
MelteaOP•4mo ago
Zeus
Zeus•4mo ago
Are you using multiple workers? Split micro services for example
Meltea
MelteaOP•4mo ago
I think that got removed a while back, didn't it?
No description
Meltea
MelteaOP•4mo ago
I just have one server replica and the machine learning container My postgres versions 
ARG BITNAMI_POSTGRES_BASE_VERSION="16.1.0"
ARG PGVECTO_RS_BASE_VERSION="v0.2.0"

FROM tensorchord/pgvecto-rs-binary:pg16-${PGVECTO_RS_BASE_VERSION}-amd64 as binary
FROM bitnami/postgresql:${BITNAMI_POSTGRES_BASE_VERSION} as build
ARG BITNAMI_POSTGRES_BASE_VERSION="16.1.0"
ARG PGVECTO_RS_BASE_VERSION="v0.2.0"

FROM tensorchord/pgvecto-rs-binary:pg16-${PGVECTO_RS_BASE_VERSION}-amd64 as binary
FROM bitnami/postgresql:${BITNAMI_POSTGRES_BASE_VERSION} as build
Zeus
Zeus•4mo ago
It’s still available just not default I assume this is a bitnami related issue You can try going one version at a time
Meltea
MelteaOP•4mo ago
  datname  | xid_age |  mxid_age
-----------+---------+------------
 postgres  | 7284689 | 2147483647
 immich    | 7284689 | 2147483647
  datname  | xid_age |  mxid_age
-----------+---------+------------
 postgres  | 7284689 | 2147483647
 immich    | 7284689 | 2147483647
ooof, with autovacuum on as well... well backup restore it is then
Meltea
MelteaOP•4mo ago
well I figured out what got corrupted, no idea how, the users table is empty
No description
Zeus
Zeus•4mo ago
Meltea
MelteaOP•4mo ago
ah I no longer have the original DB, I am working off of a backup, the users entries is the only thing that's empty, and I can insert that manually
Zeus
Zeus•4mo ago
Ah ok. I imagine there was some corruption
Meltea
MelteaOP•4mo ago
success!
No description
Immich
Immich•4mo ago
This thread has been closed. To re-open, use the button below.

Did you find this page helpful?