[hibernate-issues] [JIRA] (HHH-13867) StaleObjectStateException into a SINGLE transaction for entity with version field of type java.util.Date

Глеб Егунов ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjM1NWY3ZjI5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-13867?atlOrigin=eyJpIjoiZjM1NW... ) HHH-13867 ( https://hibernate.atlassian.net/browse/HHH-13867?atlOrigin=eyJpIjoiZjM1NW... ) StaleObjectStateException into a SINGLE transaction for entity with version field of type java.util.Date ( https://hibernate.atlassian.net/browse/HHH-13867?atlOrigin=eyJpIjoiZjM1NW... ) Issue Type: Bug Assignee: Unassigned Created: 14/Feb/2020 08:31 AM Priority: Major Reporter: Глеб Егунов ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) He team! We got stuck with the following issue: StaleObjectStateException arises during the update execution into the SINGLE transaction. Feel free to look at the code on *bitbucket* : https://bitbucket.org/gegunov/hibernate_issue/src/master/ *README* with examples are also attached there. Steps to reproduce: *prerequisites* : * Table DDL CREATE TABLE `payment` ( `id` int (11) NOT NULL AUTO_INCREMENT, `status` varchar(45) DEFAULT NULL, `last_update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `id_UNIQUE` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 * Entity class with fields: 1) of type *java.util.Date* annotated by *@Version* e.g *lastUpdateDate* 2) of type java.util.String for *state* 3) of type Long (for *Id* ) * Create entity having any state. * Then in the other transaction execute the following steps: * *find* the created entity with entityManager.find * *update* the field state (of type String) * execute another one *select* from database using entityManager. It doesn't matter what it will return. It could even return *nothing*. In the provided code I deliberately use keys which not exist in DB * *update* the entity again with different value. * When the transaction is being committed it will fail with the following error *org.hibernate.StaleObjectStateException* : Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) It should be said that the mentioned behavior is not reproduced with the version field of type *short* , only with *java.util.Date* ( https://hibernate.atlassian.net/browse/HHH-13867#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13867#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100120- sha1:2415f4c )