Nagios Support Forum

Posted: **Fri Aug 01, 2014 8:40 am**

Server was hung, had to reboot. MySQL won't start and this happens when I try to repair! This is 2012r2.9 server.

[root@iss-chi-nag02 ~]# /usr/local/nagiosxi/scripts/repairmysql.sh nagios
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios ~
Stopping mysqld:                                           [FAILED]
- recovering (with sort) MyISAM-table 'nagios_acknowledgements.MYI'
Data records: 5136
- Fixing index 1
/usr/local/nagiosxi/scripts/repairmysql.sh: line 51:   911 Segmentation fault      (core dumped) $cmd $t
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld:                                           [FAILED]
~

===============
REPAIR COMPLETE
===============

This is in /var/log/messages:

Code: Select all

Aug  1 08:36:30 iss-chi-nag02 kernel: myisamchk[911]: segfault at 0 ip (null) sp 00007fffe0bf27f8 error 14 in myisamchk[400000+15e000]
Aug  1 08:36:30 iss-chi-nag02 abrt[913]: aborting dump: only 0MiB is available on /var/spool/abrt

Posted: **Fri Aug 01, 2014 8:45 am**

Bandit,

Small maybe stupid suggestion, but I had two times a similar issue. One time I had no free space left on logical volume (caused by a super large cleaner.log), the other time i had no free inodes. After solving the issue, I could repair the db.

Grtz

Willem

Posted: **Fri Aug 01, 2014 8:50 am**

WillemDH wrote:Bandit,

Small maybe stupid suggestion, but I had two times a similar issue. One time I had no free space left on logical volume (caused by a super large cleaner.log), the other time i had no free inodes. After solving the issue, I could repair the db.

Grtz

Willem

You coming to the conference this year, I'm not only buying the nagios team a drink, I'm buying you one as well!

Posted: **Fri Aug 01, 2014 9:13 am**

BanditBBS wrote:You coming to the conference this year, I'm not only buying the nagios team a drink, I'm buying you one as well!

One drink for all of us to share or one drink each?

Posted: **Fri Aug 01, 2014 9:18 am**

tmcdonald wrote:
BanditBBS wrote:You coming to the conference this year, I'm not only buying the nagios team a drink, I'm buying you one as well!
One drink for all of us to share or one drink each?

HAHA, good thing I work at home right now, I laughed way to loud at that! One drink for each...after all, I'm doing it at the evening event when it's free anyway, lol

Feel free to close this up, everything is fine!

Nagios Support Forum

MySQL won't start

MySQL won't start

Re: MySQL won't start

Re: MySQL won't start

Re: MySQL won't start

Re: MySQL won't start