Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 329380 - HistoryTestModel periodically fails on MySQL
Summary: HistoryTestModel periodically fails on MySQL
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-11-03 13:46 EDT by Tom Ware CLA
Modified: 2022-06-09 10:23 EDT (History)
1 user (show)

See Also:

Attachments
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 Tom Ware CLA 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 CLA 2010-11-03 13:46:28 EDT 
Targetting for 2.1.2 because these are LRG failures.
Comment 2 Tom Ware CLA 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 CLA 2022-06-09 10:23:51 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink