[ZBX-21636] ORA-12899 error on trigger description field saved without error with incorrect result Created: 2022 Sep 12 Updated: 2024 Apr 10 Resolved: 2023 Sep 12 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F) |
| Affects Version/s: | 5.0.27, 6.0.8, 6.2.2 |
| Fix Version/s: | 6.0.22rc1, 6.4.7rc1, 7.0.0alpha5, 7.0 (plan) |
| Type: | Problem report | Priority: | Critical |
| Reporter: | Edgar Akhmetshin | Assignee: | Janis Freibergs |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | Database, ORA-12899, Oracle | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Zabbix 5.0.19 |
||
| Attachments: |
Screenshot 2022-09-12 at 15.00.35.png
Screenshot 2022-09-12 at 15.00.56.png
|
||||||||
| Issue Links: |
|
||||||||
| Team: |  Team C |
||||||||
| Sprint: | Sprint 103 (Aug 2023), Sprint 104 (Sep 2023) | ||||||||
| Story Points: | 1 | ||||||||
| Description |
|
Steps to reproduce:
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:
|
| Comments |
| Comment by Janis Freibergs [ 2023 Aug 22 ] |
|
Fixed in development branch feature/ZBX-21636-6.0 |
| Comment by Janis Freibergs [ 2023 Sep 04 ] |
|
Fixed in:
|
