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

Bug 329380

Summary:	HistoryTestModel periodically fails on MySQL
Product:	z_Archived	Reporter:	Tom Ware <tom.ware>
Component:	Eclipselink	Assignee:	Nobody - feel free to take it <nobody>
Status:	CLOSED FIXED	QA Contact:
Severity:	major
Priority:	P3	CC:	eclipselink.foundation-inbox
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Whiteboard:

Description Tom Ware

2010-11-03 13:46:00 EDT

See Bug 210270.

Bug 210270 fixed some tests.  Some additional tests are failing because of the temporal precision issue detailed in this bug.

Failures are periodic and of the fom:

Internal Exception: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '9801-2-2010-11-03 12:27:17' for key 1 Error Code: 1062 Call: INSERT INTO EMPLOYEE_HIST (EMP_ID, F_NAME, L_NAME, GENDER, START_TIME, END_TIME, END_DATE, START_DATE, ADDR_ID, MANAGER_ID, VERSION, ROW_START) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9801, JohnMU, Way, M, 08:00:00, 17:30:00, null, 1991-11-11, 1109, 9802, 2, 2010-11-03 12:27:17.966] Query: UpdateObjectQuery(Employee: JohnMU Way)

Comment 1 Tom Ware

2010-11-03 13:46:28 EDT

Targetting for 2.1.2 because these are LRG failures.

Comment 2 Tom Ware

2010-11-03 13:50:15 EDT

Fixed by wrapping tests in the same way as the fix listed in the related bug above.  Change removes any restriction on which tests are wrapped.  (Previously on tests with the string WriteObjectTest in their name were wrapped)

Tested with HistoryTests on MySQL

Reviewed by Chris Delahunt and Andrei Ilitchev

Comment 3 Eclipse Webmaster

2022-06-09 10:23:51 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink