Re: IDS 7.31.UC5 Error 244/143

From: arthur_apw@my-deja.com > >I have a batch system running on 5 small tables. >There are programs inserting data into a table >and other programs looking for data in the table >and prcessing it. >Before a program starts processing a record it locks >the record with a select for update and primary key >the serial of the record. >Then it Update the record (showing its working on the >record) with where serialnr = ....... >This is all done in a transaction >Set Isolation To Dirty Read >Set Lock Mode To Wait 10> >Now i get a error 244 and 143, >and onstat -p is >bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans >1314046 1296 181525187 15991 0 517 21839 526425 > >The funny thing is this code has worked for years >starting form SE 4.01 upto Online 7.31 (installed a month a go) >Over the weekend the system start to generate at random this >error. A meaningless, clutching at straws type guess: index corruption? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

> > A meaningless, clutching at straws type guess: index corruption? But dear Obnoxio, Why does oncheck -cI not report any problems ? You where right after recreating the tables the problem was solved Arthur Sent via Deja.com http://www.deja.com/ Before you buy.