[ZBX-12037] Problem UTF-8 processing with Postgresql Created: 2017 Apr 11  Updated: 2017 May 30  Resolved: 2017 Apr 11

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Server (S)
Affects Version/s: 3.0.8
Fix Version/s: None

Type: Incident report Priority: Minor
Reporter: Kaspars Bogdanovs Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Linux 4.6.4, Postgresql 9.6.2

Attachments: PNG File Notification.png    
Issue Links:
Duplicate
duplicates ZBX-11855 Carriage Return Causes Data Truncatio... Closed

 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@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.

 Comments   
Comment by Oleksii Zagorskyi [ 2017 Apr 11 ]

Duplicate of ZBX-11855.
Closed.

Generated at Thu Apr 30 19:09:54 EEST 2026 using Jira 10.3.18#10030018-sha1:5642e4ad348b6c2a83ebdba689d04763a2393cab.