\Inetpub\wwwroot\SomeSiteName\index.cfm, line: 270
> "
>
> The error isn't actually in index.cfm but I can deduce what page it's
> on as the site isn't very large and there aren't many queries around
> line 270 of any pages.
>
> I tried setting th
Check out the articles here:
http://stackoverflow.com/questions/661908/sql-server-deadlocks-between-select-update-or-multiple-selects
and here:
http://blogs.msdn.com/b/bartd/archive/2006/09/25/770928.aspx
to troubleshoot and fix different deadlock scenarios.
Paul Cormier
> > > In a smaller app where there is only one piece of code that performs the
> > > actions that are causing deadlocks, sure.
> >
> > No, in most CF applications with deadlocks I've seen, regardless of
> > size and traffic, the deadlocks have in alm
Deadlocks CAN and DO, in a lot of cases, cause other parts of applications
to generate this error.
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Thursday, June 10, 2010 2:00 PM
To: cf-talk
> In a smaller app where there is only one piece of code that performs the
> actions that are causing deadlocks, sure.
No, in most CF applications with deadlocks I've seen, regardless of
size and traffic, the deadlocks have in almost all cases been caused
by the same scrip
I've found this article on SQL deadlocks extremely helpful.
Reducing SQL Server Deadlocks
http://www.sql-server-performance.com/tips/deadlocks_p1.aspx
Paul Alkema
http://paulalkema.com/
-Original Message-
From: Mark A. Kruger [mailto:mkru...@cfwebtools.com]
Sent: Wednesday, Ju
suffer DB performance issues (including deadlocks). It's not wether the code
is split - it's how the DB is being used and how much pressure is put on
shared resources.
Mark A. Kruger, MCSE, CFG
(402) 408-3733 ext 105
Skype: markakruger
www.cfwebtools.com
www.coldfusionmuse.com
www.
In a smaller app where there is only one piece of code that performs the
actions that are causing deadlocks, sure.
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Wednesday, June 09, 2010 7:28
> Since there is no deadlock error until a deadlock exists, the error you
> reported is most likely the victim and not the culprit. Of course it could
> have caused it then the same page was hit again and reported the error.
In most CF applications with deadlocks that I've seen,
bject: Avoiding SQL deadlocks
My understanding and experience is that a well-architected application
should NEVER experience a SQL deadlock. If I am incorrect in this premise,
please let me know.
Based on that assumption, I'm trying to diagnose a client's deadlock
problem. They are a new cl
gs of any kind. :)
A statement like that may seem safe since the mere existence of a
deadlock (or a bug for that matter) could automatically disqualify it
from the well-architected list, but honestly in my experience deadlocks
more commonly come from the devil-in-the-details, not over-arching
fail
2) 408-3733 ext 105
Skype: markakruger
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Andrew Clarke [mailto:s...@clarke.ca]
Sent: Wednesday, June 09, 2010 2:43 PM
To: cf-talk
Subject: SQL deadlocks
(my apologies if this gets posted twice, but the first
x27;ve
temporarily set them all to "serializabile". I also had the client show me
everywhere this particular table is written to (insert/update/delete) and have
put a serializable cftransaction around that code.
If this is
what page it's on as the
site isn't very large and there aren't many queries around line 270 of any
pages.
I tried setting the isolation level to "serializable", thinking that would
bypass the deadlocks. However, they're still happening. If there's nothing
els
Thanks Tom, I found this article on trouble shooting deadlocks and it was quite
helpful. I think I need to create an index on the table.
http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
In step 4 of the article I ran the Analyze Query in DTA and its
On Thursday 17 Dec 2009, Chad Gray wrote:
> I have a feeling in need to optimize my data and not the CF code.
Making it run faster will not stop you getting deadlocks (entangled pairs of
conflicting transactions). It might reduce the frequency of them, however.
You really need to establish
Hello, I have one page that loops over form variables analyzes the variables
and with cfif statements makes decisions on whether to do a SQL update, delete
or insert and I occasionally get SQL deadlocks.
Transaction (Process ID 51) was deadlocked on lock | communication buffer
resources with
Hi,
Did you ever find a solution to this? We are experiencing the same issue.
Thanks
> Hi list,
> we have an ongoing problem
> with deadlocks and the DefaultAppPool
> in IIS.
> I made some dumps with the IIS diagnostics
> tool.
> We run: IIS 6 under W2003 and CFMX 6.1
>
Hi list,
we have an ongoing problem
with deadlocks and the DefaultAppPool
in IIS.
I made some dumps with the IIS diagnostics
tool.
We run: IIS 6 under W2003 and CFMX 6.1
I would love to have a Deadlock-Analyser which
is giving me the template and the CFM-Code,
which is causing this.
Any ideas ?
I
: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: 05 May 2006 15:28
To: CF-Talk
Subject: Re: MySQL deadlocks and timeouts
Thanks for the reply Snake. We aren't specifying the isolation level, but
doesn't that leave it up to the database default? The odd bit is that there
are 162 tables in t
OK, well that could cause some performance issues I suppose. I thought
(for some reason) that the MySQL default for InnoDB tables was
"READ_COMMITTED".
Thanks,
--Ferg
James Holmes wrote:
> From: http://livedocs.macromedia.com/coldfusion/7/htmldocs/0346.htm
>
> "If you do not specify a value
use "READ_COMMITTED" isloation.
> I would suggest you read the cfdocs and fully understand the use of
> cftransaction and isolation levels.
>
> --
> Snake
>
>
> -Original Message-
> From: Ken Ferguson [mailto:[EMAIL PROTECTED]
> Sent: 03 May 2006 20:
From: http://livedocs.macromedia.com/coldfusion/7/htmldocs/0346.htm
"If you do not specify a value for the isolation attribute, ColdFusion
uses the default isolation level for the associated database."
For MySQL InnoDB tables, repeatable_read is the default isolation level:
http://dev.mysql.
al Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: 03 May 2006 20:54
To: CF-Talk
Subject: MySQL deadlocks and timeouts
I'm getting a deadlock error quite frequently on one specific page in my
app. I'm on the latest MX 7 with MySQL 5.
Error Executing Database Query. [Macrom
I'm getting a deadlock error quite frequently on one specific page in my
app. I'm on the latest MX 7 with MySQL 5.
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][MySQL][ODBC 3.51 Driver][mysqld-4.1.12a-nt-log]Deadlock found
when trying to get lock; try restarti
That's not the only situation where you get deadlocks. On Friday we were
discussing that, and the problem then was due to page locks in MSSQL.
The deadlocks in CGLOBAL are at row level, and I see now what that has to do
with the mixing client variables. People probably sent out URLs with
PM
To: CF-Talk
Subject: RE: deadlocks in CFGLOBAL
Thanks, I didn't realize that's all it was storing in CGLOBAL :)
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 12:38 PM
To: CF-Talk
Subject: Re: deadlocks in CFGLOBAL
Client variables
Strange. Deadlocks most often happen when you have code that updates one
row in the DB based on info from another row. Example:
UPDATE cellGlobal
SET myVar = (SELECT myVar from cellGlobal WHERE foo = 1)
WHERE foo = 2;
This code is dangerous because it could cause deadlocks... what if it&#
Thanks, I didn't realize that's all it was storing in CGLOBAL :)
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 12:38 PM
To: CF-Talk
Subject: Re: deadlocks in CFGLOBAL
Client variables use a cookie to look up the client value from th
(LNG)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 12:02 PM
Subject: deadlocks in CFGLOBAL
> Does anyone know why I get row level deadlocks in CFGLOBAL and what are
the
> implications of that?
> The other day I talked to our
Does anyone know why I get row level deadlocks in CFGLOBAL and what are the
implications of that?
The other day I talked to our DBA about some deadlocks (not related to
CFGLOBAL) and she started to look for them... And found a whole bunch of
deadlocks in the CFGLOBAL table. Those are row level
The other day I talked to our DBA about some deadlocks and she started to
look for them... And found a whole bunch of deadlocks in the CFGLOBAL table.
Those are row level locks and if she didn't start looking for them, I would
never take notice that those were happening.
Does anyone know
-Talk
Subject: RE: Deadlocks in Ingres
Next you gonna mention OpenRoada those were the days.
-Original Message-
From: DeVoil, Nick [SMTP:[EMAIL PROTECTED]]
Sent: 01 March 2001 13:44
To: CF-Talk
Subject:RE: Deadlocks in Ingres
Also, (sorry if stating the obvious
Next you gonna mention OpenRoada those were the days.
-Original Message-
From: DeVoil, Nick [SMTP:[EMAIL PROTECTED]]
Sent: 01 March 2001 13:44
To: CF-Talk
Subject:RE: Deadlocks in Ingres
Also, (sorry if stating the obvious) try to lock resources
for as short a
(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 Forr
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 probl
-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,
>
Hi All,
Our system appears to be generating a lot of Deadlocks when using SELECT,
how can I get round this, I have 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
This is a multi-part message in MIME format.
--=_NextPart_000_0038_01C03791.1ADD9A10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hi all
We have an app which was exhibiting strange behaviour until we realised we
needed to read-only lock some applica
39 matches
Mail list logo
