MySQL not starting

[girish]

@v8aaaaaa It seems MySQL got corrupt. Are these the logs from the MySQL on the host or on the addon inside docker?

[V8AAAAAA]

@girish Those logs are from MySQL on the host however MySQL (addon) works fine

[nebulon]

@v8aaaaaa can you check if you have disk space left on your server and also see if you have inodes left with running df -i ?

[V8AAAAAA]

@nebulon df -i generates this output :

Filesystem        Inodes  IUsed     IFree IUse% Mounted on                                                                                                              udev             1960725    609   1960116    1% /dev
tmpfs            1981019   1529   1979490    1% /run
/dev/nvme0n1p2  15597568 587662  15009906    4% /
tmpfs            1981019      4   1981015    1% /dev/smh
tmpfs            1981019      7   1981012    1% /run/lock
tmpfs            1981019     18   1981001    1% /sys/fs/cgroup
/dev/nvme0n1p1         0      0         0     - /boot/efi
/dev/md127     122085376     23 122085353    1% /run/mount/raid
tmpfs            1981019     48   1980971    1% /run/user/133                                                                                                tmpfs            1981019     38   1980981    1% /run/user/1000                                                                                                         

(I removed every snap packages mount because it's kinda useless to list them)

[nebulon]

@v8aaaaaa so that does not seem to be the issue. Can you also verify that files like ibdata1 exist under /var/lib/mysql/ as well as being owned by the mysql user?

[V8AAAAAA]

@nebulon ibdata1 does exists and belongs to the mysql user
-rw-r----- 1 mysql mysql 12582912 Nov 8 20:27 ibdata1

[nebulon]

@v8aaaaaa given that those things look ok, it looks like there was disk/filesystem corruption affecting this file. Looks like the database then has to be rebuilt, but given this affects the host database, the easiest way is likely to just restore the whole Cloudron from a backup onto a new server, also to get a fresh start on the disk/filesystem. See https://docs.cloudron.io/backups/#restore-cloudron

[V8AAAAAA]

@nebulon Is there any way to restore cloudron without reinstalling my OS? It's the only "server" I have and it's selfhosted and I have other services running on it that would be bothering to reinstall

[girish]

@v8aaaaaa Have you tried recovering mysql already? https://docs.cloudron.io/troubleshooting/#recover-mysql . In case, you are not able to recover the existing mysql, you can just start afresh. The database dump file is a file named box.mysqldump inside your latest box_xxxxx.tar.gz backup.

[V8AAAAAA]

@girish I couldn't recover MySQL so I just decided to install Debian on my server and run Cloudron inside of a Ubuntu VM so I can take snapshots incase if that happens to me again.
Thanks for the help tho