Page 2 of 4
Re: Recurring Database Connection Error
Posted: Fri Oct 20, 2017 3:23 am
by tacolover101
[root@localhost mariadb]# tail mariadb.log
171013 16:29:33 InnoDB: remove old data files which contain your precious data!
171013 16:29:33 [ERROR] Plugin 'InnoDB' init function returned error.
171013 16:29:33 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
171013 16:29:33 [Note] Plugin 'FEEDBACK' is disabled.
171013 16:29:33 [ERROR] Unknown/unsupported storage engine: InnoDB
171013 16:29:33 [ERROR] Aborting
171013 16:29:33 [Note] /usr/libexec/mysqld: Shutdown complete
171013 16:29:33 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
i think this is where your issue lies.
https://stackoverflow.com/questions/264 ... d-when-sta
Re: Recurring Database Connection Error
Posted: Fri Oct 20, 2017 10:19 am
by npolovenko
Thanks,
@tacolover101.
@venturegardengroup, Go ahead and increase the InnoDB buffer size:
Code: Select all
/etc/mysql/my.cnf:
or the path could be
/etc/my.cnf
change this line
innodb_buffer_pool_size = 10M
After that restart your maraDB with
Also restart nagios with
and
If that doesn't solve the issue please upload your system profile. You can generate a profile manually using the script at /usr/local/nagiosxi/html/includes/components/profile/getprofile.sh
That should generate a profile in /usr/local/nagiosxi/var/components/ which you can get off the server with an application such as FileZilla.
If you get an error that PROFILE BUILD FAILED, please see
https://support.nagios.com/kb/article.p ... ategory=44
Re: Recurring Database Connection Error
Posted: Mon Oct 23, 2017 4:44 am
by venturegardengroup
Hello npolovenko,
Please find attached the outputs I got from following the instructions you laid out.
Regards,
Re: Recurring Database Connection Error
Posted: Mon Oct 23, 2017 11:20 am
by npolovenko
@venturegardengroup, Can you try running the script as a root user:
Code: Select all
mkdir /usr/local/nagiosxi/var/components/profile/
cd /usr/local/nagiosxi/html/includes/components/profile/
sudo ./getprofile.sh
Re: Recurring Database Connection Error
Posted: Tue Oct 24, 2017 3:31 am
by venturegardengroup
Hello npolovenko,
Please find attached. Looking forward to your feedback. Thanks.
Re: Recurring Database Connection Error
Posted: Tue Oct 24, 2017 10:51 am
by npolovenko
@venturegardengroup,
Please remove this two files:
Code: Select all
rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1
after that:
service mysqld restart
Also, lets try to run repair_databses as sudo:
Code: Select all
cd /usr/local/nagiosxi/scripts
sudo ./repair_databases.sh
Please run this command to check the storage space on the root partition.
Finally, please send us the contents of your my.cnf file located at:
Re: Recurring Database Connection Error
Posted: Wed Oct 25, 2017 7:05 am
by venturegardengroup
Hello npolovenko,
Thanks for the update. I have attached the outputs from the steps you suggested.
Regards,
Re: Recurring Database Connection Error
Posted: Wed Oct 25, 2017 10:02 am
by npolovenko
@venturegardengroup , Please remove ibdata1 file from /var/lib/mysql/
After that please run:
Code: Select all
service httpd restart
service mariadb restart
Let us know whether both services started.
Re: Recurring Database Connection Error
Posted: Fri Oct 27, 2017 5:34 am
by venturegardengroup
Hello npolovenko,
Both services failed to start. See outputs attached.
Re: Recurring Database Connection Error
Posted: Fri Oct 27, 2017 10:27 am
by npolovenko
@venturegardengroup, Ok, so the biggest problem we have is broken MySQL. Without MYSQL running Nagios will not work. We'd need to see more related log files. Please run the commands below and then upload info1, info2 and info3 files here.
Code: Select all
yum list installed >/tmp/info1.txt
cat /etc/my.cnf.d/* >>/tmp/info2.txt
tail -100 /var/log/mariadb/mariadb.log >>/tmp/info3.txt