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

Zabbix proxy 2.2 PostgreSQL database error

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 2.2.1
    • 2.2.0
    • Proxy (P)
    • None
    • CentOS 6 64bit latest. zabbix proxy and server 2.2 official repo, PostgreSQL 8.4.18 default CentOS repo

      Proxy cannot push to database data received from server
      Cut from zabbix_proxy.log
      6838:20131113:104244.260 Received configuration data from server. Datalen 2165
      6838:20131113:104244.420 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: update or delete on table "items" violates foreign key constraint "c_host_discovery_3" on
      DETAIL: Key (itemid)=(23542) is still referenced from table "host_discovery".
      [delete from items where (itemid between 10055 and 10059 or itemid between 22700 and 22744 or itemid between 22755 and 22789 or itemid between 22796 and 22846 or itemid
      6838:20131113:104244.421 failed to update local proxy configuration copy: database error

      Database just created and /usr/share/doc/zabbix-proxy-pgsql-2.2.0/create/

      {schema.sql,images.sql,data.sql}

      were loaded without errors

            kodai Kodai Terashima
            av Alex Vorona
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: