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

Escalator truncates recovery message when inserting it to Zabbix DB.

    XMLWordPrintable

    Details

      Description

      Problem message:

      zabbix: PROBLEM (ICMP Ping loss % (secondary interface))','2016.08.08 16:05:19 ICMP Ping loss % (secondary interface): PROBLEM

      100 %

        6161:20160808:160522.746 End substitute_simple_macros() data:'2016.08.08 16:05:19 ICMP Ping loss % (secondary interface): PROBLEM
      
      100 %
      
      '
        6161:20160808:160522.746 In add_user_msg()
        6161:20160808:160522.746 End of add_user_msg()
        6161:20160808:160522.746 End of add_object_msg()
        6161:20160808:160522.746 In add_message_alert()
        6161:20160808:160522.746 query [txnlev:1] [select m.mediatypeid,m.sendto,m.severity,m.period,mt.status from media m,media_type mt where m.mediatypeid=mt.mediatypeid and m.active=0 and m.userid=68]
        6161:20160808:160522.747 trigger severity:3, media severity:48, period:'1-7,00:00-24:00'
        6161:20160808:160522.747 will not send message (severity)
        6161:20160808:160522.747 trigger severity:3, media severity:63, period:'1-7,00:00-24:00'
        6161:20160808:160522.747 In check_time_period() period:'1-7,00:00-24:00'
        6161:20160808:160522.747 1,16:5
        6161:20160808:160522.747 period [1-7,00:00-24:00]
        6161:20160808:160522.747 1-7,0:0-24:0
        6161:20160808:160522.747 End of check_time_period():SUCCEED
        6161:20160808:160522.747 In DCget_nextid() table:'alerts' num:1
        6161:20160808:160522.747 End of DCget_nextid() table:'alerts' [9403143:9403143]
        6161:20160808:160522.747 query [txnlev:1] [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,error,esc_step,alerttype) values (9403143,68,4924492,68,1470661522,
      1,'my@email','zabbix: PROBLEM (ICMP Ping loss % (secondary interface))','2016.08.08 16:05:19 ICMP Ping loss % (secondary interface): PROBLEM
      
      100 %',0,'',1,0);
      ]
        6161:20160808:160522.747 End of add_message_alert()

      Recovery message. Example 1 (units):

      2016.08.08 16:06:19 ICMP Ping loss % (secondary interface): OK

      0

        6161:20160808:160623.143 End substitute_simple_macros() data:'2016.08.08 16:06:19 ICMP Ping loss % (secondary interface): OK
      
      0 %'
        6161:20160808:160623.143 In add_user_msg()
        6161:20160808:160623.143 End of add_user_msg()
        6161:20160808:160623.143 In add_message_alert()
        6161:20160808:160623.144 query [txnlev:1] [select m.mediatypeid,m.sendto,m.severity,m.period,mt.status from media m,media_type mt where m.mediatypeid=mt.mediatypeid and m.active=0 and m.userid=68 and m.mediatypeid=1]
        6161:20160808:160623.147 trigger severity:3, media severity:48, period:'1-7,00:00-24:00'
        6161:20160808:160623.147 will not send message (severity)
        6161:20160808:160623.147 trigger severity:3, media severity:63, period:'1-7,00:00-24:00'
        6161:20160808:160623.147 In check_time_period() period:'1-7,00:00-24:00'
        6161:20160808:160623.147 1,16:6
        6161:20160808:160623.147 period [1-7,00:00-24:00]
        6161:20160808:160623.147 1-7,0:0-24:0
        6161:20160808:160623.147 End of check_time_period():SUCCEED
        6161:20160808:160623.147 In DCget_nextid() table:'alerts' num:1
        6161:20160808:160623.147 End of DCget_nextid() table:'alerts' [9403151:9403151]
        6161:20160808:160623.147 query [txnlev:1] [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,error,esc_step,alerttype) values (9403151,68,4924501,68,1470661583,1,'my@email','zabbix: OK (ICMP Ping loss % (secondary interface))','2016.08.08 16:06:19 ICMP Ping loss % (secondary interface): OK
      
      0',0,'',0,0);
      ]
        6161:20160808:160623.148 End of add_message_alert()

      Must be (i.e. "%" caracter is missing):

      2016.08.08 16:06:19 ICMP Ping loss % (secondary interface): OK

      0 %


      Example 2 (value mapping):

      2016.08.08 16:06:19 ICMP Ping loss % (secondary interface): OK

      up (


      This issue is actual for the recovery messages only.

        Attachments

        1. action.png
          action.png
          32 kB
        2. r_message-bad.png
          r_message-bad.png
          3 kB
        3. r_messages.png
          r_messages.png
          13 kB

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: