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??
SQL Error
Re: SQL Error
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Re: SQL Error
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
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
Re: SQL Error
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
npc_servicestatus