Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-26835

Failed to call timescaledb functions

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 7.2.11, 7.4.1
    • Server (S)
    • None
    • postgresql 17.5
      timescaledb 2.21

      Zabbix fail to call timescaledb function if zabbix and timescaledb location in different schema

      My  postgresql structure is:

       

      <database>.<schema_for_zabbix>.*
      <database>.<schema_for_tsdb>.*
      <database>.<schema_for_collect_log>.*
      ...
      

      timescaledb was installed via command:

      create extension timescaledb with schema tsdb cascade; 

      because all schemes in this database use timescaledb functions

      then i set search_path:

       

      alter database db_mon set search_path to zabbix, tsdb, collect_log;

      but zabbix d'not works with this set

      I think this is because before each call of a SQL query, zabbix overwrites the variable "search_path" with the one specified in the config file

       

       

            zabbix.support Zabbix Support Team
            nick.w Nick
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: