Error while applying configuration changes

[abrist]

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.

[sagarjatti]

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
#
###############################################################################

[abrist]

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?

[sagarjatti]

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.

[abrist]

Please run the database repair script as that should resolve the key error:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

This error is most commonly caused by a full disk. What is the output of:

Code: Select all

df -i
df -h

[sagarjatti]

We have enough disk space on Nagios server.

[jdalrymple]

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?

[sagarjatti]

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.

[abrist]

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?