Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 326777

Summary: Some Core LRG tests hang on MaxDB
Product: z_Archived Reporter: Adrian Goerler <adrian.goerler>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: eclipselink.orm-inbox, sabine.heider
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
See Also: https://bugs.eclipse.org/bugs/show_bug.cgi?id=240210
Whiteboard: test maxdb
Bug Depends on:    
Bug Blocks: 284657    
Attachments:
Description Flags
proposed patch temporarily reducing the ISO level to READ UNCOMITTED
none
proposed patch temporarily reducing the ISO level to READ UNCOMITTED none

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