Subject Deadlock in a select statement
Author jensdein
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.