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

Improper sql escaping: query failed: Incorrect string value

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 4.2.7, 4.4.1
    • Server (S)
    • None
    • Ubuntu Xenial

      I noticed some sql errors on my zabbix server logs:

      cat /var/log/zabbix/zabbix_server.log | grep "query failed"
      6452:20191027:115123.022 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E201...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572169868,488732500,1572169731,'Microsoft-Windows-Kernel-General',1,'The system time has changed to ‎2019‎‎10‎‎27T09:48:51.468565500Z from ‎2019‎‎10‎‎27T09:48:54.853051200Z.
      6452:20191027:115123.028 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E201...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572169889,502179200,1572169731,'Microsoft-Windows-Kernel-General',1,'The system time has changed to ‎2019‎‎10‎‎27T09:48:51.472588500Z from ‎2019‎‎10‎‎27T09:48:51.468565500Z.
      6452:20191027:115123.029 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E201...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572169904,512545400,1572169731,'Microsoft-Windows-Kernel-General',1,'The system time has changed to ‎2019‎‎10‎‎27T09:48:51.476260600Z from ‎2019‎‎10‎‎27T09:48:51.472588500Z.
      6455:20191027:210919.723 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E12....' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (37576,1572203358,165432880,1572203335,'Microsoft Antimalware',1,'%%860 has removed history of malware and other potentially unwanted software.
      6453:20191028:130818.309 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E201...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572260933,566346900,1572260779,'Microsoft-Windows-Kernel-General',1,'The system time has changed to ‎2019‎‎10‎‎28T11:06:19.386550700Z from ‎2019‎‎10‎‎28T11:06:22.246530100Z.
      6453:20191028:130818.314 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E201...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572260933,569247000,1572260779,'Microsoft-Windows-Kernel-General',1,'The system time has changed to ‎2019‎‎10‎‎28T11:06:19.388328100Z from ‎2019‎‎10‎‎28T11:06:19.386550700Z.
      6453:20191028:130818.315 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E201...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572260933,570800700,1572260779,'Microsoft-Windows-Kernel-General',1,'The system time has changed to ‎2019‎‎10‎‎28T11:06:19.394680100Z from ‎2019‎‎10‎‎28T11:06:19.388328100Z.
      6452:20191028:210911.227 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E13....' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (37576,1572289744,473114310,1572289745,'Microsoft Antimalware',1,'%%860 has removed history of malware and other potentially unwanted software.
      6450:20191028:233315.025 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E206...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572298405,272489000,1572298329,'Microsoft-Windows-FilterManager',1,'File System Filter \'WdFilter\' (Version 10.0, ‎2066‎‎04‎‎09T06:52:09.000000000Z) unloaded successfully.',1);
      6450:20191028:233315.026 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E204...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572298420,272569200,1572298333,'Microsoft-Windows-FilterManager',1,'File System Filter \'WdFilter\' (10.0, ‎2047‎‎09‎‎15T12:44:56.000000000Z) has successfully loaded and registered with Filter Manager.',6);
      6452:20191029:130824.890 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E201...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572347343,52088200,1572347200,'Microsoft-Windows-Kernel-General',1,'The system time has changed to ‎2019‎‎10‎‎29T11:06:40.436473400Z from ‎2019‎‎10‎‎29T11:06:43.165909900Z.
      6452:20191029:130824.929 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E201...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572347343,55106700,1572347200,'Microsoft-Windows-Kernel-General',1,'The system time has changed to ‎2019‎‎10‎‎29T11:06:40.438378800Z from ‎2019‎‎10‎‎29T11:06:40.436473400Z.
      6452:20191029:130824.929 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E201...' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (133710,1572347343,56178500,1572347200,'Microsoft-Windows-Kernel-General',1,'The system time has changed to ‎2019‎‎10‎‎29T11:06:40.445261800Z from ‎2019‎‎10‎‎29T11:06:40.438378800Z.
      28005:20191029:210919.109 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x80\x8E14....' for column 'value' at row 1 [insert into history_log (itemid,clock,ns,timestamp,source,severity,value,logeventid) values (37576,1572376157,674208420,1572376134,'Microsoft Antimalware',1,'%%860 has removed history of malware and other potentially unwanted software.

      Seems like coming from Windows event log...
       

            zabbix.support Zabbix Support Team
            elderone Taavi
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: