Page 1 of 1
MariaDB not starting EFA4
Posted: 04 Oct 2020 09:33
by Alleyviper
Hello All,
Received an alert regarding Database, tried to login to EFA WEB and this shows up
- 2.JPG (22.4 KiB) Viewed 71035 times
On the server I got this
- 1.JPG (87.83 KiB) Viewed 71035 times
What can I do?
Re: MariaDB not starting EFA4
Posted: 04 Oct 2020 09:58
by Alleyviper
Re: MariaDB not starting EFA4
Posted: 04 Oct 2020 10:02
by Alleyviper
Received Cron email
- 8.JPG (23.79 KiB) Viewed 71031 times
Re: MariaDB not starting EFA4
Posted: 04 Oct 2020 14:17
by henk
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 
Re: MariaDB not starting EFA4
Posted: 04 Oct 2020 14:27
by Alleyviper
Hi Henk,
Thanks for the tip. I have this:
- maria.JPG (58.02 KiB) Viewed 71020 times
Re: MariaDB not starting EFA4
Posted: 04 Oct 2020 14:33
by henk
Check the mysql log why mariadb is not able to start
the mysql root pwd is in
Re: MariaDB not starting EFA4
Posted: 04 Oct 2020 14:57
by Alleyviper
Hi Henk,
Where can I find myqsl log
Re: MariaDB not starting EFA4
Posted: 04 Oct 2020 17:25
by henk
In /var/log ( what's in a name) there are a bunch of usefull logs.
The mysqllog
Re: MariaDB not starting EFA4
Posted: 05 Oct 2020 19:49
by Alleyviper
Hi Henk,
As I can tell the innodb Database is corrupted. Anyway to fix?
Re: MariaDB not starting EFA4
Posted: 05 Oct 2020 20:34
by Alleyviper
Hi Henk,
I had to reinstall the system. Have two mx servers
Re: MariaDB not starting EFA4
Posted: 06 Oct 2020 04:33
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.
Re: MariaDB not starting EFA4
Posted: 18 Oct 2020 21:50
by shawniverson
