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

PostgreSQL SQL errors during node configuration sync

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0.6
    • Fix Version/s: 2.0.11rc1, 2.2.2rc1, 2.3.0
    • Component/s: Server (S)
    • Environment:
      Zabbix from deb packages on Debian GNU/Linux unstable with PostgreSQL 9.1.9.

      Description

      After configuring 2 nodes as explained in the documentation the master (node 1) logs several SQL errors like:

      24562:20130429:165953.158 NODE 1: Received configuration changes from slave node 2 for node 2 datalen 2773601
      24562:20130429:165954.256 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: syntax error at or near "1"
      LINE 1427: ...00\\350\\235
      345Tx p\\020\\354|\\353\\177\\247_\'1\\177
      22...
      ^
      and the configuration sync doesn't finish correctly (some data is visible while other, like templates, is not).

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              fog Federico Di Gregorio
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: