-
Incident report
-
Resolution: Cannot Reproduce
-
Trivial
-
None
-
5.0.0
-
None
-
root@zbx:/var/log/zabbix# dpkg --list | grep -i postgres
ii libpq5:amd64 12.2-4 amd64 PostgreSQL C client library
ii php7.4-pgsql 7.4.3-4ubuntu1.1 amd64 PostgreSQL module for PHP
ii postgresql 12+214 all object-relational SQL database (supported version)
ii postgresql-12 12.2-4 amd64 object-relational SQL database, version 12 server
ii postgresql-client-12 12.2-4 amd64 front-end programs for PostgreSQL 12
ii postgresql-client-common 214 all manager for multiple PostgreSQL client versions
ii postgresql-common 214 all PostgreSQL database-cluster manager
ii timescaledb-loader-postgresql-12 1.7.0~ubuntu20.04 amd64 The loader for TimescaleDB to load individual versions.
ii timescaledb-postgresql-12 1.7.0~ubuntu20.04 amd64 An open-source time-series database based on PostgreSQL, as an extension.
ii zabbix-server-pgsql 1:5.0.0-1+focal amd64 Zabbix network monitoring solution - server (PostgreSQL)
root@zbx:/var/log/zabbix# cat /etc/debian_version
bullseye/sid
root@zbx:/var/log/zabbix# cat /etc/issue
Ubuntu 20.04 LTS \n \l
root@zbx:/var/log/zabbix# dpkg --list | grep -i postgres
ii libpq5:amd64 12.2-4 amd64 PostgreSQL C client library
ii php7.4-pgsql 7.4.3-4ubuntu1.1 amd64 PostgreSQL module for PHP
ii postgresql 12+214 all object-relational SQL database (supported version)
ii postgresql-12 12.2-4 amd64 object-relational SQL database, version 12 server
ii postgresql-client-12 12.2-4 amd64 front-end programs for PostgreSQL 12
ii postgresql-client-common 214 all manager for multiple PostgreSQL client versions
ii postgresql-common 214 all PostgreSQL database-cluster manager
ii timescaledb-loader-postgresql-12 1.7.0~ubuntu20.04 amd64 The loader for TimescaleDB to load individual versions.
ii timescaledb-postgresql-12 1.7.0~ubuntu20.04 amd64 An open-source time-series database based on PostgreSQL, as an extension.
ii zabbix-server-pgsql 1:5.0.0-1+focal amd64 Zabbix network monitoring solution - server (PostgreSQL)
root@zbx:/var/log/zabbix# dpkg --list | grep zabbix
ii zabbix-agent 1:5.0.0-1+focal amd64 Zabbix network monitoring solution - agent
ii zabbix-frontend-php 1:5.0.0-1+focal all Zabbix network monitoring solution - PHP front-end
ii zabbix-nginx-conf 1:5.0.0-1+focal all Zabbix network monitoring solution - nginx and php-fpm configuration for front-end
ii zabbix-release 1:5.0-1+focal all Zabbix official repository configuration
ii zabbix-server-pgsql 1:5.0.0-1+focal amd64 Zabbix network monitoring solution - server (PostgreSQL)
root@zbx :/var/log/zabbix# dpkg --list | grep -i postgres ii libpq5:amd64 12.2-4 amd64 PostgreSQL C client library ii php7.4-pgsql 7.4.3-4ubuntu1.1 amd64 PostgreSQL module for PHP ii postgresql 12+214 all object-relational SQL database (supported version) ii postgresql-12 12.2-4 amd64 object-relational SQL database, version 12 server ii postgresql-client-12 12.2-4 amd64 front-end programs for PostgreSQL 12 ii postgresql-client-common 214 all manager for multiple PostgreSQL client versions ii postgresql-common 214 all PostgreSQL database-cluster manager ii timescaledb-loader-postgresql-12 1.7.0~ubuntu20.04 amd64 The loader for TimescaleDB to load individual versions. ii timescaledb-postgresql-12 1.7.0~ubuntu20.04 amd64 An open-source time-series database based on PostgreSQL, as an extension. ii zabbix-server-pgsql 1:5.0.0-1+focal amd64 Zabbix network monitoring solution - server (PostgreSQL) root@zbx :/var/log/zabbix# cat /etc/debian_version bullseye/sid root@zbx :/var/log/zabbix# cat /etc/issue Ubuntu 20.04 LTS \n \l root@zbx :/var/log/zabbix# dpkg --list | grep -i postgres ii libpq5:amd64 12.2-4 amd64 PostgreSQL C client library ii php7.4-pgsql 7.4.3-4ubuntu1.1 amd64 PostgreSQL module for PHP ii postgresql 12+214 all object-relational SQL database (supported version) ii postgresql-12 12.2-4 amd64 object-relational SQL database, version 12 server ii postgresql-client-12 12.2-4 amd64 front-end programs for PostgreSQL 12 ii postgresql-client-common 214 all manager for multiple PostgreSQL client versions ii postgresql-common 214 all PostgreSQL database-cluster manager ii timescaledb-loader-postgresql-12 1.7.0~ubuntu20.04 amd64 The loader for TimescaleDB to load individual versions. ii timescaledb-postgresql-12 1.7.0~ubuntu20.04 amd64 An open-source time-series database based on PostgreSQL, as an extension. ii zabbix-server-pgsql 1:5.0.0-1+focal amd64 Zabbix network monitoring solution - server (PostgreSQL) root@zbx :/var/log/zabbix# dpkg --list | grep zabbix ii zabbix-agent 1:5.0.0-1+focal amd64 Zabbix network monitoring solution - agent ii zabbix-frontend-php 1:5.0.0-1+focal all Zabbix network monitoring solution - PHP front-end ii zabbix-nginx-conf 1:5.0.0-1+focal all Zabbix network monitoring solution - nginx and php-fpm configuration for front-end ii zabbix-release 1:5.0-1+focal all Zabbix official repository configuration ii zabbix-server-pgsql 1:5.0.0-1+focal amd64 Zabbix network monitoring solution - server (PostgreSQL)
Steps to reproduce:
- Use standard template "Template Server Chassis by IPMI" from zabbix 5.0.0 for HP proliant dl20 gen9 ILO (ILO4 v2.73) monitoring
- Check zabbix-server.log
Result:
179422:20200515:212802.391 enabling IPMI agent checks on host "host123": host became available 179471:20200515:212802.425 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "applications_2" DETAIL: Key (hostid, name)=(10329, IPMI fan) already exists. [insert into applications (applicationid,hostid,name,flags) values (1766,10329,'IPMI fan',4),(1767,10329,'IPMI temperature',4); ]
Expected:
no PGRES_FATAL_ERROR error in the log file
Additional info:
This server has 3 FANs. Looks like all 3 fans were successfully discovered, sensors data is collecting, but maybe something is wrong due to this error in the log file.
