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,'[email protected]','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

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

              Dates

                Created:
                Updated:
                Resolved: