-107 Error on Online 7.11.UC1
One of our clients is having following problem with Online 7.11.UC1 on
a HP-UX Machine:
create database abc with log;
create table test(ident_nr1 integer, ident_nr2 integer, text char(20))
lock mode row;
create unique index on test (ident_nr1, ident_nr2);
1. User issues:
begin work;
insert into test values (1,1,"bez1");
update test set text = "upd2" where
ident_nr1 = 1 and ident_nr2 = 1;
2. User issues:
begin work;
insert into tet values (2,2,"bez2");
update test set text = "upd2" where
ident_nr = 2 and ident_nr2 = 2;
Error:
-244 Could not do a physical order read
-107 ISAM-Error record is locked
Isolation Level is set to dirty read.
Does anyone know something about this behaviour?
TIA
Tolis Varnas
tvarnas@compulink.gr