Bugs item #758108, was opened at 2003-06-20 12:05 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=758108&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Jeremy Boynes (jboynes) Assigned to: Jeremy Boynes (jboynes) 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 ---------------------------------------------------------------------- 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: INetU Attention Web Developers & Consultants: Become An INetU Hosting Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission! INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
