-
Incident report
-
Resolution: Cannot Reproduce
-
Trivial
-
None
-
7.4.3
-
VMware vCenter 7.0.3, Rocky Linux 9.6, Linux 5.14.0-570.39.1.el9_6.x86_64, PostgreSQL
Previously, I got the problem with missing FK constrait at database. I couldn't delete any host from Zabbix that has LLD
Some Table were look like this one
zabbix=# \d trigger_discovery Table "public.trigger_discovery" Column | Type | Collation | Nullable | Default ------------------+---------+-----------+----------+--------- triggerid | bigint | | not null | parent_triggerid | bigint | | not null | lastcheck | integer | | not null | 0 ts_delete | integer | | not null | 0 status | integer | | not null | 0 disable_source | integer | | not null | 0 ts_disable | integer | | not null | 0 Indexes: "trigger_discovery_pkey" PRIMARY KEY, btree (triggerid), tablespace "zbx_idx1" "trigger_discovery_1" btree (parent_triggerid), tablespace "zbx_idx1" Foreign-key constraints: "c_trigger_discovery_2" FOREIGN KEY (parent_triggerid) REFERENCES triggers(triggerid)
Or this one
Then I tried do import initial schema and data, just to fill missing Tables with requiered FK and other data. DB Owner and all tables owner was zabbix
zcat /usr/share/zabbix/sql-scripts/postgresql/server.sql.gz | sudo -u zabbix psql zabbix
After making this move, Zabbix started to allow me delete any host in the system without any error. But, some time after, it started crashing every 10-30 sec. I've tried to update Zabbix Server from 7.4.1 to 7.4.3 but there is no effect
Crash Log attached via file "zabbix-crash-report-1.txt"
