While testing upgrading from Zabbix 3.0 to Zabbix 4.0 we are seeing the following error in the zabbix.log:
28376:20181205:073606.859 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "ids_pkey"
DETAIL: Key (table_name, field_name)=(event_suppress, event_suppressid) already exists.
[insert into ids (table_name,field_name,nextid) values ('event_suppress','event_suppressid',0)]
Upgrade of the database when starting the zabbix server seems to go smoothly. We see these errors in the log after the preprocessing workers are started. The server seems operational. Any ideas what these might indicate and how severe of an issues it is. We've tested twice, and saw the error 2 times on the first test and 5 times on the second test.
Ubuntu 18.04
zabbix-server-pgsql 4.0.1-1
postgresql 10.5
Thanks for any info!
28376:20181205:073606.859 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "ids_pkey"
DETAIL: Key (table_name, field_name)=(event_suppress, event_suppressid) already exists.
[insert into ids (table_name,field_name,nextid) values ('event_suppress','event_suppressid',0)]
Upgrade of the database when starting the zabbix server seems to go smoothly. We see these errors in the log after the preprocessing workers are started. The server seems operational. Any ideas what these might indicate and how severe of an issues it is. We've tested twice, and saw the error 2 times on the first test and 5 times on the second test.
Ubuntu 18.04
zabbix-server-pgsql 4.0.1-1
postgresql 10.5
Thanks for any info!