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

Details

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

    Description

      *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.

      Attachments

        Activity

          People

            dgoloscapov Dmitrijs Goloscapovs
            neogan Andrei Gushchin
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: