Re: -143 Error - Deadlock detected.

}>From ilist@rmy.emory.edu Tue Apr 15 16:22:43 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (940816.SGI.8.6.9/930416.SGI.AUTO) }> for <settler@dbintellect.com> id QAA22798; Tue, 15 Apr 1997 16:22:42 -0600 }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id PAA29645 for informix-list-out; Tue, 15 Apr 1997 15:25:01 -0400 (EDT) }>Message-Id: <s3548c2e.005@kiwi.co.nz> }>X-Mailer: Novell GroupWise 4.1 }>Date: Wed, 16 Apr 1997 07:23:44 +1200 }>From: Peter Tashkoff <TASHKOP@kiwi.co.nz> }>To: informix-list@rmy.emory.edu }>Subject: -143 Error - Deadlock detected. }>Sender: informix-list-owner@rmy.emory.edu }>Reply-To: Peter Tashkoff <TASHKOP@kiwi.co.nz> }>X-Informix-List-Id: <list.14006> }> }>Hi Folks }>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. }> }>The benefit of anyone's experience on this would }>be most appreciated. }> }>I will summarise to the list. }> }>TIA }>Peter Tashkoff <tashkop@zespri.co.nz> }>Zespri International Limited }>This posting may not be used by any party to vilify }>another. Standard disclaimers apply. }> }> I was working with version 7.12UC2, and we got similar errors. We were executing multi-threaded applications that were doing inserts and updates to the same table concurrently. Even though they weren't ever updating the same row, we got row lock errors. Tech support said it was due to the inserts. During an insert, Informix places a "key lock" on a row that does not exist. If another process tries to insert a row, it tries to place the same key lock, resulting in the lock error. This is described in the Tutorial manual. Maybe this is what is happening to you. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------