XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 5.4.0
    • Server (S)
    • Debian GNU/Linux 10 4.19.160-2
      PostgreSQL 12.7
      timescaledb-2.2.1~debian10

      Steps to reproduce:

      1. Have zabbix Server 5.2.6 installed
      2. Update to 5.4.0 via PPA-sources
      3. Find message in errorlog

        [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: foreign key constraint "c_items_3" cannot be implementedDETAIL: Key columns "valuemapid" and "valuemapid" are of incompatible types: numeric and bigint. '[alter table items add constraint c_items_3 foreign key (valuemapid) references valuemap (valuemapid)]

        database upgrade failed

      4. Fixing this issue by switching valuemap.valuemapid from BIGINT to NUMERIC
      5. Find next message in errorlog:

        [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: index "users_1" does not exist [drop index users_1]

        database upgrade failed

        1. zabbixDB.sql
          1.09 MB
          Florian Requardt

            ArtursL Arturs Lontons
            plexus Florian Requardt
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: