[Zabbix-users] Upgrading of Zabbix failed - issue with constraint in table trigger_discovery on postgres DB

[Kaya S. <kay...@gm...>]

Hi,


I hope someone can help me. I'm trying to upgrade my Zabbix install from 
2.2 to 3.2 running Postgres 9.3 as backend DB.


Currently I'm running into this error:


[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  there is no unique 
constraint matching given keys for referenced table "triggers"
  [alter table trigger_discovery add constraint c_trigger_discovery_1 
foreign key (triggerid) references triggers (triggerid) on delete cascade]
  75560:20161113:190640.609 database upgrade failed


The "triggers" table is populated however, the "trigger_discovery" table 
in the DB is completely empty....


I don't quite understand the error or what is causing it but through 
Google I did see some people having similar issues though no solution :-(


Best Regards,


Kaya