RE: Locking while inserting new rows.

The only thing I can do is quote the Error Messages manual -- -144 ISAM error: key value locked. The current operation inserts a row with a certain primary key value or updates a row with a certain primary key value, but a transaction that has not yet been committed has deleted that key value from the index. This error occurs only when the lock mode is set to NOT WAIT. Treat it the same as error -107 (record is locked). Roll back the current transaction, and re-execute it after a delay. Then, if the other transaction was committed, the lock no longer exists. If it was rolled back, the key exists, and this operation receives a duplicate-key error. -- I seem to recall reading that shuffling of indexes or some such thing can cause you to get this error too, but for all I know that is just an urban legend. Seeing I tend to frown on not at least having lock mode to wait 1 I have not had to deal with this issue that much. Any reason you can not set lock mode to wait? Will >===== Original Message From jps1x2@halconceramicas.com ===== >Hi all, > >In a RISC/6000 F50 under AIX with a Informix OnLine WorkGroup Server >database Verion 7.20.UC2, we have a problem inserting a new row in a >table. > >We obtain the followin errors: > >SQL statement error number -271. >Could not insert new row into the table. >SYSTEM error number -144. >ISAM error: key value locked> >It is pobible that other rows could be locked, but, How is it posible >if this new row doesn't exist? >Tables have Row Level Locking and Locking to NO WAIT. >How we could solve this problem? > >All help welcome. >Thanks in advance. > >-- >Jorge Palanques >Spain > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------