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

XMLWordPrintable

    • Type: Problem report
    • Resolution: Won't fix
    • Priority: Critical
    • None
    • Affects Version/s: 4.0.27rc1, 5.0.4
    • Component/s: Server (S)
    • None
    • 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. event_name.diff
          0.5 kB
        2. image-2020-10-28-15-36-08-790.png
          image-2020-10-28-15-36-08-790.png
          135 kB

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

              Created:
              Updated:
              Resolved: