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

schema.sql errors with 7.4

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Cannot Reproduce
    • Icon: Trivial Trivial
    • None
    • 7.4.0
    • None
    • None

      after successful upgrade to 7.4 i run schema.sql for timescale.

      no other problems noticed.

       

      cat /usr/share/zabbix/sql-scripts/postgresql/timescaledb/schema.sql | sudo -u postgres psql zabbix
CREATE FUNCTION
NOTICE:  function base36_decode(pg_catalog.varchar) does not exist, skipping
DROP FUNCTION
NOTICE:  PostgreSQL version 17.5 (Ubuntu 17.5-1.pgdg24.04+1) is valid
NOTICE:  TimescaleDB extension is detected
NOTICE:  TimescaleDB version 2.19.3 is valid
ERROR:  relation "settings" does not exist
LINE 1: SELECT value_str FROM settings WHERE name='db_extension'
                              ^
QUERY:  SELECT value_str FROM settings WHERE name='db_extension'
CONTEXT:  PL/pgSQL function inline_code_block line 62 at SQL statement

       

       

            zabbix.support Zabbix Support Team
            Tristis Oris Tristis Oris
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: