ZBX-15587: any workaround?

[perry811]

https://support.zabbix.com/browse/ZBX-15587 - This has happened when we migrate to TimescaleDB 1.6, we experience the very similar error like in the bug report. One workaround we can try is to change all tables in Zabbix to public in order to use the TimescaleDB extension. Can i ask if anyone in this forum experience this bug also? If so, are you guys waiting for the fix from Zabbix? If not, can you share some workarounds you have tried? Thanks in advance.

HINT: No function matches the given name and argument types. You might need to add explicit type casts.
[SELECT drop_chunks(1575357751,'history_uint')]
10492:20200301:232231.800 cannot drop chunks for history_uint
10492:20200301:232231.800 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: function drop_chunks(integer, unknown) does not exist
LINE 1: SELECT drop_chunks(1575357751,'history_text')

[Glencoe]

You can drop TSDB extension from the database (DROP EXTENSION ... CASCADE) and then recreate it with SCHEMA option like this:

CREATE EXTENSION IF NOT EXISTS timescaledb SCHEMA customschema CASCADE

IMPORTANT! Before doing this you need to back up all history_* and trends_* tables, then import your history back. Because drop extension cascade will delete contents of all TSDB hypertables. Unfortunately TSDB extension doesn't support ALTER EXTENSION with SCHEMA option.

[perry811]

Thanks for your help! Glencoe. Your suggestion is helpful.