Error failed to find parent tuple after upgrade V1.106.4 | Immich | Page 1

wicked wyvern Jun 23, 2024, 8:51 PM

#

After an upgrade from 1.105.1 to 1.106.4, immich server can't start and display an error in attached file

Starting microservices worker
[Nest] 7 - 06/23/2024, 8:09:24 PM LOG [Microservices:EventRepository] Initialized websocket server
Migration "CreateAssetDuplicateColumns1711989989911" failed, error: failed to find parent tuple for heap-only tuple at (4884,8) in table "assets"
...
microservices worker exited with code 1

Environnement :
Docker compose with portainer (adapted without microservice)
Config on attached file.
If I revert back to V1.105.1 and restore my previous docker compose file, it's work again.

What does this error mean and How I can solve it?
Thanks guys
Regards

📎 config.txt 📎 immich_server_logs.txt

lapis lanceBOT Jun 23, 2024, 8:51 PM

#

:wave: Hey @wicked wyvern,

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

Container Logs: docker compose logs docs
Container Status: docker compose ps docs
Reverse Proxy: https://immich.app/docs/administration/reverse-proxy

Checklist

:ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
:ballot_box_with_check: I have read applicable release notes.
:ballot_box_with_check: I have reviewed the FAQs for known issues.
:ballot_box_with_check: I have reviewed Github for known issues.
:ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
:ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files using the buttons below or the /upload command.
: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.

lapis lanceBOT Jun 23, 2024, 8:53 PM

#

lapis lance :wave: Hey <@904497577548984330>, Thanks for reaching out to us. Please follow ...

Successfully submitted, a tag has been added to inform contributors. :white_check_mark:

thick idol Jun 23, 2024, 9:00 PM

#

That's concerning, it indicates some corruption in your database that I don't think has an easy solution

#

You can try this (including the backup!) to see if it fixes it https://stackoverflow.com/a/50354522

Stack Overflow

Postgres Corruption Error: Duplicate rows with the same primary key

I recently hit a Postgres error (my DB corrupted), basically, some rows on the DB duplicated (along with the primary key). Before I keep going, these are the errors addressed in this post:

ERROR:

#

But note that this means effectively deleting assets from the database

#

So then after you'll need to figure out which ones those are and reupload them

wicked wyvern Jun 24, 2024, 7:55 AM

#

Why is-it working un V1.105.1 and not in V1.106.4 ???

thick idol Jun 24, 2024, 8:00 AM

#

The corruption is there in both, when 106 starts up it tries to run a migration that encounters the corruption/makes it visible

wicked wyvern Jun 24, 2024, 9:34 AM

#

Strange,
Is there a way to reconstruct database without losing all person and face recognition?
Thks

thick idol Jun 24, 2024, 11:08 AM

#

You can try what I linked above which if it goes well will keep most of your database intact (but no telling how much until you get going)

#Error failed to find parent tuple after upgrade V1.106.4

References

Checklist