Re: -143 Error - Deadlock detected.

Peter Tashkoff wrote: > > I have a situation where we are receiving a -143 > error, potential deadlock detected > in stored procedures called from > both Cobol and Informix programs. This is > a nasty that I personally have not seen in the past. > > Lock mode is set to wait. If set to not wait, > then we receive a simple 107, record is locked. > > The stored procedures are layered, one calling > another etc. > > Version is 7.13UC3X1. 1. Are you using PAGE or ROW level locking? 2. Distributed or not? 1. Try ROW level locking. 2. Increase timeout parameter. Otherwise, send some code examples. Cheers, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+