Hi,
Fritjof Bornebusch - Skyfillers wrote:
Hey guys,
I got the following error in my syslog:
[...]
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. :)
perfdata was varchar(255) in previous pgsql schema. I think you forgot
to upgrade your database schema (pgsql-upgrade-1.0.3.sql) - I have fixed
those issues by replacing all varchar(n) to TEXT instead.
check on the table schema of icinga_servicechecks, column perfdata.
should be TEXT, otherwise upgrade the db schema.
Kind regards,
Michael
--
DI (FH) Michael Friedrich
Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria
email: [email protected]
phone: +43 1 4277 14359
fax: +43 1 4277 14279
web: http://www.univie.ac.at/zid
Icinga Core& IDOUtils Developer
http://www.icinga.org
------------------------------------------------------------------------------
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
