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

Problem UTF-8 processing with Postgresql

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 3.0.8
    • None
    • Frontend (F), Server (S)
    • None
    • Linux 4.6.4, Postgresql 9.6.2

    Description

      We are getting such errors in logs:

      10004:20170411:104516.467 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid byte sequence for encoding "UTF8": 0xc5 0x27
      [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,error,esc_step,alerttype) values (59963198,23,461339504,79,1491896716,1,'[email protected]','device-name: ping trigger: IP.IP.IP.IP: PROBLEM','device-name: ping trigger: IP.IP.IP.IP: PROBLEM

      xxxx:
      xxxx j?s?ta, xxxx process! xxxxx sa?emšanas br??',0,'',1,0);
      ]

      So far we found 2 workarounds:
      a) Changing "br?ža" to "briza"
      or
      b) Adding dot in next line

      Screenshot added.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ksb Kaspars Bogdanovs
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: