Deadlocks occurring, but not using Session, Appliationor other variables.

[Snarfblat]

I'm getting this error in some cases on a site I developed: Error Executing
Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction
(Process ID 58) was deadlocked on lock resources with another process and has
been chosen as the deadlock victim. Rerun the transaction. The error occurred
on line 105. The line number always changes, but CFMX's lame new error
reporting system (the errors are emailed to me) don't specify what file to go
with the line number. The site is a message forum. I'm not using any session,
application or other variables that the documentation says should be used with
CFLock; I track everything with ordinary cookies. Any ideas on what's causing
this and what I can do to fix it? Thanks! Rob

[OldCFer]

This is a database problem, and has nothing to do with cflock, or CF. What's
happening is
template X puts a lock on table A and requests a lock on table B. At the same
time Template Y
locks table B and requests a lock on table A. This is called a "deadlock" and
MS SQL server will
declare on the victiim and terminate it. You need to examine your queries and
locking strategies.
There's no simple answer.

[Snarfblat]

Thanks for the quick response... I'm not currently using any CFLock commands,
but it appears it would help to do so once I can isolate where the deadlocks
are occurring. The problem now is narrowing down what template(s) are causing
the problem... but without a more verbose error report, I'm kinda stuck. Has
anything ever been said by Macromedia about how to get a better report out of
CFERROR? I sincerely miss CF5's version... Rob

[Lupus 23]

No, that doesn't sound like it would help. Like the first replier said, this sounds like a database problem.

Try putting cftransaction around some of your more used queries.

[Ayera Tech]

Within the CFQUERY(ies) you can also use the 'with NOLOCK' option or set the Isolation llevel different within a CFTRANSACTION if you continue getting the errors.