Nagios Support Forum

Did you ever delete the rows from the extinfo db tables like I asked? The db table files need to still persist, they should just be empty tables. I know you had mentioned that you just renamed the tables - that will probably cause errors with apply as it will try to read from a non-existent table.

Hi Abrist,

yesterday i deleted tables and today again i try to run the same command as below but getting some error as below i tried to repair table also but still same error . And now i don't have any entry in the serviceextinfo.cfg file but still i get error in the GUI with same old host details, i am not understanding why it is still pointing to old entries even though we don't have anytthing in the file.

echo "delete from nagiosql.tbl_serviceextinfo;" | mysql -pnagiosxi
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'tbl_serviceextinfo'; try to repair it

Error in GUI:

Error: Could not find a service matching host name '<host_name>' and description '292' (config file '/usr/local/nagios/etc/serviceextinfo.cfg', starting on line 478)
Error: Could not expand services specified in extended service info (config file '/usr/local/nagios/etc/serviceextinfo.cfg', starting on line 478)


Current config file entry for serviceextinfo.cfg :

###############################################################################
#
# Extended service information configuration file
#
# Created by: Nagios Core Config Manager 2.3.2
# Date: 2015-03-05 11:58:10
# Version: Nagios 3.x config file
#
# --- DO NOT EDIT THIS FILE BY HAND ---
# Nagios CCM will overwrite all manual settings during the next update if you
# would like to edit files manually, place them in the 'static' directory or
# import your configs into the CCM by placing them in the 'import' directory.
#
###############################################################################

###############################################################################
#
# Extended service information configuration file
#
# END OF FILE
#
###############################################################################

sagarjatti wrote:ERROR 1034 (HY000) at line 1: Incorrect key file for table 'tbl_serviceextinfo'; try to repair it

i noticed you said you deleted these table earlier. Did you actually delete the table files, or just the rows? If you deleted the table files, did you restore them?

I ran below command only

echo "delete from nagiosql.tbl_hostextinfo; delete from nagiosql.tbl_serviceextinfo;" | mysql -pnagiosxi

As i told before now i don't see any entry of server names in serviceextinfo.cfg file but Error in CCM points to old server which had entry in serviceextinfo.cfg before.

Please run the database repair script as that should resolve the key error: This error is most commonly caused by a full disk. What is the output of:

We have enough disk space on Nagios server.

Did you run the repair databases script?

If so, did you then again try to drop all the rows from the tbl_serviceextinfo table?

If you did and that failed again, may we see the output of the repair script?

Now the problem seems to exist but when i apply configuration changes it gives error. But actually changes are being saved and when i Restart nagios process from Tools-> Write-config -> Restart my changes will be effective in Nagios on server.

I really not understanding why it is giving error even though that host in the error is not exist in Nagios, i have removed all entries from Nagios.

Are you a current maintenance client? Can you send an email to [email protected] to open a ticket so that we can subsequently schedule a remote session?