Question MariaDB doesn't start after upgrade

[HerrMatze]

Server operating system version

Debian 10

Plesk version and microupdate number

Plesk Obsidian 18.0.61.3

Hello folks,

i have a big problem, MariaDB doesn't start after upgrade.

Plesk-Page shows follow

Type	Plesk\Exception\Database
Message	DB query failed: SQLSTATE[HY000] [2002] No such file or directory
File	Mysql.php
Line	79

The output in Putty by "journalctl -xe"

May 22 20:09:42 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
May 22 20:09:42 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:42 0 [Note] InnoDB: Number of transaction pools: 1
May 22 20:09:42 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:42 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
May 22 20:09:42 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:42 0 [Note] InnoDB: Using Linux native AIO
May 22 20:09:42 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:42 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
May 22 20:09:42 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:42 0 [Note] InnoDB: Completed initialization of buffer pool
May 22 20:09:42 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:42 0 [ERROR] InnoDB: File ./ib_logfile0 was not found
May 22 20:09:42 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:42 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
May 22 20:09:42 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:42 0 [Note] InnoDB: Starting shutdown...
May 22 20:09:43 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:43 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
May 22 20:09:43 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:43 0 [Note] Plugin 'FEEDBACK' is disabled.
May 22 20:09:43 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:43 0 [ERROR] Unknown/unsupported storage engine: InnoDB
May 22 20:09:43 s1.dermatze.net mariadbd[23609]: 2024-05-22 20:09:43 0 [ERROR] Aborting
May 22 20:09:43 s1.dermatze.net systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: Debian -- User Support
--
-- An ExecStart= process belonging to unit mariadb.service has exited.
--
-- The process' exit code is 'exited' and its exit status is 1.
May 22 20:09:43 s1.dermatze.net systemd[1]: mariadb.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: Debian -- User Support
--
-- The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
May 22 20:09:43 s1.dermatze.net systemd[1]: Failed to start MariaDB 10.11.8 database server.
-- Subject: A start job for unit mariadb.service has failed
-- Defined-By: systemd
-- Support: Debian -- User Support
--
-- A start job for unit mariadb.service has finished with a failure.
--
-- The job identifier is 28358 and the job result is failed.
May 22 20:09:43 s1.dermatze.net systemd[1]: Started Plesk Web Socket Service.
-- Subject: A start job for unit plesk-web-socket.service has finished successfully
-- Defined-By: systemd
-- Support: Debian -- User Support
--
-- A start job for unit plesk-web-socket.service has finished successfully.
--
-- The job identifier is 28290.
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: [2024-05-22 20:09:43.253] 23614:664e34e73d8ea ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: 0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: 1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:113
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: CommonPanel_Application_Abstract::initDbAdapter()
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: 2: /opt/psa/admin/plib/Session/Helper.php:176
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: Plesk\Session\Helper::initStorage()
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: 3: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:48
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: CommonPanel_Application_Abstract->run()
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: 4: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:30
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: CommonPanel_Application_Abstract::init()
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: 5: /opt/psa/admin/plib/pm/Bootstrap.php:18
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: pm_Bootstrap::init()
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: 6: /opt/psa/admin/plib/sdk.php:11
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: require_once(string '/opt/psa/admin/plib/sdk.php')
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: 7: /opt/psa/admin/plib/WebSocket/bin/ws-server.php:3
May 22 20:09:43 s1.dermatze.net sw-engine-pleskrun[23614]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] No such file or directory (Mysql.php:79)
May 22 20:09:43 s1.dermatze.net systemd[1]: plesk-web-socket.service: Main process exited, code=exited, status=1/FAILURE
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: Debian -- User Support
--
-- An ExecStart= process belonging to unit plesk-web-socket.service has exited.
--
-- The process' exit code is 'exited' and its exit status is 1.
May 22 20:09:43 s1.dermatze.net systemd[1]: plesk-web-socket.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: Debian -- User Support
--
-- The unit plesk-web-socket.service has entered the 'failed' state with result 'exit-code'.
May 22 20:09:43 s1.dermatze.net postfix/smtpd[23019]: connect from unknown[80.244.11.152]
May 22 20:09:43 s1.dermatze.net plesk_saslauthd[23346]: failed mail authentication attempt for user 'rs2' (password len=4)
May 22 20:09:43 s1.dermatze.net postfix/smtpd[23019]: warning: unknown[80.244.11.152]: SASL LOGIN authentication failed: authentication failure
May 22 20:09:43 s1.dermatze.net postfix/smtpd[23019]: lost connection after AUTH from unknown[80.244.11.152]
May 22 20:09:43 s1.dermatze.net postfix/smtpd[23019]: disconnect from unknown[80.244.11.152] ehlo=1 auth=0/1 rset=1 commands=2/3
May 22 20:09:45 s1.dermatze.net grafana[1306]: logger=alerting.evalContext t=2024-05-22T20:09:45.062916084+02:00 level=error msg="Alert Rule Result Error" ruleId=16 name="Partition \"/boot\" – Nutzung" error="request handler response error {invalid status code. status: 500 Internal Server Error A <nil> [] [] 0xc002
lines 2178-2257/2257 (END)

Everyone have any idea how can i fix?
I have show many pages, but not found the right

 

[Kaspar@Plesk]

The issue you describe seems to match the issue described in this support article, which also propses a (possible) resolution.

https://support.plesk.com/hc/en-us/articles/12377560870935-Unable-to-start-MySQL-MariaDB-after-upgrading-it-on-a-Plesk-for-Linux-server-Unknown-unsupported-storage-engine-InnoDB

 

[HerrMatze]

If i type "mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -h127.0.0.1 --protocol=tcp shutdown" then comes

mysqladmin: connect to server at '127.0.0.1' failed
error: 'Can't connect to server on '127.0.0.1' (115)'
Check that mariadbd is running and that the socket: '/run/mysqld/mysqld.sock' exists!

The resolution doesn't work for me

 

[Kaspar@Plesk]

I recommend to contact Plesk support for assistance. To sign-in to support please go to https://support.plesk.com

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk