MariaDB not starting EFA4

Bugs in eFa 4
Post Reply
Alleyviper
Posts: 83
Joined: 16 Oct 2018 05:55
Location: Portugal

MariaDB not starting EFA4

Post by Alleyviper »

Hello All,

Received an alert regarding Database, tried to login to EFA WEB and this shows up
2.JPG
2.JPG (22.4 KiB) Viewed 48302 times
On the server I got this :o
1.JPG
1.JPG (87.83 KiB) Viewed 48302 times
What can I do?
Alleyviper
Posts: 83
Joined: 16 Oct 2018 05:55
Location: Portugal

Re: MariaDB not starting EFA4

Post by Alleyviper »

MariaDB-server not installed?
6.JPG
6.JPG (15.96 KiB) Viewed 48300 times

What?
4.JPG
4.JPG (126.5 KiB) Viewed 48300 times

:shifty: :shifty: :shifty: :shifty: :shifty: :shifty:
7.JPG
7.JPG (46.04 KiB) Viewed 48300 times
Alleyviper
Posts: 83
Joined: 16 Oct 2018 05:55
Location: Portugal

Re: MariaDB not starting EFA4

Post by Alleyviper »

Received Cron email
8.JPG
8.JPG (23.79 KiB) Viewed 48298 times
henk
Posts: 517
Joined: 14 Dec 2015 22:16
Location: Netherlands
Contact:

Re: MariaDB not starting EFA4

Post by henk »

You jump to conclusions and mixUP Mariadb versions!!

Code: Select all

rpm -qa --last |grep maria
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

Code: Select all

yum list installed |grep maria
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 :naughty:
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
Alleyviper
Posts: 83
Joined: 16 Oct 2018 05:55
Location: Portugal

Re: MariaDB not starting EFA4

Post by Alleyviper »

Hi Henk,

Thanks for the tip. I have this:
maria.JPG
maria.JPG (58.02 KiB) Viewed 48287 times
henk
Posts: 517
Joined: 14 Dec 2015 22:16
Location: Netherlands
Contact:

Re: MariaDB not starting EFA4

Post by henk »

Check the mysql log why mariadb is not able to start

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
Alleyviper
Posts: 83
Joined: 16 Oct 2018 05:55
Location: Portugal

Re: MariaDB not starting EFA4

Post by Alleyviper »

Hi Henk,

Where can I find myqsl log
henk
Posts: 517
Joined: 14 Dec 2015 22:16
Location: Netherlands
Contact:

Re: MariaDB not starting EFA4

Post by henk »

In /var/log ( what's in a name) there are a bunch of usefull logs.

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
Alleyviper
Posts: 83
Joined: 16 Oct 2018 05:55
Location: Portugal

Re: MariaDB not starting EFA4

Post by Alleyviper »

Hi Henk,

As I can tell the innodb Database is corrupted. Anyway to fix?
Alleyviper
Posts: 83
Joined: 16 Oct 2018 05:55
Location: Portugal

Re: MariaDB not starting EFA4

Post by Alleyviper »

Hi Henk,

I had to reinstall the system. Have two mx servers :doh:
User avatar
pdwalker
Posts: 1553
Joined: 18 Mar 2015 09:16

Re: MariaDB not starting EFA4

Post by pdwalker »

Alleyviper wrote: 05 Oct 2020 19:49 Hi Henk,

As I can tell the innodb Database is corrupted. Anyway to fix?
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.

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.
User avatar
shawniverson
Posts: 3644
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: MariaDB not starting EFA4

Post by shawniverson »

Post Reply