Re: Having Deadlock Problem

From: andy <anandv81_at_rediffmail.com>
Date: 9 Jun 2004 05:41:17 -0700
Message-ID: <9bfbb3fd.0406090441.42dcfacb@posting.google.com>

Sessions can & do go quietly into enqueue wait state & will wait forever
to acquire a needed ITL slot for an object.

Hello everyone,

Thanks for your responses, I have tried analyzing the suggestions that you made and found the following.

We have MDAC 2.7 installed on the application server and the application server is hosted on windows 2000 advanced server with SP4. Any idea if there are any known issues with this configuration?.

I checked the parameters for the two tables facing this locking problem. They are

STOCKBALANCE:

PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255

INITIAL          512K
MINEXTENTS       1
MAXEXTENTS       2147483645
PCTINCREASE      0
FREELISTS        1
FREELIST GROUPS  1

SERIALNUMBERTRACK:

PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255

INITIAL          902640K
MINEXTENTS       1
MAXEXTENTS       2147483645
PCTINCREASE      0
FREELISTS        1

FREELIST GROUPS 1 As you can see the INITRANS value is set to 1 , should I increase this value, as the number of concurrent users updating this table is more than 1.

I have already tried increasing the distributed lock timeout value and this had a reverse effect, as the first transaction itself was stuck for unknown reason now the other transactions now waiting for locks to be released , take a longer time to rollback.

Thanks in advance

Andy Received on Wed Jun 09 2004 - 07:41:17 CDT