hi,
Zabbix Getting errors like below error while housekeeper running.
2022-06-20 12:13:45.922 +03 [2193010] STATEMENT: delete from trends_uint where itemid=58109 and ctid = any(array(select ctid from trends_uint where itemid=58109 limit 5000))
2022-06-20 12:13:45.923 +03 [2193010] ERROR: transparent decompression only supports tableoid system column
I checked history table. this itemid is not exists in zabbix database. However, the housekeeper trying to delete this items many times and process utilization increasing to %100. how can I solve this problem?
select * from history where itemid=58109
Zabbix Getting errors like below error while housekeeper running.
2022-06-20 12:13:45.922 +03 [2193010] STATEMENT: delete from trends_uint where itemid=58109 and ctid = any(array(select ctid from trends_uint where itemid=58109 limit 5000))
2022-06-20 12:13:45.923 +03 [2193010] ERROR: transparent decompression only supports tableoid system column
I checked history table. this itemid is not exists in zabbix database. However, the housekeeper trying to delete this items many times and process utilization increasing to %100. how can I solve this problem?
select * from history where itemid=58109