MySQL won't start

[BanditBBS]

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

Code: Select all

[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

[WillemDH]

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

[BanditBBS]

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!

[tmcdonald]

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?

[BanditBBS]

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!