Hi,
I'm running into table lock contention: 2 sessions are blocking waiting for
a blocked session (both an insert and a delete statement waiting on a select
statement!). This doesn't make any sense to me, therefore, without even
understand my application, can someone please tell me under what
circumstances a table/row is locked exclusively if Optimistic=true &
LockManager=version? A few facts:
1) My app doesn't acquire any lock explicitly through JPA or native queries
"select ... for update", "lock table ...", etc.
2) I'm sure my app causes this contention.
3) It seems the table is lock in exclusive mode i.e. can only query,
however, I can't verify this.
OpenJPA 1.0.0
Oracle 10g R2
Oracle JDBC 10.1.0.3
Thanks very much in advance,
Frank
Keywords: database hangs, lock, contention, deadlock
--
View this message in context: http://n2.nabble.com/Under-what-circumstances-a-table-row-is-locked-exclusively-if-Optimistic%3Dtrue---LockManager%3Dversion--tp581619p581619.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
|