Resolved I cannot log in to Plesk because MariaDB does not start.

[Yuki]

I'm full on my server and MariaDB crashes.
I gave additional space and solved the capacity problem.

However, MariaDB does not start.
Why can't I start?
Memory and space issues have been resolved.
I used PleskRepair, but MariaDB does not respond.

The following is the error content.

-------

● mariadb.service-MariaDB 10.1.40 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2019-08-08 14:15:11 JST; 6s ago
Docs: man: mysqld (8)
systemd
Process: 7753 ExecStart = / usr / sbin / mysqld $ MYSQLD_OPTS $ _WSREP_NEW_CLUSTER $ _WSREP_START_POSITION (code = exited, status = 1 / FAILURE)
Process: 7670 ExecStartPre = / bin / sh -c [! -E / usr / bin / galera_recovery] && VAR = || VAR = `/ usr / bin / galera_recovery`; [$? -Eq 0] && systemctl set-environment _WSREP_START_POSITION = $ VAR || e
Process: 7663 ExecStartPre = / bin / sh -c systemctl unset-environment _WSREP_START_POSITION (code = exited, status = 0 / SUCCESS)
Process: 7651 ExecStartPre = / usr / bin / install -m 755 -o mysql -g root -d / var / run / mysqld (code = exited, status = 0 / SUCCESS)
Main PID: 7753 (code = exited, status = 1 / FAILURE)
Status: "MariaDB server is down"

Aug 08 14:15:08 plesk-s-4vcpu-8gb-nyc1-01.local systemd [1]: Starting MariaDB 10.1.40 database server ...
Aug 08 14:15:08 plesk-s-4vcpu-8gb-nyc1-01.local mysqld [7753]: 2019-08-08 14:15:08 140193617976448 [Note] / usr / sbin / mysqld (mysqld 10.1.40 -MariaDB-0ubuntu0.18.04.1) starting as process 7753 ...
Aug 08 14:15:11 plesk-s-4vcpu-8gb-nyc1-01.local systemd [1]: mariadb.service: Main process exited, code = exited, status = 1 / FAILURE
Aug 08 14:15:11 plesk-s-4vcpu-8gb-nyc1-01.local systemd [1]: mariadb.service: Failed with result 'exit-code'.
Aug 08 14:15:11 plesk-s-4vcpu-8gb-nyc1-01.local systemd [1]: Failed to start MariaDB 10.1.40 database server.
------

Aug 08 14:14:02 plesk-s-4vcpu-8gb-nyc1-01.local sshd [7396]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/ var / run / mysqld / mysqld.sock '(2)
Aug 08 14:14:03 plesk-s-4vcpu-8gb-nyc1-01.local CRON [7400]: pam_unix (cron: session): session closed for user root
Aug 08 14:14:04 plesk-s-4vcpu-8gb-nyc1-01.local sshd [7396]: Failed password for invalid user cristina from 179.145.51.98 port 48340 ssh2
Aug 08 14:14:04 plesk-s-4vcpu-8gb-nyc1-01.local sshd [7396]: Received disconnect from 179.145.51.98 port 48340: 11: Bye Bye [preauth]
Aug 08 14:14:04 plesk-s-4vcpu-8gb-nyc1-01.local sshd [7396]: Disconnected from invalid user cristina 179.145.51.98 port 48340 [preauth]
Aug 08 14:14:04 plesk-s-4vcpu-8gb-nyc1-01.local systemd [1]: Starting MariaDB 10.1.40 database server ...
-Subject: Unit mariadb.service has begun start-up
-Defined-By: systemd
-Support: Support and management | Ubuntu
-
-Unit mariadb.service has begun starting up.
Aug 08 14:14:05 plesk-s-4vcpu-8gb-nyc1-01.local mysqld [7556]: 2019-08-08 14:14:05 139957365320832 [Note] / usr / sbin / mysqld (mysqld 10.1.40 -MariaDB-0ubuntu0.18.04.1) starting as process 7556 ...
Aug 08 14:14:08 plesk-s-4vcpu-8gb-nyc1-01.local systemd [1]: mariadb.service: Main process exited, code = exited, status = 1 / FAILURE
Aug 08 14:14:08 plesk-s-4vcpu-8gb-nyc1-01.local systemd [1]: mariadb.service: Failed with result 'exit-code'.
Aug 08 14:14:08 plesk-s-4vcpu-8gb-nyc1-01.local systemd [1]: Failed to start MariaDB 10.1.40 database server.
-Subject: Unit mariadb.service has failed
-Defined-By: systemd
-Support: Support and management | Ubuntu
-
-Unit mariadb.service has failed.

 

[mrsombre]

Hello, can you add some important information, please:
- Version of plesk (type in cli `plesk version`)
- Do you change mariadb configuration or it is default

Log file is good source of information:
- Go to /var/log/mysql and rename error.log file to error.log.bak
- Restart mysql by `service mysql restart` command
- Open error.log created after restart and look for any errors and warnings
- Add it to this topic

 

[Yuki]

Hi, Sir.
I just got solved this issue.

I was Detele "/etc/mysql/tc.log"

Just work right now.

Thank you for support bro!

 

[mrsombre]

Just work right now.

Great! It was easier than I thought =)