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
