Details

      Description

      I am monitoring Windows EventLog.

      When Zabbix Server receives the log of 255 or more Japanese characters(512 bytes or more ?), an error is outputted and data is not registered.

      This problem occurs in zabbix1.8.8 and 1.8.9 and it does not coour in 1.8.7 and 1.8.6.

      I guess that there is a problem in handling of the Japanese character after 255 character in 1.8.8 or later.

      The following is a log when I test.

      1) Zabbix v1.8.8
      Japanese char 254 -> correct

      [pg_log]

      2011-12-08 11:06:03 JST: 4352: LOG: duration: 0.480 ms statement: insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,alerttype,esc_step) values (4703,4,40420,3,1323309963,4,'sasaki@localhost','[????] Error is output to ApplicationLog on Windows2008: PROBLEM','?????????????

      Error is output to ApplicationLog on Windows2008: PROBLEM
      Last value: ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

      ',0,0,0)

      [zabbix_server.log]

      none

      2) Zabbix v1.8.8
      Japanese char 255 -> Not correct

      [pg_log]

      2011-12-08 11:10:32 JST: 4354: ERROR: invalid byte sequence for encoding "UTF8": 0xe32720
      2011-12-08 11:10:32 JST: 4354: 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".
      2011-12-08 11:10:32 JST: 4354: ERROR: current transaction is aborted, commands ignored until end of transaction block
      2011-12-08 11:10:32 JST: 4354: STATEMENT: insert into history_log (id,itemid,clock,timestamp,source,severity,value,logeventid) values (8,25109,1323310227,1323310148,'EventCreate',4,'???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????',1000);

      2011-12-08 11:10:32 JST: 4354: ERROR: current transaction is aborted, commands ignored until end of transaction block

      [zabbix_server.log]

      3688:20111208:111032.678 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid byte sequence for encoding "UTF8": 0xe32720
      HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encodi
      ng".
      [update items set lastclock=1323310227,lastlogsize=15486,mtime=0,prevvalue=lastvalue,lastvalue='??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????<E3>' where itemid=25109;
      ]
      3688:20111208:111032.679 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of tra
      nsaction block
      [insert into history_log (id,itemid,clock,timestamp,source,severity,value,logeventid) values (8,25109,1323310227,1323310148,'EventCreate',4,'?
      ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????',1000);
      ]
      3688:20111208:111032.679 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of tra
      nsaction block
      [select distinct t.triggerid,t.type,t.value,t.error,t.expression,f.itemid from triggers t,functions f,items i where t.triggerid=f.triggerid and
      f.itemid=i.itemid and t.status=0 and f.itemid in (25109) order by t.triggerid]

      3) Zabbix v1.8.7
      Japanese char 254 -> correct

      [pg_log]

      2011-12-08 11:34:34 JST: 5504: LOG: duration: 0.747 ms statement: insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,alerttype,esc_step) values (4705,4,40681,3,1323311674,4,'sasaki@localhost','[????] Error is output to ApplicationLog on Windows2008: PROBLEM','?????????????

      Error is output to ApplicationLog on Windows2008: PROBLEM
      Last value: ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

      ',0,0,0)

      [zabbix_server.log]

      none

      4) Zabbix v1.8.7
      Japanese char 255 -> correct

      [pg_log]

      2011-12-08 11:38:05 JST: 5504: LOG: duration: 0.764 ms statement: insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,alerttype,esc_step) values (4706,4,40682,3,1323311885,4,'sasaki@localhost','[????] Error is output to ApplicationLog on Windows2008: PROBLEM','?????????????

      Error is output to ApplicationLog on Windows2008: PROBLEM
      Last value: ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

      ',0,0,0)

      [zabbix_server.log]

      none

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              suzuka suzuka
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: