(Fwd) Re: 7.11 Failures : Mail failure

--- Forwarded mail from Adminstrator <POSTMASTER@vrx.vrx.vhi.com> From: Adminstrator <POSTMASTER@vrx.vrx.vhi.com> To: Jim Gordon <jgordon@us.DHL.COM> Subject: Mail failure Date: Tue, 05 Dec 95 18:29:00 EST User mail received addressed to the following unknown addresses: VRX/VRX/prokschd ------------------------------------------------------------------------------ On Dec 5, 5:08pm, Apostolos Varnas wrote: } Subject: -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 I tried this script on our HP box with 7.11.UC1 and after correcting the syntax errors the script worked as expected with no errors. Are you sure that your index was actually built when you ran your script as the command to create it is not correct and without the index you will get the error that you describe. Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine! ---End of forwarded mail from Adminstrator <POSTMASTER@vrx.vrx.vhi.com> -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!