Re: Concurrency between processes

Posted in 1996

Bryan Tonnet — 19 Dec 1996 12:32:19 +1100 — source: Informix-list mailing list archive (1991-1998)

In <32B7B488.781F@cpm.elex.co.il> PROJECT Yakov Berkovitch 3351 <berko@cpm.elex.co.il> writes: >When 2 processes are trying to update the same table (and it's never the >same row !!!), the second process failed with one of the following >errors 244, 245, 246, 346. And this process that failed NEVER wait for >the 90 seconds. Is it a normal comportment, normal feature ???? These error numbers would seem to indicate some corruption in the database itself. Have you checked the integrity of the DB? Your problem may not be locking at all. Bryan Tonnet batonnet@zeta.org.au