The Ultimate Guide to High Availability with MariaDB

mariadb.service doesnt start, here are the log:

[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?

Comments

Comments loading...
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.