[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-5967) Envers Fetching Indexed Collection - Duplicate Row Exception

Envers Fetching Indexed Collection - Duplicate Row Exception ------------------------------------------------------------ Key: HHH-5967 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5967 Project: Hibernate Core Issue Type: Bug Components: envers Affects Versions: 3.6.1 Environment: Hibernate 3.6.1, MySQL 5.1.35 Reporter: Kevin Jordan Assignee: Adam Warski Fix For: 3.6.5, 4.0.0.Beta1 I'm having problems reading from Envers for the revision of something with an indexed collection. Currently the revision shows when things are reordered that there is an entry with a create REVTYPE under the new index and a delete REVTYPE under the old index. When it goes to pull, this causes an "org.hibernate.HibernateException: More than one row with the given identifier was found: {REV=<MyRevisionEntityType>, collection_id=1, obj_id=1}, for class: <MyClass_AUD>". I am using the ValidityAuditStrategy now to try and fix the slowness I was having described in my post at https://forum.hibernate.org/viewtopic.php?f=1&t=1009676, so I'm not sure if that has anything to do with it.