Nagios Support Forum

I have an MYSQL Error in my messages file repeating continuously:

Error: mysql_query() failed for 'INSERT INTO npc_servicestatus SET instance_id='1', service_object_id='4106', status_update_time=FROM_UNIXTIME(1358128451), output='Virtual Memory: 56%used\(1151MB/2070MB\) \(<80%\) : OK', long_output='', perfdata='\'Virtual_Memory\'=1151MB;1656;1863;0;2070', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='5', last_check=FROM_UNIXTIME(1358128449), next_check=FROM_UNIXTIME(1358128749), check_type='0', last_state_change=FROM_UNIXTIME(1351882059), last_hard_state_change=FROM_UNIXTIME(1350153113), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1358128449), last_time_warning=FROM_UNIXTIME(1351295283), last_time_unknown=FROM_UNIXTIME(1351881998), last_time_critical=FROM_UNIXTIME(0), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current


what can i do in this case??

Repair the database and report back:

http://assets.nagios.com/downloads/nagi ... tabase.pdf

Sorry but after repairing the database i have the same error again (here is another snapshot of the 'messages' file)

Jan 15 09:14:01 lr5mgt02 ndo2db: Error: mysql_query() failed for 'INSERT INTO npc_servicestatus SET instance_id='1', service_object_id='1887', status_update_time=FROM_UNIXTIME(1358212441), output='/opt: 42%used\(2016MB/4836MB\) \(<80%\) : OK', long_output='', perfdata='\'/opt\'=2016MB;3869;4594;0;4836', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='5', last_check=FROM_UNIXTIME(1358212440), next_check=FROM_UNIXTIME(1358212740), check_type='0', last_state_change=FROM_UNIXTIME(1346127069), last_hard_state_change=FROM_UNIXTIME(1346127069), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1358212440), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(0), last_time_critical=FROM_UNIXTIME(0), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_chec
Jan 15 09:14:01 lr5mgt02 ndo2db: mysql_error: 'Unknown column 'long_output' in 'field list''
Jan 15 09:14:01 lr5mgt02 ndo2db: Error: mysql_query() failed for 'INSERT INTO npc_servicechecks SET instance_id='1', service_object_id='1887', check_type='0', current_check_attempt='1', max_check_attempts='5', state='0', state_type='1', start_time=FROM_UNIXTIME(1358212440), start_time_usec='257300', end_time=FROM_UNIXTIME(1358212441), end_time_usec='5021', timeout='60', early_timeout='0', execution_time='0.747720', latency='0.257000', return_code='0', output='/opt: 42%used\(2016MB/4836MB\) \(<80%\) : OK', long_output='', perfdata='\'/opt\'=2016MB;3869;4594;0;4836', command_object_id='0', command_args='', command_line='' ON DUPLICATE KEY UPDATE instance_id='1', service_object_id='1887', check_type='0', current_check_attempt='1', max_check_attempts='5', state='0', state_type='1', start_time=FROM_UNIXTIME(1358212440), start_time_usec='257300', end_time=FROM_UNIXTIME(1358212441), end_time_usec='5021', timeout='60', early_timeout='0', execution_time='0.747720', latency='0.257000', return_code='0', output='/opt: 42%us
Jan 15 09:14:01 lr5mgt02 ndo2db: mysql_error: 'Unknown column 'long_output' in 'field list''
Jan 15 09:14:01 lr5mgt02 ndo2db: Error: mysql_query() failed for 'INSERT INTO npc_servicestatus SET instance_id='1', service_object_id='1887', status_update_time=FROM_UNIXTIME(1358212441), output='/opt: 42%used\(2016MB/4836MB\) \(<80%\) : OK', long_output='', perfdata='\'/opt\'=2016MB;3869;4594;0;4836', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='5', last_check=FROM_UNIXTIME(1358212440), next_check=FROM_UNIXTIME(1358212740), check_type='0', last_state_change=FROM_UNIXTIME(1346127069), last_hard_state_change=FROM_UNIXTIME(1346127069), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1358212440), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(0), last_time_critical=FROM_UNIXTIME(0), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_chec

Thank you

Is your database offloaded? Your table names are not the default for an XI install, can you tell us what you've done to modify them, or what configs you've modified recently?

npc_servicestatus