Envers Fetching Indexed Collection - Duplicate Row Exception

Description

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.

Environment

Hibernate 3.6.1, MySQL 5.1.35

Status

Assignee

AdamA

Reporter

Kevin Jordan

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

3.6.1

Priority

Major
Configure