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

Insert into events table query failed ORA-12899: value too long for column "ZABBIX"."EVENTS"."NAME"

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Critical Critical
    • None
    • 4.0.27rc1, 5.0.4
    • Server (S)
    • None
    • Team C
    • Sprint 69 (Oct 2020), Sprint 70 (Nov 2020)
    • 0.5

      *Steps to reproduce:*h
      Zabbix server insert events and sometimes there is query failed with ORA-12899. Zabbix tries to push line with length 2048 when Oracle has a limit to 2000.
      This possible t reproduce with long value and put in trigger name the macro

      {ITEM.VALUE}

      Result:
      See screenshot

      Expected:
      Probably before inserting this line should be truncated to be inserted properly. otherwise I think we lost this event at all.

        1. image-2020-10-28-15-36-08-790.png
          image-2020-10-28-15-36-08-790.png
          135 kB
        2. event_name.diff
          0.5 kB

            dgoloscapov Dmitrijs Goloscapovs
            neogan Andrei Gushchin (Inactive)
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: