Question Mariadb down after update Plesk /var 100% full

[flieg4bei]

Server operating system version

18.04

Plesk version and microupdate number

Product version: Plesk Obsidian 18.0.59.2 OS version: Ubuntu 18.04 x86_64

I Have a question
After the last update from Plesk 18.04 i have the problem the mariadb dooesn´s start .
and my /var ist 100% full
Anyone can help me .
I think that was this redis-server ?

..skipping...
● mariadb.service - MariaDB 10.5.16 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; bad; vendor preset: enabled)
● mariadb.service - MariaDB 10.5.16 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; bad; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf, restorecon_socket.conf
Active: activating (auto-restart) (Result: core-dump) since Thu 2024-03-14 18:56:38 CET; 920ms ago
Docs: man:mariadbd(8)
systemd
Process: 22612 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=dumped, signal=SEGV)
Process: 22581 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status
Process: 22572 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 22565 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 22612 (code=dumped, signal=SEGV)

Mär 14 18:56:38 h2603484.stratoserver.net systemd[1]: Failed to start MariaDB 10.5.16 database server.

 

[flieg4bei]

/var ist now clean
how can i look which mariadb plesk used ?

 

[flieg4bei]

[19814]: 2024-03-14 21:05:26 0 [Note] InnoDB: 10.5.16 started; log sequence number 4041890890; transaction id 87683212
[19814]: 2024-03-14 21:05:26 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
[19814]: 2024-03-14 21:05:26 0 [Note] Plugin 'FEEDBACK' is disabled.
[19814]: 2024-03-14 21:05:26 0 [Note] InnoDB: Buffer pool(s) load completed at 240314 21:05:26
[19814]: 2024-03-14 21:05:26 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
mariadbd[19814]: 2024-03-14 21:05:26 0 [ERROR] Failed to initialize plugins.
[19814]: 2024-03-14 21:05:26 0 [ERROR] Aborting
[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
[1]: mariadb.service: Failed with result 'exit-code'.
[1]: Failed to start MariaDB 10.5.16 database server.

 

[ChristophRo]

https://support.plesk.com/hc/en-us/articles/12377243101591-MariaDB-fails-to-start-Aria-engine-is-not-enabled-or-did-not-start

 

[flieg4bei]

thanks i will show

 

[flieg4bei]

only the plesk works any other database are not startet. ;(

 

[flieg4bei]

https://support.plesk.com/hc/en-us/articles/12377510689943-The-error-in-Plesk-ERR-panel-SQLSTATE-HY000-2002-No-such-file-or-directory-Can-t-connect-to-local-MySQL-server-through-socket

is that possible ?
is that correct ?
grep mysql.sock /etc/my.cnf
socket=/var/lib/mysql/mysql.sock

grep mysql.sock /etc/psa/psa.conf
MYSQL_SOCKET /var/lib/mysql/mysql.sock

grep mysql.sock /usr/local/psa/admin/conf/php.ini
pdo_mysql.default_socket="/var/lib/mysql/mysql.sock"

???

 

[flieg4bei]

root@/media/ftp# systemctl status mariadb.service
● mariadb.service - MariaDB 10.1.48 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; bad; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf, restorecon_socket.conf
Active: activating (start) since Fri 2024-03-15 01:07:08 CET; 7s ago
Docs: man:mysqld(8)
systemd
Process: 14912 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status
Process: 14906 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 14894 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 14990 (mysqld)
Tasks: 2 (limit: 4557)
CGroup: /system.slice/mariadb.service
└─14990 /usr/sbin/mysqld

 

[flieg4bei]

CLOSE
i install now a new ubuntu and i hope backup works