ndo2db - Error: mysql_query() failed

Ciro Iriarte cyruspy at gmail.com
Tue Aug 5 21:42:51 CEST 2008


Hi, i'm having issues with ndoutils 1.4b7 and nagios 3.0.3, after some
time nagios stops working and I have many defunct processes with no
movement on nagios.log. On /var/log/messages I found some complains
from ndo2db, but i'm not sure they are related.

------------------
Aug  5 14:03:30 spmon ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_servicestatus SET instance_id='1',
service_object_id='672', status_update_time=FROM_UNIXTIME(1217959410),
output='LOG CRITICAL - /tas/monAlarm/log/alarm\.log: \[2008-08-05
14:00:01\] Insert alarm \[\[ALARMA\] Recibi SIGNAL SIGUSR1\.
Pid=\(10345\)\] for pid=10345
\(intfCallRater\[Interface_Tasador_de_Llamadas\]\): Ok', perfdata='',
current_state='2', has_been_checked='1', should_be_scheduled='1',
current_check_attempt='1', max_check_attempts='1',
last_check=FROM_UNIXTIME(1217959401),
next_check=FROM_UNIXTIME(1217959116), check_type='0',
last_state_change=FROM_UNIXTIME(1217959401),
last_hard_state_change=FROM_UNIXTIME(1217959401), last_hard_state='0',
last_time_ok=FROM_UNIXTIME(1217958996),
last_time_warning=FROM_UNIXTIME(0),
last_time_unknown=FROM_UNIXTIME(0),
last_time_critical=FROM_UNIXTIME(1217959401), state_type='1',
last_notification=FROM_UNIXTIME(1217959404),
next_notification=FROM_UNIXTIME(3110119404),
no_more_notifications='0', notifications_enabled='1',
problem_has_been_acknowledged='0', acknowledgement_type='0',
current_notification_number='1', passive_checks_enabled='1',
active_checks_enabled='1', event_handler_enabled='1',
flap_detection_enabled='0', is_flapping='0',
percent_state_change='15.197370', latency='285.269000',
execution_time='1.033410', scheduled_downtime_depth='0',
failure_prediction_enabled='1', process_performance_data='1',
obsess_over_service='1', modified_service_attributes='0',
event_handler='ins2tt',
check_command='check_log!/tas/monAlarm/log/alarm\.log!\'Insert\'!\'no
definida en tabla CELDAS\'', normal_check_interval='2.000000',
retry_check_interval='1.000000', check_timeperiod_object_id='139' ON
DUPLICATE KEY UPDATE instance_id='1', service_object_id='672',
status_update_time=FROM_UNIXTIME(1217959410), output='LOG CRITICAL -
/tas/monAlarm/log/alarm\.log: \[2008-08-05 14:00:01\] Insert alarm
\[\[ALARMA\] Recibi SIGNAL SIGUSR1\. Pid=\(10345\)\] for pid=10345
\(intfCallRater\[Interface_Tasador_de_Llamadas
Aug  5 14:03:32 spmon ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_servicestatus SET instance_id='1',
service_object_id='672', status_update_time=FROM_UNIXTIME(1217959411),
output='LOG CRITICAL - /tas/monAlarm/log/alarm\.log: \[2008-08-05
14:00:01\] Insert alarm \[\[ALARMA\] Recibi SIGNAL SIGUSR1\.
Pid=\(10345\)\] for pid=10345
\(intfCallRater\[Interface_Tasador_de_Llamadas\]\): Ok', perfdata='',
current_state='2', has_been_checked='1', should_be_scheduled='1',
current_check_attempt='1', max_check_attempts='1',
last_check=FROM_UNIXTIME(1217959401),
next_check=FROM_UNIXTIME(1217959521), check_type='0',
last_state_change=FROM_UNIXTIME(1217959401),
last_hard_state_change=FROM_UNIXTIME(1217959401), last_hard_state='2',
last_time_ok=FROM_UNIXTIME(1217958996),
last_time_warning=FROM_UNIXTIME(0),
last_time_unknown=FROM_UNIXTIME(0),
last_time_critical=FROM_UNIXTIME(1217959401), state_type='1',
last_notification=FROM_UNIXTIME(1217959404),
next_notification=FROM_UNIXTIME(3110119404),
no_more_notifications='0', notifications_enabled='1',
problem_has_been_acknowledged='0', acknowledgement_type='0',
current_notification_number='1', passive_checks_enabled='1',
active_checks_enabled='1', event_handler_enabled='1',
flap_detection_enabled='0', is_flapping='0',
percent_state_change='15.197370', latency='285.269000',
execution_time='1.033410', scheduled_downtime_depth='0',
failure_prediction_enabled='1', process_performance_data='1',
obsess_over_service='1', modified_service_attributes='0',
event_handler='ins2tt',
check_command='check_log!/tas/monAlarm/log/alarm\.log!\'Insert\'!\'no
definida en tabla CELDAS\'', normal_check_interval='2.000000',
retry_check_interval='1.000000', check_timeperiod_object_id='139' ON
DUPLICATE KEY UPDATE instance_id='1', service_object_id='672',
status_update_time=FROM_UNIXTIME(1217959411), output='LOG CRITICAL -
/tas/monAlarm/log/alarm\.log: \[2008-08-05 14:00:01\] Insert alarm
\[\[ALARMA\] Recibi SIGNAL SIGUSR1\. Pid=\(10345\)\] for pid=10345
\(intfCallRater\[Interface_Tasador_de_Llamadas
Aug  5 14:03:32 spmon ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_servicestatus SET instance_id='1',
service_object_id='672', status_update_time=FROM_UNIXTIME(1217959411),
output='LOG CRITICAL - /tas/monAlarm/log/alarm\.log: \[2008-08-05
14:00:01\] Insert alarm \[\[ALARMA\] Recibi SIGNAL SIGUSR1\.
Pid=\(10345\)\] for pid=10345
\(intfCallRater\[Interface_Tasador_de_Llamadas\]\): Ok', perfdata='',
current_state='2', has_been_checked='1', should_be_scheduled='1',
current_check_attempt='1', max_check_attempts='1',
last_check=FROM_UNIXTIME(1217959401),
next_check=FROM_UNIXTIME(1217959521), check_type='0',
last_state_change=FROM_UNIXTIME(1217959401),
last_hard_state_change=FROM_UNIXTIME(1217959401), last_hard_state='2',
last_time_ok=FROM_UNIXTIME(1217958996),
last_time_warning=FROM_UNIXTIME(0),
last_time_unknown=FROM_UNIXTIME(0),
last_time_critical=FROM_UNIXTIME(1217959401), state_type='1',
last_notification=FROM_UNIXTIME(1217959404),
next_notification=FROM_UNIXTIME(3110119404),
no_more_notifications='0', notifications_enabled='1',
problem_has_been_acknowledged='0', acknowledgement_type='0',
current_notification_number='1', passive_checks_enabled='1',
active_checks_enabled='1', event_handler_enabled='1',
flap_detection_enabled='0', is_flapping='0',
percent_state_change='15.197370', latency='285.269000',
execution_time='1.033410', scheduled_downtime_depth='0',
failure_prediction_enabled='1', process_performance_data='1',
obsess_over_service='1', modified_service_attributes='0',
event_handler='ins2tt',
check_command='check_log!/tas/monAlarm/log/alarm\.log!\'Insert\'!\'no
definida en tabla CELDAS\'', normal_check_interval='2.000000',
retry_check_interval='1.000000', check_timeperiod_object_id='139' ON
DUPLICATE KEY UPDATE instance_id='1', service_object_id='672',
status_update_time=FROM_UNIXTIME(1217959411), output='LOG CRITICAL -
/tas/monAlarm/log/alarm\.log: \[2008-08-05 14:00:01\] Insert alarm
\[\[ALARMA\] Recibi SIGNAL SIGUSR1\. Pid=\(10345\)\] for pid=10345
\(intfCallRater\[Interface_Tasador_de_Llamadas
Aug  5 14:07:20 spmon ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_servicestatus SET instance_id='1',
service_object_id='827', status_update_time=FROM_UNIXTIME(1217959640),
output='LOG CRITICAL -
/oracle10/app/oracle/admin/kml/bdump/alert_kml2\.log: Error 2068
trapped in 2PC on transaction 134\.29\.311341\. Cleaning up\.',
perfdata='', current_state='2', has_been_checked='1',
should_be_scheduled='1', current_check_attempt='1',
max_check_attempts='1', last_check=FROM_UNIXTIME(1217959549),
next_check=FROM_UNIXTIME(1217959279), check_type='0',
last_state_change=FROM_UNIXTIME(1217959549),
last_hard_state_change=FROM_UNIXTIME(1217959549), last_hard_state='0',
last_time_ok=FROM_UNIXTIME(1217959159),
last_time_warning=FROM_UNIXTIME(1217912164),
last_time_unknown=FROM_UNIXTIME(0),
last_time_critical=FROM_UNIXTIME(1217959549), state_type='1',
last_notification=FROM_UNIXTIME(1217959638),
next_notification=FROM_UNIXTIME(3110119638),
no_more_notifications='0', notifications_enabled='1',
problem_has_been_acknowledged='0', acknowledgement_type='0',
current_notification_number='1', passive_checks_enabled='1',
active_checks_enabled='1', event_handler_enabled='1',
flap_detection_enabled='0', is_flapping='0',
percent_state_change='27.565790', latency='270.342000',
execution_time='0.570690', scheduled_downtime_depth='0',
failure_prediction_enabled='1', process_performance_data='1',
obsess_over_service='1', modified_service_attributes='0',
event_handler='ins2tt',
check_command='check_log!/oracle10/app/oracle/admin/kml/bdump/alert_kml2\.log!\'error|ora-|cannot|can\.t|unavailable|fail|WARNING|Unable|Deadlock|Enqueue\'',
normal_check_interval='2.000000', retry_check_interval='1.000000',
check_timeperiod_object_id='139' ON DUPLICATE KEY UPDATE
instance_id='1', service_object_id='827',
status_update_time=FROM_UNIXTIME(1217959640), output='LOG CRITICAL -
/oracle10/app/oracle/admin/kml/bdump/alert_kml2\.log: Error 2068
trapped in 2PC on transaction 134\.29\.311341\. Cleaning up\.',
perfdata='', current_state='2', has_been_chec
-----------------

-----------------
Aug  5 15:28:44 spmon ndo2db: Successfully connected to MySQL database
Aug  5 15:29:22 spmon ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_configfilevariables SET instance_id='1',
configfile_id='1', varname='cfg_file',
varvalue='/etc/nagios/objects/contacts\.cfg''
Aug  5 15:29:22 spmon ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_configfilevariables SET instance_id='1',
configfile_id='1', varname='cfg_file',
varvalue='/etc/nagios/objects/timeperiods\.cfg''
Aug  5 15:29:22 spmon ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_configfilevariables SET instance_id='1',
configfile_id='1', varname='cfg_file',
varvalue='/etc/nagios/objects/templates\.cfg''
Aug  5 15:29:22 spmon ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_configfilevariables SET instance_id='1',
configfile_id='1', varname='cfg_file',
varvalue='/etc/nagios/objects/localhost\.cfg''
Aug  5 15:29:22 spmon ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_configfilevariables SET instance_id='1',
configfile_id='1', varname='cfg_dir',
varvalue='/etc/nagios/objects/services''
------------------
Anybody have seen this?

Regards,
Ciro

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null





More information about the Users mailing list