Mysql and postgresql go down

It’s hard to identify what’s going wrong…

Did you have reboot your server ?? why you have got an error here

OSError: [Errno 5] Input/output error: '/var/log/yunohost/categories/operation/20240919-071642-tools_reboot.yml'

It seems the DB is corrupted, it’s hard to found how repair it

Look at this post Getting error “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed” when starting MySQL

Or you can try force recovery

put innodb_force_recovery=1 under mysqld, restarted MariaDB. This time, MariaDB started. I then exported all my databases, removed the innodb_force_recovery=1 option, restarted MariaDB again

Here something similar (in french) Mysql ne démarre plus : [ERROR] InnoDB: Malformed log record; - #8 by tramwiste

You should monitor it and evaluate if you need to increase the RAM or make any change to improve the performance of the server…