MariaDB not starting EFA4
-
- Posts: 83
- Joined: 16 Oct 2018 05:55
- Location: Portugal
MariaDB not starting EFA4
Hello All,
Received an alert regarding Database, tried to login to EFA WEB and this shows up
On the server I got this
What can I do?
Received an alert regarding Database, tried to login to EFA WEB and this shows up
On the server I got this
What can I do?
-
- Posts: 83
- Joined: 16 Oct 2018 05:55
- Location: Portugal
Re: MariaDB not starting EFA4
MariaDB-server not installed?
What?
What?
-
- Posts: 83
- Joined: 16 Oct 2018 05:55
- Location: Portugal
Re: MariaDB not starting EFA4
Received Cron email
Re: MariaDB not starting EFA4
You jump to conclusions and mixUP Mariadb versions!!
mariadb101u-devel-10.1.41-1.el7.ius.x86_64 Sat 29 Feb 2020 09:54:39 PM CET
mariadb101u-server-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:39 PM CET
mariadb101u-errmsg-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:21 PM CET
mariadb101u-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:21 PM CET
mariadb101u-libs-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:19 PM CET
mariadb101u-config-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:19 PM CET
mariadb101u-common-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:19 PM CET
or use yum and also view the repo used
mariadb101u.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-common.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-config.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-devel.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-errmsg.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-libs.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-server.x86_64 1:10.1.41-1.el7.ius @ius
“A learning experience is one of those things that says, 'You know that thing you just did? Don't do that.” -Douglas Adams
Code: Select all
rpm -qa --last |grep maria
mariadb101u-server-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:39 PM CET
mariadb101u-errmsg-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:21 PM CET
mariadb101u-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:21 PM CET
mariadb101u-libs-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:19 PM CET
mariadb101u-config-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:19 PM CET
mariadb101u-common-10.1.41-1.el7.ius.x86_64 Fri 15 Nov 2019 08:16:19 PM CET
or use yum and also view the repo used
Code: Select all
yum list installed |grep maria
mariadb101u-common.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-config.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-devel.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-errmsg.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-libs.x86_64 1:10.1.41-1.el7.ius @ius
mariadb101u-server.x86_64 1:10.1.41-1.el7.ius @ius
“A learning experience is one of those things that says, 'You know that thing you just did? Don't do that.” -Douglas Adams
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
-
- Posts: 83
- Joined: 16 Oct 2018 05:55
- Location: Portugal
Re: MariaDB not starting EFA4
Hi Henk,
Thanks for the tip. I have this:
Thanks for the tip. I have this:
Re: MariaDB not starting EFA4
Check the mysql log why mariadb is not able to start
the mysql root pwd is in
the mysql root pwd is in
Code: Select all
/etc/eFa/MySQL-Config
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
-
- Posts: 83
- Joined: 16 Oct 2018 05:55
- Location: Portugal
Re: MariaDB not starting EFA4
Hi Henk,
Where can I find myqsl log
Where can I find myqsl log
Re: MariaDB not starting EFA4
In /var/log ( what's in a name) there are a bunch of usefull logs.
The mysqllog
The mysqllog
Code: Select all
/var/log/mariadb/mariadb.log
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
-
- Posts: 83
- Joined: 16 Oct 2018 05:55
- Location: Portugal
Re: MariaDB not starting EFA4
Hi Henk,
As I can tell the innodb Database is corrupted. Anyway to fix?
As I can tell the innodb Database is corrupted. Anyway to fix?
-
- Posts: 83
- Joined: 16 Oct 2018 05:55
- Location: Portugal
Re: MariaDB not starting EFA4
Hi Henk,
I had to reinstall the system. Have two mx servers
I had to reinstall the system. Have two mx servers
Re: MariaDB not starting EFA4
I have never seen a corrupted innodb file in over 15 years of running many mysql databases, even from crashes and hangs caused by full file systems. Maybe I'm lucky.Alleyviper wrote: ↑05 Oct 2020 19:49 Hi Henk,
As I can tell the innodb Database is corrupted. Anyway to fix?
1/ What led up to this problem?
2/ is your file system ok? is there an underlying problem with the hardware?
3/ the log files should contain some clue as to what actually happened - going back through the log to find the time the problem first occurred will tell you a lot more about what is actually happening.
Otherwise, there is not enough information.
Lessons:
- maintain your backups.
- error logs are your friend.
- "innodb_file_per_table = 1" is your friend. Use it, if you are not already.
- shawniverson
- Posts: 3650
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact: