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

[Kevin Jordan (JIRA)]

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


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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira