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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Won't fix
    • Affects Version/s: 3.0.4
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Zabbix 3.0.4
      SLES12sp1
      DB2 Express-C v10.5fp7

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: