Details
-
Problem report
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
5.0.27, 6.0.8, 6.2.2
-
Zabbix 5.0.19
Oracle Database 19c Enterprise Edition 19.11.0.0.0
-
Team C
-
Sprint 103 (Aug 2023), Sprint 104 (Sep 2023)
-
1
Description
Steps to reproduce:
- 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;
