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)
CautionApply the patch through technical support provided by Tmax Tibero.
NoteAs 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