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

Zabbix server stops to send notifications after IBM DB2 SQL error (string escaping).

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Blocker Blocker
    • None
    • 3.0.4
    • Server (S)
    • Zabbix 3.0.4
      SLES12sp1
      DB2 Express-C v10.5fp7

      Zabbix server stops to send notifications after this error:

        6161:20160818:105058.988 [Z3005] query failed: [-10] 42603 [IBM][CLI Driver][DB2/LINUXX8664] SQL0010N  The string constant beginning with "'VMSSSSSTEST: New error message in Windows Application log  Zabbix tim" does not have an ending string delimiter.  SQLSTATE=42603 [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,
      message,status,error,esc_step,alerttype) values (9475994,74,4977300,56,1471506658,1,'[email protected]','VMSSSSSTEST: New error message in Windows Application log','VMSSSSSTEST: New error message in Windows Application log
      Zabbix timestamp: 2016.08.17 15:29:21
      Agent timestamp: 2016.08.17 15:29:09
      Source="SSSSS" Severity=Error
      
      Serious: Unexpected return code:
              Message catalog: 1, Message number: 1000
              Context: SOAP Message parsing failed : sss-complex-type.2.4.b: The content of element ''ns2:ReadExpandedCorresp
      ondents'' is not complete. One of ''{"sss:sssss:sss:ssss":Identifier}'' is expected.
              Program: SS_appsrv, file: Logerrorssssss, line: 11, function:LogerrorOperation::E.',0,'',1,0);
      ]

      Looks similar to ZBX-3255.

            Unassigned Unassigned
            oleg.ivanivskyi Oleg Ivanivskyi
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: