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

Problem UTF-8 processing with Postgresql

XMLWordPrintable

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

      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@address','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.

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

              Created:
              Updated:
              Resolved: