Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
MySQL / Failed to start MariaDB 10.1.45 database server.
« on: February 18, 2021, 10:43:25 AM »
Hello, I have problem. I get this error when I write "systemctl restart mariadb" on putty ssh. "Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. After "systemctl status mariadb.service"
● mariadb.service - MariaDB 10.1.45 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Thu 2021-02-18 05:18:57 EST; 6s ago
Docs: man:mysqld(
https://mariadb.com/kb/en/library/systemd/
Process: 23359 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 23348 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 23346 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 23359 (code=exited, status=1/FAILURE)
Feb 18 05:18:57 localhost.localdomain systemd[1]: Starting MariaDB 10.1.45 database server...
Feb 18 05:18:57 localhost.localdomain sh[23348]: [102B blob data]
Feb 18 05:18:57 localhost.localdomain sh[23348]: Fatal error in defaults handling. Program aborted
Feb 18 05:18:57 localhost.localdomain mysqld[23359]: [92B blob data]
Feb 18 05:18:57 localhost.localdomain mysqld[23359]: Fatal error in defaults handling. Program aborted
Feb 18 05:18:57 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 18 05:18:57 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1.45 database server.
Feb 18 05:18:57 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Feb 18 05:18:57 localhost.localdomain systemd[1]: mariadb.service failed.
and after "journalctl -xe"
Feb 18 05:20:26 localhost.localdomain named[1039]: client @0x7fa8300c5e30 67.186.81.99#9691 (.): query (cache) './ANY/IN' denied
Feb 18 05:20:26 localhost.localdomain named[1039]: client @0x7fa8300e2d70 67.186.81.99#9691 (.): query (cache) './ANY/IN' denied
Feb 18 05:20:26 localhost.localdomain named[1039]: client @0x7fa8300d45d0 67.186.81.99#9691 (.): query (cache) './ANY/IN' denied
Feb 18 05:20:28 localhost.localdomain systemd[1]: Starting MariaDB 10.1.45 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Feb 18 05:20:28 localhost.localdomain sh[23624]: [102B blob data]
Feb 18 05:20:28 localhost.localdomain sh[23624]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:28 localhost.localdomain mysqld[23635]: [92B blob data]
Feb 18 05:20:28 localhost.localdomain mysqld[23635]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:28 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 18 05:20:28 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1.45 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Feb 18 05:20:28 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Feb 18 05:20:28 localhost.localdomain systemd[1]: mariadb.service failed.
Feb 18 05:20:39 localhost.localdomain systemd[1]: Starting MariaDB 10.1.45 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Feb 18 05:20:39 localhost.localdomain sh[23650]: [102B blob data]
Feb 18 05:20:39 localhost.localdomain sh[23650]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:39 localhost.localdomain mysqld[23661]: [92B blob data]
Feb 18 05:20:39 localhost.localdomain mysqld[23661]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:39 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 18 05:20:39 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1.45 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Feb 18 05:20:39 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Feb 18 05:20:39 localhost.localdomain systemd[1]: mariadb.service failed.
Feb 18 05:20:39 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:40 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00.... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:41 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:42 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:43 localhost.localdomain kernel: Firewall: *TCP_IN Blocked* IN=ens160 OUT= MAC=00:50:56:88:31... SRC=175.24.44.131 DST=213.238.178.89 LEN=60 TOS=0x00 PREC=0x00
Feb 18 05:20:44 localhost.localdomain kernel: Firewall: *TCP_IN Blocked* IN=ens160 OUT= MAC=00:50:56:88:31:... SRC=92.63.197.61 DST=213.238.178.89 LEN=40 TOS=0x00 PREC=0x00 T
lines 1997-2047/2047 (END)
please help me
● mariadb.service - MariaDB 10.1.45 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Thu 2021-02-18 05:18:57 EST; 6s ago
Docs: man:mysqld(
https://mariadb.com/kb/en/library/systemd/
Process: 23359 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 23348 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 23346 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 23359 (code=exited, status=1/FAILURE)
Feb 18 05:18:57 localhost.localdomain systemd[1]: Starting MariaDB 10.1.45 database server...
Feb 18 05:18:57 localhost.localdomain sh[23348]: [102B blob data]
Feb 18 05:18:57 localhost.localdomain sh[23348]: Fatal error in defaults handling. Program aborted
Feb 18 05:18:57 localhost.localdomain mysqld[23359]: [92B blob data]
Feb 18 05:18:57 localhost.localdomain mysqld[23359]: Fatal error in defaults handling. Program aborted
Feb 18 05:18:57 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 18 05:18:57 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1.45 database server.
Feb 18 05:18:57 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Feb 18 05:18:57 localhost.localdomain systemd[1]: mariadb.service failed.
and after "journalctl -xe"
Feb 18 05:20:26 localhost.localdomain named[1039]: client @0x7fa8300c5e30 67.186.81.99#9691 (.): query (cache) './ANY/IN' denied
Feb 18 05:20:26 localhost.localdomain named[1039]: client @0x7fa8300e2d70 67.186.81.99#9691 (.): query (cache) './ANY/IN' denied
Feb 18 05:20:26 localhost.localdomain named[1039]: client @0x7fa8300d45d0 67.186.81.99#9691 (.): query (cache) './ANY/IN' denied
Feb 18 05:20:28 localhost.localdomain systemd[1]: Starting MariaDB 10.1.45 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Feb 18 05:20:28 localhost.localdomain sh[23624]: [102B blob data]
Feb 18 05:20:28 localhost.localdomain sh[23624]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:28 localhost.localdomain mysqld[23635]: [92B blob data]
Feb 18 05:20:28 localhost.localdomain mysqld[23635]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:28 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 18 05:20:28 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1.45 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Feb 18 05:20:28 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Feb 18 05:20:28 localhost.localdomain systemd[1]: mariadb.service failed.
Feb 18 05:20:39 localhost.localdomain systemd[1]: Starting MariaDB 10.1.45 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Feb 18 05:20:39 localhost.localdomain sh[23650]: [102B blob data]
Feb 18 05:20:39 localhost.localdomain sh[23650]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:39 localhost.localdomain mysqld[23661]: [92B blob data]
Feb 18 05:20:39 localhost.localdomain mysqld[23661]: Fatal error in defaults handling. Program aborted
Feb 18 05:20:39 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 18 05:20:39 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1.45 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Feb 18 05:20:39 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Feb 18 05:20:39 localhost.localdomain systemd[1]: mariadb.service failed.
Feb 18 05:20:39 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:40 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00.... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:41 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:42 localhost.localdomain kernel: Firewall: *UDP_IN Blocked* IN=ens160 OUT= MAC=ff:ff:ff:ff:ff:ff:00... SRC=84.54.12.210 DST=255.255.255.255 LEN=201 TOS=0x00 PREC=0x00
Feb 18 05:20:43 localhost.localdomain kernel: Firewall: *TCP_IN Blocked* IN=ens160 OUT= MAC=00:50:56:88:31... SRC=175.24.44.131 DST=213.238.178.89 LEN=60 TOS=0x00 PREC=0x00
Feb 18 05:20:44 localhost.localdomain kernel: Firewall: *TCP_IN Blocked* IN=ens160 OUT= MAC=00:50:56:88:31:... SRC=92.63.197.61 DST=213.238.178.89 LEN=40 TOS=0x00 PREC=0x00 T
lines 1997-2047/2047 (END)
please help me
Pages: [1]
