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

postgresql warning message "nonstandard use" in logfile

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6
    • Fix Version/s: 1.6
    • Component/s: None
    • Labels:
      None
    • Environment:
      ubuntu hardy / debian etch

      Description

      Logwatchchecks (and also other checks) that return quotes with values raise this Warning Message in zabbix-server and also in postgresql.log:

      HINT: Use the escape string syntax for backslashes, e.g., E'
      '.
      WARNING: nonstandard use of
      in a string literal
      LINE 1: ....log,sshd
      []') or (h.host='vlxp01-dd' and i.key_='log[/var/...
      ^
      HINT: Use the escape string syntax for backslashes, e.g., E'
      '.
      WARNING: nonstandard use of
      in a string literal
      LINE 1: ....log,sshd
      []') or (h.host='vlxp01-dd' and i.key_='log[/var/...
      ^
      HINT: Use the escape string syntax for backslashes, e.g., E'
      '.
      WARNING: nonstandard use of
      in a string literal
      LINE 1: ....log,sshd
      []') or (h.host='vlxp01-dd' and i.key_='log[/var/...
      ^
      HINT: Use the escape string syntax for backslashes, e.g., E'
      '.
      WARNING: nonstandard use of
      in a string literal
      LINE 1: ....log,sshd
      []') or (h.host='vlxp01-dd' and i.key_='log[/var/...
      ^
      HINT: Use the escape string syntax for backslashes, e.g., E'
      '.
      WARNING: nonstandard use of
      in a string literal
      LINE 1: ....log,sshd
      []') or (h.host='vlxp01-dd' and i.key_='log[/var/...
      ^
      HINT: Use the escape string syntax for backslashes, e.g., E'
      '.

      This concerns changes in postgresql 8.x that are discussed here:

      It bulks the logfile a lot in both postgresql and zabbix-server, please fix.

        Attachments

          Activity

            People

            Assignee:
            sasha Alexander Vladishev
            Reporter:
            tekknokrat Gunnar Thielebein
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: