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

IBM DB2 error "Value is too long" for message field in alerts table

    XMLWordPrintable

    Details

      Description

      IBM DB2 error when trying to insert long text in message field in alerts table.

         993:20151112:183728.751 [Z3005] query failed: [-433] 22001 [IBM][CLI Driver][DB2/LINUXX8664] SQL0433N  Value "2015.11.12 09:33:02 New message in file /var/log/websphere/i" is too long.  SQLSTATE=22001 [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,error,esc_step,alerttype) values (8862248,103,3907367,64,1447346248,1,'user@example.com','Websphere iApi: PROBLEM (New message in file /var/log/websphere/iapi_clsrv2.log.2015-11-12)','...Long log message with some text data here...',0,'',1,0);]

      In such case entries are not stored in alerts table thus no messages are sent to recipients when corresponding trigger is fired.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              ingus.vilnis Ingus Vilnis
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: