[ZBX-3081] The problem with logrt and russian utf8 Created: 2010 Oct 06  Updated: 2017 May 30  Resolved: 2012 Jan 03

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.8.3
Fix Version/s: 1.8.10

Type: Incident report Priority: Major
Reporter: Dmitry Samoylov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: logmonitoring, utf8
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Fedora 10, PostgreSQL 8.3.4, Zabbix 1.8.3



 Description   

google translate result :
-----------------------------------------------------------------------
Monitoring logs used by logrt.

In a controlled log found this line:

Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen (/ lib64/security/pam_gnome_keyring.so): / lib64/security/pam_gnome_keyring.so: can not open shared object file: No such file or directory

In the server log file Zabbix (zabbix_server.log) on ??this line we get:

12754:20101005:151411.938 [Z3005] Query failed: [0] PGRES_FATAL_ERROR: ERROR: invalid byte sequence for encoding "UTF8": 0xd027
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
[Update items set lastclock = 1286277245, prevvalue = lastvalue, lastvalue = 'Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen (/ lib64/security/pam_gnome_keyring.so): / lib64/security/pam_gnome_keyring.so : can not open shared object file: No such file. ', lastlogsize = 4524, mtime = 1285754770 where itemid = 24 998;
]
12754:20101005:151411.939 [Z3005] Query failed: [0] PGRES_FATAL_ERROR: ERROR: current transaction is aborted, commands ignored until end of transaction block
[Insert into history_log (id, itemid, clock, timestamp, source, severity, value, logeventid) values ??(74,24998,1286277245,0,'', 0, 'Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen (/ lib64/security/pam_gnome_keyring.so): / lib64/security/pam_gnome_keyring.so: can not open shared object file: No such file or directory ', 0);
]
12754:20101005:151411.939 [Z3005] Query failed: [0] PGRES_FATAL_ERROR: ERROR: current transaction is aborted, commands ignored until end of transaction block
[Select distinct t.triggerid, t.type, t.value, t.error, t.expression, f.itemid from triggers t, functions f, items i where i.status not in (3) and i.itemid = f . itemid and t.status = 0 and f.triggerid = t.triggerid and f.itemid in (24 998) order by t.triggerid]

Judging from the log, the server Zabbix cut Russian letter 'l' (utf8 code 0xd0bb) in half, then attributed to the first 0xd0 single quotation mark (code 0x27) and got the code 0xd027, which is not a valid code utf8.

As a result, the lines similar to those specified in the journal Zabbix does not fall.

original :
-----------------------------------------------------------------------
???????????? ?????????? ????? ? ??????? logrt.

? ?????????????? ???? ??????????? ????? ??????:

Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen(/lib64/security/pam_gnome_keyring.so): /lib64/security/pam_gnome_keyring.so: ?????????? ??????? ??????????? ????????? ????: ??? ?????? ????? ??? ????????

? ???? ??????? Zabbix (zabbix_server.log) ?? ??? ?????? ????????:

12754:20101005:151411.938 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid byte sequence for encoding "UTF8": 0xd027
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
[update items set lastclock=1286277245,prevvalue=lastvalue,lastvalue='Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen(/lib64/security/pam_gnome_keyring.so): /lib64/security/pam_gnome_keyring.so: ?????????? ??????? ??????????? ????????? ????: ??? ?????? ????? ?.',lastlogsize=4524,mtime=1285754770 where itemid=24998;
]
12754:20101005:151411.939 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
[insert into history_log (id,itemid,clock,timestamp,source,severity,value,logeventid) values (74,24998,1286277245,0,'',0,'Sep 29 14:05:53 zabbix-160 passwd: PAM unable to dlopen(/lib64/security/pam_gnome_keyring.so): /lib64/security/pam_gnome_keyring.so: ?????????? ??????? ??????????? ????????? ????: ??? ?????? ????? ??? ????????',0);
]
12754:20101005:151411.939 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
[select distinct t.triggerid,t.type,t.value,t.error,t.expression,f.itemid from triggers t,functions f,items i where i.status not in (3) and i.itemid=f.itemid and t.status=0 and f.triggerid=t.triggerid and f.itemid in (24998) order by t.triggerid]

???? ?? ??, ?????? Zabbix ??????? ??????? ?????? '?' (utf8 ??? 0xd0bb) ??????, ????? ? ??????? 0xd0 ???????? ?????? ????????? ??????? (? 0x27) ? ??????? ??? 0xd027, ??????? ?? ???????? ?????????? ????? utf8.

? ?????, ??????, ??????????? ?????????, ? ?????? Zabbix ?? ????????.



 Comments   
Comment by Aleksandrs Saveljevs [ 2010 Oct 06 ]

Related issue: ZBX-3043.

Comment by Alexander Vladishev [ 2012 Jan 03 ]

Already fixed in version 1.8.10. See ZBX-4424 for more details.

Generated at Thu Apr 25 09:57:29 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.