Skip to main content

Search

Welcome to Tibero GTS!

Error Creating Index Primary Key During Insert Execution

Document Type | Troubleshooting

Category | Patch/Upgrade

Applicable Product Version | 6FS07

Document Number | TPATS022

 

Issue

During insert execution, the error Internal Error with condition '(rowno < rowcnt)' (3 args) occurs.
create table t1 (a number, b number);
insert into t1 select level, level from dual connect by level < 1000;
create table t (a number, b number); create index i on t(a, b);
alter table t add constraint pk primary key (a, b) using index i;
insert into t select * from t1;
 
##sys.log
Internal Error with condition '(rowno < rowcnt)' (3 args) (td_ilblk.c:1025:td_ilblk_sclear) (pid=259227, sessid=186, tid=186)

 

 

Cause

An error occurs during insert execution when creating a primary key using a non-unique index.
 
 
 
 

Solutions

This issue is resolved by applying a patch that allows setting a dummy flag when inserting a new key into the index during a split operation if it is a dummy row. (Applied patch: 253866a)

Caution
Apply the patch through technical support provided by Tmax Tibero. 
Note
As an alternative to applying the patch, you can resolve the issue by dropping the error-causing index and recreating it as a unique index. 
drop index i;    โ†’ Drop the existing non-unique index

create unique index i on t(a, b);   โ†’ Recreate as a unique index

 

 

 

 

Related to