Subject | Deadlock in a select statement |
---|---|
Author | jensdein |
Post date | 2004-09-23T07:47:51Z |
Hi,
I have a problem that has been bugging me for a while now. In my main
transaction I use a Cuncurrency locking isolation. I try to make sure
that changes are committed on a regular basis.
Somehow my users a sometimes getting a deadlock situation on a pure
select statement (no updates, just read only) using Committed
isolation.
How is that possible? I thought I shoulden't be getting a deadlock on
a select statement - only on changes!!
Hov do I eventaully resolve what caused the lock?
regards,
Jens Dein
PS.
Using FB 1.5 and IBObjects for connectivity - if that is of any
importance.
I have a problem that has been bugging me for a while now. In my main
transaction I use a Cuncurrency locking isolation. I try to make sure
that changes are committed on a regular basis.
Somehow my users a sometimes getting a deadlock situation on a pure
select statement (no updates, just read only) using Committed
isolation.
How is that possible? I thought I shoulden't be getting a deadlock on
a select statement - only on changes!!
Hov do I eventaully resolve what caused the lock?
regards,
Jens Dein
PS.
Using FB 1.5 and IBObjects for connectivity - if that is of any
importance.