Bugs item #758108, was opened at 2003-06-20 22:05
Message generated for change (Comment added) made by loubyansky
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=758108&group_id=22866

Category: JBossCMP
Group: v3.2
>Status: Closed
>Resolution: Rejected
Priority: 5
Submitted By: Jeremy Boynes (jboynes)
Assigned to: Alexey Loubyansky (loubyansky)
Summary: Deadlocks occur is connection is SERIALIZABLE

Initial Comment:
If the database connection is running with a
SERIALIZABLE isolation level, deadlocks can occur on
databases such as SQL Server that use pessimistic locking.

Consider two threads R and W, where R just reads a
value and W does updates. The deadlock occurs under the
following circumstance:
W executes a finder, which takes a S lock on the row
R executes a finder, which also takes an S lock
W reads a field, which takes an EJB lock and uses its
existing S lock
R reads a field, which blocks in JBoss due to the EJB
lock held by W
W tries to write the field, but blocks converting its S
lock to 
  an X lock due to the S lock held by R

We are now deadlocked


----------------------------------------------------------------------

>Comment By: Alexey Loubyansky (loubyansky)
Date: 2004-08-04 17:17

Message:
Logged In: YES 
user_id=543482

For deafult EJB containers with pessimistic locking this is
not a bug. Use read-only or other container configurations.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=758108&group_id=22866


-------------------------------------------------------
This SF.Net email is sponsored by OSTG. Have you noticed the changes on
Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
one more big change to announce. We are now OSTG- Open Source Technology
Group. Come see the changes on the new OSTG site. www.ostg.com
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to