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

Details

    • Problem report
    • Status: Confirmed
    • Critical
    • Resolution: Unresolved
    • 5.0.27, 6.0.8, 6.2.2
    • None
    • Frontend (F)
    • Zabbix 5.0.19
      Oracle Database 19c Enterprise Edition 19.11.0.0.0

    Description

      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;

      Attachments

        Activity

          People

            zabbix.dev Zabbix Development Team
            edgar.akhmetshin Edgar Akhmetshin
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: