-
Incident report
-
Resolution: Fixed
-
Major
-
1.8.3
-
Fedora 10, PostgreSQL 8.3.4, Zabbix 1.8.3
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 ?? ????????.