Resolved Server Error500 Plesk\Exception\DatabaseDB query failed: SQLSTATE[HY000] [2002] No such file or directory

[signguy007]

Server operating system version

Redhat EL 7.9-64

Plesk version and microupdate number

Plesk Obsidian 18.0.53.2

[root@xxxx4 /]# journalctl -xe -u mariadb

--

-- Unit mariadb.service has finished shutting down.

Jul 15 22:23:08 xxxxx.com systemd[1]: Starting MariaDB database server...

-- Subject: Unit mariadb.service has begun start-up

-- Defined-By: systemd

-- Support: systemd-devel Info Page

--

-- Unit mariadb.service has begun starting up.

Jul 15 22:23:08 xxxxx.com mariadb-prepare-db-dir[21272]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.

Jul 15 22:23:08 xxxx.com mariadb-prepare-db-dir[21272]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.

Jul 15 22:23:08 xxxx.com mysqld_safe[21308]: 230715 22:23:08 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.

Jul 15 22:23:08 xxxx.com mysqld_safe[21308]: 230715 22:23:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Jul 15 22:23:09 xxxx.com systemd[1]: mariadb.service: control process exited, code=exited status=1

Jul 15 22:23:09 xxxx.com systemd[1]: Failed to start MariaDB database server.

-- Subject: Unit mariadb.service has failed

-- Defined-By: systemd

-- Support: systemd-devel Info Page

--

-- Unit mariadb.service has failed.

--

-- The result is failed.

Jul 15 22:23:09 xxxx.com systemd[1]: Unit mariadb.service entered failed state.

Jul 15 22:23:09 xxxx.com systemd[1]: mariadb.service failed.

Jul 15 22:23:14 xxxxx.com systemd[1]: mariadb.service holdoff time over, scheduling restart.

Jul 15 22:23:14 xxxxxs.com systemd[1]: Stopped MariaDB database server.

-- Subject: Unit mariadb.service has finished shutting down

-- Defined-By: systemd

-- Support: systemd-devel Info Page

--

-- Unit mariadb.service has finished shutting down.

Jul 15 22:23:14 xxxxx.com systemd[1]: Starting MariaDB database server...

-- Subject: Unit mariadb.service has begun start-up

-- Defined-By: systemd

-- Support: systemd-devel Info Page

--

-- Unit mariadb.service has begun starting up.

Jul 15 22:23:14 xxxxx.com mariadb-prepare-db-dir[21529]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.

Jul 15 22:23:14 xxxx.com mariadb-prepare-db-dir[21529]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.

Jul 15 22:23:14 xxxxx.com mysqld_safe[21565]: 230715 22:23:14 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.

Jul 15 22:23:14xxxxx.com mysqld_safe[21565]: 230715 22:23:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Jul 15 22:23:15 xxxxx.com systemd[1]: mariadb.service: control process exited, code=exited status=1

Jul 15 22:23:15 xxxxx.com systemd[1]: Failed to start MariaDB database server.

-- Subject: Unit mariadb.service has failed

-- Defined-By: systemd

-- Support: systemd-devel Info Page

--

-- Unit mariadb.service has failed.

--

-- The result is failed.

Jul 15 22:23:15 xxx.com systemd[1]: Unit mariadb.service entered failed state.

Jul 15 22:23:15 xxx.com systemd[1]: mariadb.service failed.

 

[Peter Debik]

What is the output of
# sestatus
?

 

[signguy007]

sestatus
SELinux status: disabled

 

[signguy007]

resolved. IBM/softlayer took a look

ibdata1 was corrupt.

https://support.plesk.com/hc/en-us/articles/12377437325079-Plesk-is-not-accessible-and-MariaDB-service-cannot-start-InnoDB-Error-space-header-page-consists-of-zero-bytes-in-data-file-ibdata1