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

ORA-12899 error on trigger description field saved without error with incorrect result

XMLWordPrintable

    • Sprint 103 (Aug 2023), Sprint 104 (Sep 2023)
    • 1

      Steps to reproduce:

      1. Save some text in Cyrillic using Trigger description during template update attached to the hosts;

      Encoding:

      NLS_CHARACTERSET AL32UTF8
      NLS_NCHAR_CHARACTERSET UTF8
      

      Table DDL:

      CREATE TABLE "ZABBIX"."TRIGGERS" 
         (	"TRIGGERID" NUMBER(20,0) NOT NULL ENABLE, 
      	"EXPRESSION" VARCHAR2(2048) DEFAULT '', 
      	"DESCRIPTION" NVARCHAR2(255) DEFAULT '', 
      	"URL" NVARCHAR2(255) DEFAULT '', 
      	"STATUS" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"VALUE" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"PRIORITY" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"LASTCHANGE" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"COMMENTS" VARCHAR2(2048) DEFAULT '', 
      	"ERROR" VARCHAR2(2048) DEFAULT '', 
      	"TEMPLATEID" NUMBER(20,0), 
      	"TYPE" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"STATE" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"FLAGS" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"RECOVERY_MODE" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"RECOVERY_EXPRESSION" VARCHAR2(2048) DEFAULT '', 
      	"CORRELATION_MODE" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"CORRELATION_TAG" NVARCHAR2(255) DEFAULT '', 
      	"MANUAL_CLOSE" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	"OPDATA" NVARCHAR2(255) DEFAULT '', 
      	"DISCOVER" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE, 
      	 PRIMARY KEY ("TRIGGERID")
        USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
        STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
        PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
        BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
        TABLESPACE "ZABBIX_DATA"  ENABLE, 
      	 SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS, 
      	 SUPPLEMENTAL LOG GROUP "GGS_62751" ("TRIGGERID") ALWAYS, 
      	 SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS, 
      	 SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS, 
      	 SUPPLEMENTAL LOG DATA (ALL) COLUMNS, 
      	 CONSTRAINT "C_TRIGGERS_1" FOREIGN KEY ("TEMPLATEID")
      	  REFERENCES "ZABBIX"."TRIGGERS" ("TRIGGERID") ON DELETE CASCADE ENABLE
         ) SEGMENT CREATION IMMEDIATE 
        PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
       NOCOMPRESS LOGGING
        STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
        PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
        BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
        TABLESPACE "ZABBIX_DATA"
      

      Result:

      Expected:

      • ORA-12899 should cause unsuccessful result, data is not saved, this is inconsistent behaviour to finish template update which is attached to different hosts;
      • Field size should be set correctly for different languages to allow same limit for all database backends;

            jfreibergs Janis Freibergs
            edgar.akhmetshin Edgar Akhmetshin
            Team C
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: