Can't upgrade/restore after Trixie migration

[kay0u]

The upgrade from 2.2.3 to 2.3.1 failed https://paste.yunohost.org/raw/heqipacuvi
And the restore too https://paste.yunohost.org/raw/icocawagay

Running

ALTER DATABASE postgres REFRESH COLLATION VERSION;
REINDEX DATABASE postgres;

fix the mismatch version warning, but I think the restore is done on custer 16/main, while it should be on 17/main:
https://paste.yunohost.org/raw/qihalafizo

[rosbeef]

Seems not only related to trixie.
I have a problem too on bookworm.

https://paste.yunohost.org/raw/aluvomoqaq

[ewilly]

@kay0u
you are my first trixie tester (i did not jump myself) so sorry but you will deal with teething problems :)

• for the upgarde failling i think i fix it with 75db690 (not tested yet)
• for the restore i need to info to better understand. Could you post ethe output of cat /etc/yunohost/apps/immich/settings.yml | grep db_port and LC_ALL=C sudo --login --user=postgres PGUSER=postgres PGPASSWORD="$(cat /etc/yunohost/psql)" psql --command="\echo :PORT"

[kay0u]

Don't worry, that's what testers are for ;)

[kay0u]

cat /etc/yunohost/apps/immich/settings.yml | grep db_port
db_port: '5434'

LC_ALL=C sudo --login --user=postgres PGUSER=postgres PGPASSWORD="$(cat /etc/yunohost/psql)" psql --command="\echo :PORT"
5432

Do you think it'll fix the restore if I edit the settings.yml to use the same db port?
No it's not. Any suggestion?

[guillaumelegoc]

@kay0u you are my first trixie tester (i did not jump myself) so sorry but you will deal with teething problems :)

No he's not 😢

@kay0u, it seems I can't read the Yunohost pastebins right now. But I do have issues upgrading, installing and restoring Immich on Trixie as well, with always the same error message saying that the "immich" database does not exist (see #314). Is it the same error with you ?

[kay0u]

I think I found the issue, and it's on Yunohost side.
After the migration Bullseye to Bookworm, there is a psql migration, from 13 to 15. But the psql migration after Trixie is missing.

I'll add this migration 👍

[kay0u]

Btw, @ewilly why do you try to manage the cluster used, it should use the default one, defined in the file /etc/postgresql-common/user_clusters

[ewilly]

yes for trixie it is normally now the case that was just due in bookworm

[kay0u]

Well I think this issue is closed by YunoHost/yunohost#2237

I was able to restore and upgrade immich after dropping the bookworm cluster

[lpryszcz]

hi @kay0u immich installed from testing branch seems working fine.

sudo yunohost app upgrade immich -u https://github.com/YunoHost-Apps/immich_ynh/tree/testing

thanks for solving it and maintaining immich!