Hey guys, I got the following error in my syslog:
Aug 19 12:31:04 debian-server icinga: Finished daemonizing... (New PID=21512) Aug 19 12:31:05 debian-server ido2db: Error: database query failed for 'UPDATE icinga_servicestatus SET instance_id='1', service_object_id='11', status_update_time=FROM_UNIXTIME(1282213864), output='OK: All Storages have enough Space', long_output='', perfdata='PublicFolders=118250;BusinessMailstore4=40032;BusinessMailstore9=8220;BusinessMailstore5=32141;BusinessMailstore6=45339;BusinessMailstore2=24921;BusinessMailstore3=31255;BusinessMailstore14=160779;BusinessMailstore12=163657;BusinessMailstore8=20582;BusinessMailstore1=14856;BusinessMailstore11=134837;BusinessMailstore13=162271;BusinessMailstore7=44576;BusinessMailstore10=133463;ConsumerMailstore1=9766;1;0', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='4', last_check=FROM_UNIXTIME(1282213786), next_check=FROM_UNIXTIME(1282214086), check_type='0', last_state_change=FROM_UNIXTIME(1282212886), last_hard_state_change=FROM_UNIXTIME(1282212886), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1282213786), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(1282212731), 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_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='11.447370', latency='0.080000', execution_time='0.003000', scheduled_downtime_depth='0', failure_prediction_enabled='1', process_performance_data='1', obsess_over_service='1', modified_service_attributes='0', event_handler='', check_command='check_xml_parser!-f /home/alokat/repositorys/XML_Parser_Icinga/exchange.xml -w 1 -c 0 -f', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='2' WHERE service_object_id='11'' - 'ERROR: value too long for type character varying(255) ' Aug 19 12:31:05 debian-server ido2db: Successfully disconnected from pgsql database Aug 19 12:31:10 debian-server icinga: idomod: Error writing to data sink! Some output may get lost... Aug 19 12:31:10 debian-server icinga: idomod: Please check remote ido2db log, database connection or SSL Parameters Aug 19 12:31:28 debian-server icinga: idomod: Successfully reconnected to data sink! 0 items lost, 11 queued items to flush. Aug 19 12:31:28 debian-server ido2db: Client connected, data available. Aug 19 12:31:28 debian-server ido2db: Handling client connection... Aug 19 12:31:28 debian-server icinga: idomod: Successfully flushed 11 queued items to data sink. Aug 19 12:31:28 debian-server ido2db: Successfully connected to pgsql database Aug 19 12:32:28 debian-server ido2db: Successfully connected to pgsql database Aug 19 12:31:04 debian-server icinga: Finished daemonizing... (New PID=21512) Aug 19 12:31:05 debian-server ido2db: Error: database query failed for 'UPDATE icinga_servicestatus SET instance_id='1', service_object_id='11', status_update_time=FROM_UNIXTIME(1282213864), output='OK: All Storages have enough Space', long_output='', perfdata='PublicFolders=118250;BusinessMailstore4=40032;BusinessMailstore9=8220;BusinessMailstore5=32141;BusinessMailstore6=45339;BusinessMailstore2=24921;BusinessMailstore3=31255;BusinessMailstore14=160779;BusinessMailstore12=163657;BusinessMailstore8=20582;BusinessMailstore1=14856;BusinessMailstore11=134837;BusinessMailstore13=162271;BusinessMailstore7=44576;BusinessMailstore10=133463;ConsumerMailstore1=9766;1;0', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='4', last_check=FROM_UNIXTIME(1282213786), next_check=FROM_UNIXTIME(1282214086), check_type='0', last_state_change=FROM_UNIXTIME(1282212886), last_hard_state_change=FROM_UNIXTIME(1282212886), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1282213786), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(1282212731), 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_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='11.447370', latency='0.080000', execution_time='0.003000', scheduled_downtime_depth='0', failure_prediction_enabled='1', process_performance_data='1', obsess_over_service='1', modified_service_attributes='0', event_handler='', check_command='check_xml_parser!-f /home/alokat/repositorys/XML_Parser_Icinga/exchange.xml -w 1 -c 0 -f', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='2' WHERE service_object_id='11'' - 'ERROR: value too long for type character varying(255) ' Aug 19 12:34:46 debian-server ido2db: Error: database query failed for 'UPDATE icinga_servicechecks SET check_type='0', current_check_attempt='1', max_check_attempts='4', state='0', state_type='1', start_time=FROM_UNIXTIME(1282214086), start_time_usec='58331', end_time=FROM_UNIXTIME(0), end_time_usec='0', timeout='60', early_timeout='0', execution_time='0.000000', latency='0.058000', return_code='0', output='OK: All Storages have enough Space', long_output='', perfdata='PublicFolders=118250;BusinessMailstore4=40032;BusinessMailstore9=8220;BusinessMailstore5=32141;BusinessMailstore6=45339;BusinessMailstore2=24921;BusinessMailstore3=31255;BusinessMailstore14=160779;BusinessMailstore12=163657;BusinessMailstore8=20582;BusinessMailstore1=14856;BusinessMailstore11=134837;BusinessMailstore13=162271;BusinessMailstore7=44576;BusinessMailstore10=133463;ConsumerMailstore1=9766;1;0' WHERE instance_id=1 AND service_object_id=11 AND start_time=FROM_UNIXTIME(1282214086) AND start_time_usec=58331' - 'ERROR: value too long for type character varying(255) ' Aug 19 12:34:46 debian-server ido2db: Successfully disconnected from pgsql database Aug 19 12:34:52 debian-server icinga: idomod: Error writing to data sink! Some output may get lost... Aug 19 12:34:52 debian-server icinga: idomod: Please check remote ido2db log, database connection or SSL Parameters Aug 19 12:35:10 debian-server ido2db: Client connected, data available. Aug 19 12:35:10 debian-server ido2db: Handling client connection... Aug 19 12:35:10 debian-server icinga: idomod: Successfully reconnected to data sink! 0 items lost, 15 queued items to flush. Aug 19 12:35:10 debian-server icinga: idomod: Successfully flushed 15 queued items to data sink. Aug 19 12:35:10 debian-server ido2db: Successfully connected to pgsql database Aug 19 12:35:10 debian-server ido2db: Error: database query failed for 'UPDATE icinga_servicechecks SET check_type='0', current_check_attempt='1', max_check_attempts='4', state='0', state_type='1', start_time=FROM_UNIXTIME(1282214086), start_time_usec='58331', end_time=FROM_UNIXTIME(1282214086), end_time_usec='61609', timeout='60', early_timeout='0', execution_time='0.003280', latency='0.058000', return_code='0', output='OK: All Storages have enough Space', long_output='', perfdata='PublicFolders=118250;BusinessMailstore4=40032;BusinessMailstore9=8220;BusinessMailstore5=32141;BusinessMailstore6=45339;BusinessMailstore2=24921;BusinessMailstore3=31255;BusinessMailstore14=160779;BusinessMailstore12=163657;BusinessMailstore8=20582;BusinessMailstore1=14856;BusinessMailstore11=134837;BusinessMailstore13=162271;BusinessMailstore7=44576;BusinessMailstore10=133463;ConsumerMailstore1=9766;1;0' WHERE instance_id=1 AND service_object_id=11 AND start_time=FROM_UNIXTIME(1282214086) AND start_time_usec=58331' - 'ERROR: value too long for type character varying(255) ' Aug 19 12:35:10 debian-server ido2db: Successfully disconnected from pgsql database I guess my output from a plugin is to long. Looks like it's more my fault than yours. :) Regards, Fritjof
------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________ icinga-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/icinga-users
