Nagios Support Forum

Hi,

Lots of errors in messages after repair

Aug 5 21:15:56 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:56 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:56 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:56 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'

/Peter

Hi,

After repair i got a lot of faults in /var/log/messages

Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair

So i did
service nagios stop
echo 'TRUNCATE TABLE nagios_logentries;' |mysql -t -u root -pnagiosxi nagios
service mysqld stop
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
Now Repair was OK
service nagios start

/Peter

I guess the truncate took a while and the database was still receiving new data.
Let us know if this works for you.

Hi,

No problem since 2200 yesterday.

How do we avoid this problem coming up again ?
Are there some autocleanup running ?

Already a lot of new entries.
[root@khk26dsg5 ~]# ls -lR /var/lib/mysql/nagios/nagios_logentries*
-rw-rw---- 1 mysql mysql 8972 May 22 2014 /var/lib/mysql/nagios/nagios_logentries.frm
-rw-rw---- 1 mysql mysql 210626696 Aug 6 18:21 /var/lib/mysql/nagios/nagios_logentries.MYD
-rw-rw---- 1 mysql mysql 233720832 Aug 6 18:21 /var/lib/mysql/nagios/nagios_logentries.MYI

thanks,
Peter Calum
TDC
Denmark

There is not an automated way of to truncate the MYSQL tables, it is a manual process, so periodically you will have to truncate the tables and run the repair to shrink the tables.

Hi,

I think it should be considered to make som automatic cleanup, like the other Database settings under 'Performance settings'

Thanks,
Peter Calum

toper wrote:Hi,

I think it should be considered to make som automatic cleanup, like the other Database settings under 'Performance settings'

Thanks,
Peter Calum

Hi Toper,

I can put in a feature request for you. Is this topic safe to close?

Hi,

Yes, we can close this ticket.

thanks,
Peter