Hi There,
Ubuntu 24.04
Postgresql 14.
After I tried to connect the zabbix_server and I got those lines:
QUERY: CREATE TABLE IF NOT EXISTS partitions.history_p2025_02_08 (CHECK ((clock >= ‘1738969200.000000’ AND clock < ‘1739055600.000000’))) INHERITS (history)
CONTEXT: PL/pgSQL function trg_partition() line 37 at EXECUTE
[insert into history (itemid,clock,ns,value) values (23265,1739038245,137507513,0),(23625,1739038245,1 37468148,7.5957959238138804);
]
16973:20250208:191046.391 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid input syntax for type integer: “1738969200.000000”
LINE 1: … partitions.history_p2025_02_08 (CHECK ((clock >= '173896920…
^
ChatGPT said me: the clock is integer and the ‘’ is wrong! Why happened this?
How can I solve the problem?
Before I restored the backup I used the schema.sql and it was made an empty zabbix DB. After that I used my backup.
Zabbix upgrade said: 5.0.46 supports timescale 2.17 …
Other question: who did the the above query? Zabbix, Postgres or Timescale?
What can I do now?
TIA,
Ruzsi