Hello Zabbix Support Team,

I hope you can confirm the issue I am encountering and validate my findings.

I am encountering an issue reading the logs of PostgreSQL 16.3 and TimescaleDB 2.15.3 (Zabbix 7.0.3) after one week (when compression starts to run).

It seems the problem lies with both the function and the hypertable chunks of the auditlog table.

Specifically, the details column of the auditlog chunks is of type text, while the base36_decode function requires a character varying argument.

As a result, the auditlog chunks are not being compressed due to this mismatch.

How can this be resolved?

Should the base36_decode function be modified, or does it need an explicit cast? I used the schema.sql file from the TimescaleDB folder, but it doesn’t include this fix (Zabbix 7.0.3 version).

Thank you for your help,

Best regards.