mariadb.service doesnt start, here are the log: - Source

Revision: 94800
User: Theodor Dimitriou
Date: 2020-04-15 12:33

[root@h2769420 etc]# systemctl status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Mi 2020-04-15 15:29:20 EEST; 2s ago
  Process: 1732 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
  Process: 1731 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 1695 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 1731 (code=exited, status=0/SUCCESS)

Apr 15 15:29:19 h2769420.stratoserver.net mariadb-prepare-db-dir[1695]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Apr 15 15:29:19 h2769420.stratoserver.net mysqld_safe[1731]: 200415 15:29:19 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Apr 15 15:29:19 h2769420.stratoserver.net mysqld_safe[1731]: 200415 15:29:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

[root@h2769420 etc]# journalctl -xe
Apr 15 15:31:55 h2769420.stratoserver.net sw-engine-pleskrun[7984]: 6: /usr/local/psa/admin/plib/sdk.php:12
Apr 15 15:31:55 h2769420.stratoserver.net sw-engine-pleskrun[7984]: require_once(string '/usr/local/psa/admin/plib/sdk.php')
Apr 15 15:31:55 h2769420.stratoserver.net sw-engine-pleskrun[7984]: 7: /usr/local/psa/admin/plib/WebSocket/bin/ws-server.php:3
Apr 15 15:31:55 h2769420.stratoserver.net sw-engine-pleskrun[7984]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:60)
Apr 15 15:31:56 h2769420.stratoserver.net sshd[7486]: Connection closed by 106.12.185.84 port 46548 [preauth]
Apr 15 15:32:00 h2769420.stratoserver.net mariadb-prepare-db-dir[7989]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Apr 15 15:32:00 h2769420.stratoserver.net mariadb-prepare-db-dir[7989]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Apr 15 15:32:00 h2769420.stratoserver.net mysqld_safe[8025]: 200415 15:32:00 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Apr 15 15:32:01 h2769420.stratoserver.net mysqld_safe[8025]: 200415 15:32:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 15 15:32:01 h2769420.stratoserver.net CROND[8231]: (psaadm) CMD (/usr/local/psa/admin/bin/php -dauto_prepend_file=sdk.php '/usr/local/psa/admin/plib/modules/wp-toolkit/scripts/maintenance.php')
Apr 15 15:32:01 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:01+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=8 name="Apache & PHP-FPM memory usage" error="tsdb.HandleRequest() error 
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: [2020-04-15 15:32:02.215] ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused:
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:60
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 1: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:103
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: CommonPanel_Application_Abstract::initDbAdapter()
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 2: /usr/local/psa/admin/plib/Session/Helper.php:176
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: Plesk\Session\Helper::initStorage()
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 3: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:52
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: CommonPanel_Application_Abstract->run()
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 4: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:34
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: CommonPanel_Application_Abstract::init()
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 5: /usr/local/psa/admin/plib/pm/Bootstrap.php:16
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: pm_Bootstrap::init()
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 6: /usr/local/psa/admin/plib/sdk.php:12
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: require_once(string '/usr/local/psa/admin/plib/sdk.php')
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: 7: /usr/local/psa/admin/plib/WebSocket/bin/ws-server.php:3
Apr 15 15:32:02 h2769420.stratoserver.net sw-engine-pleskrun[8237]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:60)
Apr 15 15:32:04 h2769420.stratoserver.net plesk_saslauthd[6987]: No such user 'craig@stratoserver.net' in mail authorization database
Apr 15 15:32:04 h2769420.stratoserver.net plesk_saslauthd[6987]: failed mail authentication attempt for user 'craig@stratoserver.net' (password len=9)
Apr 15 15:32:04 h2769420.stratoserver.net postfix/smtpd[2607]: warning: unknown[92.118.38.83]: SASL LOGIN authentication failed: authentication failure
Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: Invalid user irc from 94.191.52.53 port 40440
Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: input_userauth_request: invalid user irc [preauth]
Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: pam_unix(sshd:auth): check pass; user unknown
Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=94.191.52.53
Apr 15 15:32:04 h2769420.stratoserver.net sshd[7987]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Apr 15 15:32:04 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:04+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=9 name="nginx memory usage" error="tsdb.HandleRequest() error rpc error: 
Apr 15 15:32:05 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:05+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=14 name="Real memory usage" error="tsdb.HandleRequest() error rpc error: 
Apr 15 15:32:06 h2769420.stratoserver.net postfix/smtpd[2607]: disconnect from unknown[92.118.38.83] ehlo=1 auth=0/1 rset=1 quit=1 commands=3/4
Apr 15 15:32:07 h2769420.stratoserver.net mariadb-prepare-db-dir[8241]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Apr 15 15:32:07 h2769420.stratoserver.net mariadb-prepare-db-dir[8241]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Apr 15 15:32:07 h2769420.stratoserver.net sshd[7987]: Failed password for invalid user irc from 94.191.52.53 port 40440 ssh2
Apr 15 15:32:07 h2769420.stratoserver.net mysqld_safe[8277]: 200415 15:32:07 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Apr 15 15:32:07 h2769420.stratoserver.net mysqld_safe[8277]: 200415 15:32:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 15 15:32:07 h2769420.stratoserver.net sshd[7987]: Received disconnect from 94.191.52.53 port 40440:11: Bye Bye [preauth]
Apr 15 15:32:07 h2769420.stratoserver.net sshd[7987]: Disconnected from 94.191.52.53 port 40440 [preauth]
Apr 15 15:32:07 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:07+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=12 name="Plesk memory usage" error="tsdb.HandleRequest() error rpc error:
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: [2020-04-15 15:32:08.609] ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused:
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:60
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 1: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:103
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: CommonPanel_Application_Abstract::initDbAdapter()
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 2: /usr/local/psa/admin/plib/Session/Helper.php:176
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: Plesk\Session\Helper::initStorage()
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 3: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:52
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: CommonPanel_Application_Abstract->run()
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 4: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:34
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: CommonPanel_Application_Abstract::init()
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 5: /usr/local/psa/admin/plib/pm/Bootstrap.php:16
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: pm_Bootstrap::init()
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 6: /usr/local/psa/admin/plib/sdk.php:12
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: require_once(string '/usr/local/psa/admin/plib/sdk.php')
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: 7: /usr/local/psa/admin/plib/WebSocket/bin/ws-server.php:3
Apr 15 15:32:08 h2769420.stratoserver.net sw-engine-pleskrun[8486]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:60)
Apr 15 15:32:08 h2769420.stratoserver.net grafana-server[1525]: t=2020-04-15T15:32:08+0300 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=10 name="Mail server memory usage" error="tsdb.HandleRequest() error rpc 
lines 937-1001/1001 (END)

Can someone help me fix this error without loosing the databases i already had on this system?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

mariadb.service doesnt start, here are the log: - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB