[hibernate-issues] [Hibernate-JIRA] Updated: (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 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.