Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 326777 - Some Core LRG tests hang on MaxDB
Summary: Some Core LRG tests hang on MaxDB
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard: test maxdb
Keywords:
Depends on:
Blocks: 284657
  Show dependency tree
 
Reported: 2010-10-01 09:34 EDT by Adrian Goerler CLA
Modified: 2022-06-09 10:20 EDT (History)
2 users (show)

See Also:

Attachments
proposed patch temporarily reducing the ISO level to READ UNCOMITTED (4.51 KB, patch)
2010-10-01 10:41 EDT, Adrian Goerler CLA 		no flags Details | Diff
proposed patch temporarily reducing the ISO level to READ UNCOMITTED (10.56 KB, patch)
2010-10-01 12:04 EDT, Adrian Goerler CLA 		no flags Details | Diff
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Adrian Goerler CLA 2010-10-01 09:34:14 EDT 
The test ComplexMultipleUnitOfWorkTest and likely others hang on MaxDB.

The issue seems to be the same as https://bugs.eclipse.org/bugs/show_bug.cgi?id=240210:

The problem is transaction isolation: the common pattern for the test is one
connection updating a database row, then another connection trying to read the
row while the first connection has not yet committed the transaction. On MaxDB, the second transaction will hang as MaxDB has a default IsolationLevel READ COMMITED.

As a workaround, the isolation level of the connection used by the second connection can be temporaily reduced to READ UNCOMITTED.
Comment 1 Adrian Goerler CLA 2010-10-01 10:41:57 EDT 
Created attachment 180061 [details]
proposed patch temporarily reducing the ISO level to READ UNCOMITTED
Comment 2 Adrian Goerler CLA 2010-10-01 12:04:31 EDT 
Created attachment 180072 [details]
proposed patch temporarily reducing the ISO level to READ UNCOMITTED

Proposed patch now deregisters the iso level change listeners in the affected tests.
Comment 3 Adrian Goerler CLA 2010-10-01 12:42:42 EDT 
Reviewed by Andrei.
Tested on MaxDB.
Checked in at #8286.
Comment 4 Eclipse Webmaster CLA 2022-06-09 10:20:49 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink