Hi all,
We did today one upgrade in our icinga2 cluster but we got one Error with
the PGSQL-IDO (syntax Fehler):
[2016-02-01 08:47:16 +0100] information/
IdoPgsqlConnection: pgSQL IDO instance id: 1 (schema version: '1.14.0')
[2016-02-01 08:47:18 +0100] critical/IdoPgsqlConnection: Error "ERROR:
invalid input syntax for integer: ""
LINE 1: ...s WHERE host_object_id = 63820 AND hostgroup_id = E'' AND in...
^
" when executing query "DELETE FROM icinga_hostgroup_members WHERE
host_object_id = 63820 AND hostgroup_id = E'' AND instance_id = 1"
Context:
(0) Reconnecting to PostgreSQL IDO database 'pgsql-ido'
[2016-02-01 08:47:18 +0100] warning/IdoPgsqlConnection: Exception during
database operation: Verify that your database is operational!
All Packages were hat the version 2.4.1.1...
[08:47:21]r...@icinga-02.ipx /home/admin# dpkg -l |grep icinga2
ii icinga2 2.4.1-1~debmon70+1
amd64 host and network monitoring system
ii icinga2-bin 2.4.1-1~debmon70+1
amd64 host and network monitoring system - daemon
ii icinga2-common 2.4.1-1~debmon70+1
all host and network monitoring system - common files
ii icinga2-doc 2.3.4-3~debmon70+1
all host and network monitoring system - documentation
ii icinga2-ido-pgsql 2.4.1-1~debmon70+1
amd64 host and network monitoring system - PostgreSQL support
ii libicinga2 2.4.1-1~debmon70+1
amd64 host and network monitoring system - internal libraries
Has someone one idea?
Christian Moreno Moreno
System Engineer Offers
idealo internet GmbH
Ritterstraße 11
10969 Berlin, Deutschland
Tel.: +49 (0)30 40 30 10 33
Fax: +49 (0)30 221 94 33 - 21
E-Mail: christian.mor...@idealo.de
Geschäftsführer:
Dr. Albrecht von Sonntag, Dr. Philipp-Christopher Peitsch
HRB 76749 – Amtsgericht Berlin-Charlottenburg
[image: idealo Logo] <http://www.idealo.de/>
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users
