Hi, jep I have forgotten to upgrade the db schema. Now it looks like as it works.
Thanks for your reply. Regards, Fritjof Von: Michael Friedrich [mailto:[email protected]] Gesendet: Donnerstag, 19. August 2010 12:57 An: [email protected] Betreff: Re: [icinga-users] error during writing into a pgsql database 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]<mailto:[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
