ZABBIX BUGS AND ISSUES
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-6545

PostgreSQL SQL errors during node configuration sync

    Details

    • Type: Incident report Incident report
    • Status: Closed
    • Priority: Critical 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).

        Activity

        Hide
        Federico Di Gregorio added a comment -

        The problem can be fixed by setting the following parameters in postgresql.conf:

        backslash_quote = on
        standard_conforming_strings = off

        Note that as explained on PostgreSQL documentation (http://www.postgresql.org/docs/9.1/static/runtime-config-compatible.html) using those settings has security implications.

        Show
        Federico Di Gregorio added a comment - The problem can be fixed by setting the following parameters in postgresql.conf: backslash_quote = on standard_conforming_strings = off Note that as explained on PostgreSQL documentation ( http://www.postgresql.org/docs/9.1/static/runtime-config-compatible.html ) using those settings has security implications.
        Hide
        Alexander Vladishev added a comment -

        Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-6545

        Show
        Alexander Vladishev added a comment - Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-6545
        Hide
        Andris Zeila added a comment -

        Successfully tested

        Show
        Andris Zeila added a comment - Successfully tested
        Hide
        Alexander Vladishev added a comment -

        Fixed in pre-2.0.11 r41218, pre-2.2.2 r41220 and pre-2.3.0 (trunk) r41221.

        Show
        Alexander Vladishev added a comment - Fixed in pre-2.0.11 r41218, pre-2.2.2 r41220 and pre-2.3.0 (trunk) r41221.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: