Upgrade to Yunohost 12 failed with unspecific error

[jarod5001]

@matalb

Postgresql 13 to 15

PostgreSQL migration failure

(fixing formatting) But to clarify, I do not have immich installed, it does appear to be an issue just with the state of postgresql migration. Very unhelpful that the underlying 15 pg_upgradecluster error log doesn’t appear to get written. Another post Migration Failed - Migrate databases from PostgreSQL 13 to 15 suggested this was due to disk space - not my issue. Looking at dpkg -l | grep postgres, I see that postgresql-13-postgis-3 was installed - perhaps for an app I no longer am using? I…

[matalb]

I tried migration 29 several times, here is the last log:

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

Hard to read due to many \n sequences.
There is one thing mentioned:

\xc2\xbbpublic.state_groups_state_type_idx\xc2\xab: konnte Datei \xc2\xbb/var/lib/postgresql/15/main/base/16401/17779.2\xc2\xab
  nicht schreiben: Auf dem Ger\xc3\xa4t ist kein Speicherplatz mehr verf\xc3\xbcgbar\nFehlgeschlagen,

One message is:

Auf dem Gerät ist kein Speicherplatz mehr verfügbar => no memory left on device.

I deleted a 27GB backup und executed sudo yunohost tools basic-space-cleanup which is mentioned in the quoted post, which freed 3.5GB, but in my case, it did not help.

Tomorrow, I will try again. In the log is a postgresql log location which I will search for.

[matalb]

I started again migration 29 (Postgreqsl 13 → 15). Again, it stopped silently after some time with an error message. Here is the log:

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

Restoring database schemas in the new cluster               ok
Copying user relation files                                 
Fehler beim Kopieren von Relation   \xc2\xbbpublic.state_groups_state_type_idx\xc2\xab: konnte Datei \xc2\xbb/var/lib/postgresql/15/main/base/16401/17779.2\xc2\xab
  nicht schreiben: Auf dem Ger\xc3\xa4t ist kein Speicherplatz mehr verf\xc3\xbcgbar
Fehlgeschlagen,
  Programm wird beendet
Cluster is not running

Again, is claims to have not enogh disk space, but I doubt it.
Here is the output of the df command:

Filesystem                                       1K-blocks      Used Available Use% Mounted on
udev                                               4049880         0   4049880   0% /dev
tmpfs                                               813548       644    812904   1% /run
/dev/sda3                                        159849612 124020364  27686568  82% /
tmpfs                                              4067728         0   4067728   0% /dev/shm
tmpfs                                                 5120         0      5120   0% /run/lock
/dev/sda2                                           996780     85520    842448  10% /boot
myipaddress:/voln353211a1                      262144000  76533632 185610368  30% /mnt/storagespace
myipaddress:/voln353211a1/home/yunohost.backup 262144000  76533632 185610368  30% /home/yunohost.backup
tmpfs                                               813544         0    813544   0% /run/user/1007

There is 27.6GB free disk space, that should be enough.

[matalb]

I will be really happy for any kind of help with solving this problem. I will try to find any kind of additional information.

[matalb]

This posts do not cover the same problem.

[matalb]

I posted the PostgreSQL problem in a new more specific post.

[matalb]

The server is not yet working. PostgreSQL service is dead. Migration 29 failed.