Also, (sorry if stating the obvious) try to lock resources
for as short a time as possible. If possible, move the whole
transaction into a stored procedure and only do the locking
inside there.
Nice to see someone still using *the* DBMS...
Nick
-----Original Message-----
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 1:22 PM
To: CF-Talk
Subject: RE: Deadlocks in Ingres
Thanks for the help,
I'll have a word with our DB Admin.
Jason Lees
National Express Ltd
E-Mail : [EMAIL PROTECTED]
-----Original Message-----
From: John Forrester [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2001 11:15
To: CF-Talk
Subject: Re: Deadlocks in Ingres
Part of your problem is related to where you place the locks in order to
read or modify. We have similar problems with some old code relating to
updating population changes. The locks are placed at the table level. Result
is a deadlock when too many transactions arrive.
Aside from changing the code you play a little with systems factors like the
fill factor. If locks arrive at a page level, you could config the system to
fill at a reduced rate for each page in order to lock out fewer records. The
way the DB is organized can also be important.
A good place to start with for suggestions etc. would be:
http://www.cs.mu.oz.au/~yuan/Ingres/ingres.html
Playing with fill factors etc need to be understood well - particularly if
you don't have another db system to experiment with.
dott. John Forrester
Senior Networking e Systems Engineer
Ancitel Spa
Tel: +39-06-76291206
Cell: +39-0348-7972041
Fax: +39-06-76291328
email: [EMAIL PROTECTED]
----- Original Message -----
From: "Jason Lees (National Express)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 11:33 AM
Subject: OT : Deadlocks
>
> Hi All,
>
> Our system appears to be generating a lot of Deadlocks when using SELECT,
> how can I get round this, I have <cftransactions> around the select with
the
> BEGIN and READ-UNCOMMITED options set.
>
> The DBMS that we are using in Ingres, and calling through an ODBC
> connection.
>
> Any one have any Ideas about how to resolve the deadlocks?
>
> All help gratefully received.
>
> Jason Lees
> National Express Ltd
> E-Mail : [EMAIL PROTECTED]>
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
