Attempting to migrate PostgreSQL 13 to 15 fails

Support
1

What type of hardware are you using: VPS bought online
What YunoHost version are you running: 12.0.14
How are you able to access your server: The webadmin
SSH
Are you in a special context or did you perform specific tweaking on your YunoHost instance ?: not to my knowledge

Describe your issue

Hello! :slight_smile: Last night I ran a pretty big upgrade of system packages. It seemed to go smoothly, but today I log in and see there are some tasks outstanding under tools → migrations. I run the first couple of ones, they go well! But the upgrade/migration of PostgreSQL from 13 to 15 keeps failing. :frowning:

The error log says there’s no disk space, so I go and delete 6 GB of stuff and try again. Still no luck. I go uninstall the plume instance I’m not actively using. Still no luck. So I’m doubting it’s a space issue? :\

Here is the log of the migration:
https://paste.yunohost.org/raw/qeweminepu

And for context, this is the log of the system upgrade from last night:
https://paste.yunohost.org/raw/onisawanem

In case it is helpful to know; The primary app on my server is IceShrimp, and each time I tried (and failed) to do the PostgreSQL migration I’d get this error messag on IceShrimp: “Could not fetch account information
{“message”:“Internal error occurred. Please contact us if the error persists.”,“code”:“INTERNAL_ERROR”,“id”:“5d37dbcb-891e-41ca-a3d6-e690c97775ac”,“kind”:“server”,“info”:{“e”:{“message”:“connect ECONNREFUSED 127.0.0.1:5432”,“code”:“Error”,“stack”:“Error: connect ECONNREFUSED 127.0.0.1:5432\n at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1607:16)”}}}”

The error on IceShrimp goes away when I reboot the server thankfully (whew!).

(L’anglais est ma première langue mais je peux lire en francais.)

Edit to add:

> df -h
Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G     0  1.9G   0% /dev
tmpfs           382M  884K  382M   1% /run
/dev/sda1        19G   16G  1.9G  90% /
tmpfs           1.9G   16K  1.9G   1% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
/dev/sda15      241M  142K  241M   1% /boot/efi
tmpfs           382M     0  382M   0% /run/user/61786

Share relevant logs or error messages

https://paste.yunohost.org/raw/qeweminepu
https://paste.yunohost.org/raw/onisawanem
https://paste.yunohost.org/raw/fuvufarute

2

So it does look like I’m running low on space but I’m kind of stumped as to why. I had well over 13 GB of space a couple of weeks ago. I’m concerned that apps that I installed and then deleted didn’t actually… delete? But I can’t figure out how to actually check that? Tips would be appreciated! Ty!

3

Poking around the forum I found this thread on storage issues. I went around my server’s directories running the command sudo du -shc * | sort -h and found that /var/log/journal was gigantic :hushed_face:

I used the advice from this website on cleaning the journal, and ran this command:

sudo journalctl --vacuum-size=100M

This freed me 2 GB of space, and after doing so I was able to successfully run the migration of PostgreSQL from 13 to 15. :tada:

But I’m still a little concerned there’s some remnants of previously-deleted apps (I installed and later uninstalled mobilizon and yet found a bunch of mobilizon stuff still on disk! :melting_face:). Is there a way to check that the database has been purged of any deleted apps? Ty!