MariaDB not starting EFA4

[Alleyviper]

Hello All,

Received an alert regarding Database, tried to login to EFA WEB and this shows up

2.JPG (22.4 KiB) Viewed 71025 times

On the server I got this

1.JPG (87.83 KiB) Viewed 71025 times

What can I do?

[Alleyviper]

MariaDB-server not installed?

6.JPG (15.96 KiB) Viewed 71023 times

What?

4.JPG (126.5 KiB) Viewed 71023 times

7.JPG (46.04 KiB) Viewed 71023 times

[Alleyviper]

Received Cron email

8.JPG (23.79 KiB) Viewed 71021 times

[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

[Alleyviper]

Hi Henk,

Thanks for the tip. I have this:

maria.JPG (58.02 KiB) Viewed 71010 times

[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

[Alleyviper]

Hi Henk,

Where can I find myqsl log

[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

[Alleyviper]

Hi Henk,

As I can tell the innodb Database is corrupted. Anyway to fix?

[Alleyviper]

Hi Henk,

I had to reinstall the system. Have two mx servers

[pdwalker]

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.

[shawniverson]

https://github.com/E-F-A/v4/issues/197