Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
MIME-Version: 1.0
From: Malte <malte.neumann@googlemail.com>
Date: Mon, 24 Apr 2017 17:55:11 +0200
Message-ID: <CAK+jZZARk_=q6VSpuGfQMv-3s-tOL=EG9jTwcM3gw3hOR6XBQg@mail.gmail.com>
Subject: Problem with EntityExistsException
To: users@openjpa.apache.org
Content-Type: multipart/mixed; boundary=001a1143e1c8e1d001054deba11e
archived-at: Mon, 24 Apr 2017 15:55:23 -0000

--001a1143e1c8e1d001054deba11e
Content-Type: multipart/alternative; boundary=001a1143e1c8e1cffe054deba11c

--001a1143e1c8e1cffe054deba11c
Content-Type: text/plain; charset=UTF-8

Hello all!

In a special situation, I'll get a wrong EntityExistsException.

I've extract the problem to a simple project (attached).

I do this:
   try {
     entManager.persist(data);
     entManager.flush();
     entManager.detach(data);

     doOtherDBCallsWithError();

     entManager.getTransaction().commit();
   } catch (Exception e) {
      entManager.getTransaction().rollback();

      entManager.getTransaction().begin();
      entManager.persist(data);
      entManager.getTransaction().commit();
   }

If doOtherDBCallsWithError throws an Exception, it is not possible to
persist the object in the catch-block. The second persists throws
"org.apache.openjpa.persistence.EntityExistsException: Attempt to persist
detached object "de.test.model.Test-1".  If this is a new instance, make
sure any version and/or auto-generated primary key fields are null/default
when persisting." If I use merge instead, the object will also not persist.
If I remove the detach, everything works.

Is this a bug or is the call order persist-flush-detach-commit against the
specification?

Best regards,
Malte

--001a1143e1c8e1cffe054deba11c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hello all!<br><br></div><div>In a special situation, =
I&#39;ll get a wrong EntityExistsException.<br><br></div><div>I&#39;ve extr=
act the problem to a simple project (attached).<br><br></div><div>I do this=
:<br><span style=3D"font-family:monospace,monospace">=C2=A0=C2=A0 try {<br>=
=C2=A0=C2=A0=C2=A0=C2=A0 entManager.persist(data);<br>=C2=A0=C2=A0=C2=A0=C2=
=A0 entManager.flush();<br>=C2=A0=C2=A0=C2=A0=C2=A0 entManager.detach(data)=
;<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <br=
>=C2=A0=C2=A0=C2=A0=C2=A0 doOtherDBCallsWithError();=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <br>=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <br>=C2=A0=C2=A0=C2=A0=C2=A0 ent=
Manager.getTransaction().commit();<br>=C2=A0=C2=A0 } catch (Exception e) {<=
br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 entManager.getTransaction().rollback();<b=
r>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <br></=
span><span style=3D"font-family:monospace,monospace"><span style=3D"font-fa=
mily:monospace,monospace">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 </span>entManager.=
getTransaction().begin();<br></span><span style=3D"font-family:monospace,mo=
nospace"><span style=3D"font-family:monospace,monospace">=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 </span>entManager.persist(data);<br>=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0 </span><span style=3D"font-family:monospace,monospace"><span style=
=3D"font-family:monospace,monospace"></span>entManager.getTransaction().com=
mit();<br>=C2=A0=C2=A0 }=C2=A0=C2=A0</span>=C2=A0=C2=A0 <br><br></div><div>=
If doOtherDBCallsWithError throws an Exception, it is not possible to persi=
st the object in the catch-block. The second persists throws &quot;org.apac=
he.openjpa.persistence.EntityExistsException: Attempt to persist detached o=
bject &quot;de.test.model.Test-1&quot;.=C2=A0 If this is a new instance, ma=
ke sure any version and/or auto-generated primary key fields are null/defau=
lt when persisting.&quot; If I use merge instead, the object will also not =
persist. If I remove the detach, everything works.<br><br></div><div>Is thi=
s a bug or is the call order persist-flush-detach-commit against the specif=
ication?<br><br></div><div>Best regards,<br></div><div>Malte<br></div></div=
>

--001a1143e1c8e1cffe054deba11c--

--001a1143e1c8e1d001054deba11e
Content-Type: application/zip; name="test.zip"
Content-Disposition: attachment; filename="test.zip"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_j1wani740

UEsDBBQAAAAIAACEmEqw6uN4ugEAAMwEAAAHAAAAcG9tLnhtbI2TTU/cMBCGz6nU/xCteo2dbPdQ
VmmkHlq1EhSkXRA3ZOwhZJXYwfZ+IMR/Z+LYYYElWlk5+J1nZl57nLzVagXcxrumlubn5N7adk5p
wzYgCWsZvweidEkvzs/ojKQknfTkfGeqgd5ut2T73XHTNM3o9dnpAhMbllTSWCY5TGLk58aJp4oz
Wyl5RLP4M2JnRC8mjiO4nxRfv8Rx3igB9RVogx0KF8zpvtZTpVbr9p8oBBALxubUC32UaVvdMW5x
v2pZTsM+xDe+VNc5Sxb/f10s/p4vc7rZbyFZA4VqQWKJpevRKS7WfRHePEaxMhgUoyhMgtyuq1oQ
o9aaw2/JlahkWVwu/yQ/cjrG+CrK2BLMQ01W4paTYOkEjZ6kmRNnWOcg1VfwngdxSmZkmlMvv2X7
wXDVtFUN2hsqMoJWD4YOZlmmS7BD1sdQl+XO/npfuFATgKYESB7EaE97dM2iYdbuzLo79DDunhjm
/Q4K8sCFo397Onx/z/tPAHn6xku34jGD+LDDG/eXPWLUEwmrx5167liLR/orQStZNYqYFrgZsRnA
BD3cTEl60yWMGM5INuow7F+HPvwUxQtQSwMEFAAAAAAAgYOYSgAAAAAAAAAAAAAAAAQAAABzcmMv
UEsDBBQAAAAAAIGDmEoAAAAAAAAAAAAAAAAJAAAAc3JjL21haW4vUEsDBBQAAAAAAMiImEoAAAAA
AAAAAAAAAAAOAAAAc3JjL21haW4vamF2YS9QSwMEFAAAAAAAOoSYSgAAAAAAAAAAAAAAABEAAABz
cmMvbWFpbi9qYXZhL2RlL1BLAwQUAAAAAADZiZhKAAAAAAAAAAAAAAAAFgAAAHNyYy9tYWluL2ph
dmEvZGUvdGVzdC9QSwMEFAAAAAgAAY2YSut4pENDAwAAUwwAAB8AAABzcmMvbWFpbi9qYXZhL2Rl
L3Rlc3QvTWFpbi5qYXZhtVZfT9swEH9H4jvc+uROEDZpT8CQCnRPZTDaaQ/THlzn2hqSONhOoUN8
952bNH/qQtNNs6rUse9+97vznS8pF/d8ihBiYNHYk/29/T0Zp0pbuONzHmRWRkFPa74YSLftbxbr
jZ2nIEVtaAMTgcH72vbKUBCrEKNgtLKZZuNIChARNwauuEzgeX8PaKRazrlFMJZbEugnVtrFFU+I
tP7ChVV6AZjY5srJdt2aUiGdP3MiK5W5kiHERIcNrZbJ9Ocv4Hpquit2uRVMuUbWPanWqhl5SE5z
y+EzJPi4fGcfD6DjJgmPsbNZr6IXTNGONE8M+SZVwrrBGKfEqK5n9SKnVI3hgsIfByqzQUrUbZSw
zvJUCj7HpeE14z6BQo05tVLJF5tEmZmxNwRCtFzMNsI030J1bWeoL88veBSZH9LO+lorTdh1qZbs
vfAJFcfSEtj2gOWiYDIh0JhGxF5AcCtmwPpPAlMHDdhtcwgTLqNM4+GZVlE0pvrreCHLhYeWNom6
cLnV3r0VrKe0nZpLIz6ldO/sYnCVjn+VP0dHNcEY9RQLsX870JeGzy/539qtUJV4WcONA5SJtOWd
QYYbBkKtUlfCIz6OmucjNBK8v16fvXUIFPu3BQ53HFsBSaBlnF4tTLAzrR4NVMXw7NlErSubYFSM
oBwaWcgmE3gkNEAHVyecA7urs8Qm7XLanrp/mhVDv4PQbX1Ta2H5mW5qPqxzl3LX0ZZMfDwC8sA3
wbHWjjQyr+GFa8WneaM6A/MQXcShKdpO2cJPzzYn5Uo+4GHIOpe31zcw6p0P+uD5VvPyCUVmcUia
VIE8CQ0rUA6oI2VYc2mLU82igf/i08Vtvzfq17xiy6ywB+DaMMy5FjOu2acP3e7KXx+kNxj1b2sY
0Lu8dA7FnHLmHheE6bRh13BNeGQoXrvdWhsAN4SLlsjHsVIR8gTkNFEal1Xb/IyZKA3FVw6IHO64
hkCy7S9kryP4HynV+JYhbTy4Z6NYiir5Sv7OcSnECl4lcDVy/aCIyPeUekh1+7alvdZHvE5fuxGa
TX83M80GvTbkBNi7109pSwdHZ22gBI/kbwyv6JuFKLDuuqHm3Ypru0Xurb/60/qs2KLfH1BLAwQU
AAAAAACHjJhKAAAAAAAAAAAAAAAAHAAAAHNyYy9tYWluL2phdmEvZGUvdGVzdC9tb2RlbC9QSwME
FAAAAAgApYyYShVefXVZAQAA3gIAACUAAABzcmMvbWFpbi9qYXZhL2RlL3Rlc3QvbW9kZWwvVGVz
dC5qYXZhdVHdboIwFL6WhHc44UqJqdm1IXHZXELitmy63Vd6xG6lsPZo5hbffS3g0BCBkHK+8/2F
imefPEcQyAgtsaIUqKZhEAayqEpD8MH3nMmSLdFIruQPXyucXqDfrEJjpSXUGbLYgf6exHEYQAyr
LcI/TpApbi1sSgPkAG8JghNfc+u+vDarWf41CYPZXJOkgzs88QLFyw7NYajdMYlWPu1GanGrVDSG
Lw8l0XK+mN+tgODh9fkR/A5QNAqDardWMmvcm7EroLBwkSycV4PfMBhURu45IVji5FjOhStQpc7B
1qvvvk+p39J7SOBmUTcezFJxRk01YY4GpPBoN1+SkU7Hd2gA9zTh6ljDUR3g2Ac6wfG5SLMP7qKt
tEwKSBrPbubX3LS2bLQ76ZNqjpSK1nxgkHZGnwR7nH3pXGxN6EK11C5En9jG9l7+b166dVGv+LWk
XvXBlY7+Pv4BUEsDBBQAAAAAAMiImEoAAAAAAAAAAAAAAAAXAAAAc3JjL21haW4vamF2YS9NRVRB
LUlORi9QSwMEFAAAAAgAh4yYSiRJ1hrFAQAANgQAACYAAABzcmMvbWFpbi9qYXZhL01FVEEtSU5G
L3BlcnNpc3RlbmNlLnhtbJ1T72vbMBD9nEL/B6HPiZyksBVjp4SmgYHXZWnG9i1otmYryJInne3k
v9/JdI4zGP1hg9G9e/fe6SRHd8dSkUZYJ42O6YxNKRE6NZnUeUy/7daTW3q3uL6KKk9xgDlxps/Z
jF5fjVBCu5gWAFUYBF3EDmnFjM19FGgXDMop6Rjh0cm+pm1b1t50BfPpdBb8+Jw8pYUo+URqBxyr
vA9WhK6DE5NywBZebUpeyRuu9/P9jB1dRhfoPRzApNYSiOaliOmh4iAcdJxRlCru3CITzGOsNJlQ
bIfLKOgySMLXEytrUBCk8NjoDJz+yvKGH9nAkx2ynymrraKk4apGigfCyjjIrXC/FW5O4VRUgUj4
4fbjTYCt7bveSPA2Eyds7+IFPPBWkQq32xqb9ULv6SSzshn0gkfGzhtmqy77X00MNI6AJSb3lwef
Z5mV+MVrBYlohIq/L7ePY7KtNUgs+vS4/jImO2PU8/LpaxLvtsv7hxdt7o3WIvWXcs1TMPa06Y/4
0n5jBQBmpYYYbC3GZIAkUotE6ByKeDafYsqDG27RCnA6XcGLraxOGMv0QRf+zymFhmWOn36OQ5Eo
uLiKGP970RG9ADH+A1BLAwQUAAAAAACBg5hKAAAAAAAAAAAAAAAAEwAAAHNyYy9tYWluL3Jlc291
cmNlcy9QSwMEFAAAAAAAgYOYSgAAAAAAAAAAAAAAAAkAAABzcmMvdGVzdC9QSwMEFAAAAAAA2YmY
SgAAAAAAAAAAAAAAAA4AAABzcmMvdGVzdC9qYXZhL1BLAwQUAAAAAADZiZhKAAAAAAAAAAAAAAAA
EQAAAHNyYy90ZXN0L2phdmEvZGUvUEsDBBQAAAAAANmJmEoAAAAAAAAAAAAAAAAWAAAAc3JjL3Rl
c3QvamF2YS9kZS90ZXN0L1BLAwQUAAAAAADZiZhKAAAAAAAAAAAAAAAAHAAAAHNyYy90ZXN0L2ph
dmEvZGUvdGVzdC9tb2RlbC9QSwMEFAAAAAAAgYOYSgAAAAAAAAAAAAAAABMAAABzcmMvdGVzdC9y
ZXNvdXJjZXMvUEsBAj8AFAAAAAgAAISYSrDq43i6AQAAzAQAAAcAJAAAAAAAAAAgAAAAAAAAAHBv
bS54bWwKACAAAAAAAAEAGACI/0OIB73SAWC+nPkGvdIBYL6c+Qa90gFQSwECPwAUAAAAAACBg5hK
AAAAAAAAAAAAAAAABAAkAAAAAAAAABAAAADfAQAAc3JjLwoAIAAAAAAAAQAYALaBnfkGvdIBtoGd
+Qa90gFr5Zz5Br3SAVBLAQI/ABQAAAAAAIGDmEoAAAAAAAAAAAAAAAAJACQAAAAAAAAAEAAAAAEC
AABzcmMvbWFpbi8KACAAAAAAAAEAGADNz535Br3SAc3PnfkGvdIBjDOd+Qa90gFQSwECPwAUAAAA
AADIiJhKAAAAAAAAAAAAAAAADgAkAAAAAAAAABAAAAAoAgAAc3JjL21haW4vamF2YS8KACAAAAAA
AAEAGABW8O1RDL3SAVbw7VEMvdIBilqd+Qa90gFQSwECPwAUAAAAAAA6hJhKAAAAAAAAAAAAAAAA
EQAkAAAAAAAAABAAAABUAgAAc3JjL21haW4vamF2YS9kZS8KACAAAAAAAAEAGAAxsyXKB73SATGz
JcoHvdIBeT4lyge90gFQSwECPwAUAAAAAADZiZhKAAAAAAAAAAAAAAAAFgAkAAAAAAAAABAAAACD
AgAAc3JjL21haW4vamF2YS9kZS90ZXN0LwoAIAAAAAAAAQAYABA0WIQNvdIBEDRYhA290gExsyXK
B73SAVBLAQI/ABQAAAAIAAGNmErreKRDQwMAAFMMAAAfACQAAAAAAAAAIAAAALcCAABzcmMvbWFp
bi9qYXZhL2RlL3Rlc3QvTWFpbi5qYXZhCgAgAAAAAAABABgAJhEaCRG90gHgOSfKB73SAeA5J8oH
vdIBUEsBAj8AFAAAAAAAh4yYSgAAAAAAAAAAAAAAABwAJAAAAAAAAAAQAAAANwYAAHNyYy9tYWlu
L2phdmEvZGUvdGVzdC9tb2RlbC8KACAAAAAAAAEAGABdD/KAEL3SAV0P8oAQvdIBum8egw290gFQ
SwECPwAUAAAACACljJhKFV59dVkBAADeAgAAJQAkAAAAAAAAACAAAABxBgAAc3JjL21haW4vamF2
YS9kZS90ZXN0L21vZGVsL1Rlc3QuamF2YQoAIAAAAAAAAQAYAAEiBKMQvdIBTUvqag290gFNS+pq
Db3SAVBLAQI/ABQAAAAAAMiImEoAAAAAAAAAAAAAAAAXACQAAAAAAAAAEAAAAA0IAABzcmMvbWFp
bi9qYXZhL01FVEEtSU5GLwoAIAAAAAAAAQAYAAlm7lEMvdIBCWbuUQy90gFW8O1RDL3SAVBLAQI/
ABQAAAAIAIeMmEokSdYaxQEAADYEAAAmACQAAAAAAAAAIAAAAEIIAABzcmMvbWFpbi9qYXZhL01F
VEEtSU5GL3BlcnNpc3RlbmNlLnhtbAoAIAAAAAAAAQAYAAjp+oAQvdIBCWbuUQy90gEJZu5RDL3S
AVBLAQI/ABQAAAAAAIGDmEoAAAAAAAAAAAAAAAATACQAAAAAAAAAEAAAAEsKAABzcmMvbWFpbi9y
ZXNvdXJjZXMvCgAgAAAAAAABABgAzc+d+Qa90gHNz535Br3SAc3PnfkGvdIBUEsBAj8AFAAAAAAA
gYOYSgAAAAAAAAAAAAAAAAkAJAAAAAAAAAAQAAAAfAoAAHNyYy90ZXN0LwoAIAAAAAAAAQAYAOL2
nfkGvdIB4vad+Qa90gG2gZ35Br3SAVBLAQI/ABQAAAAAANmJmEoAAAAAAAAAAAAAAAAOACQAAAAA
AAAAEAAAAKMKAABzcmMvdGVzdC9qYXZhLwoAIAAAAAAAAQAYACQ8S4QNvdIBJDxLhA290gHBqJ35
Br3SAVBLAQI/ABQAAAAAANmJmEoAAAAAAAAAAAAAAAARACQAAAAAAAAAEAAAAM8KAABzcmMvdGVz
dC9qYXZhL2RlLwoAIAAAAAAAAQAYAChjS4QNvdIBKGNLhA290gEkPEuEDb3SAVBLAQI/ABQAAAAA
ANmJmEoAAAAAAAAAAAAAAAAWACQAAAAAAAAAEAAAAP4KAABzcmMvdGVzdC9qYXZhL2RlL3Rlc3Qv
CgAgAAAAAAABABgAKGNLhA290gEoY0uEDb3SAShjS4QNvdIBUEsBAj8AFAAAAAAA2YmYSgAAAAAA
AAAAAAAAABwAJAAAAAAAAAAQAAAAMgsAAHNyYy90ZXN0L2phdmEvZGUvdGVzdC9tb2RlbC8KACAA
AAAAAAEAGAAoY0uEDb3SAShjS4QNvdIBKGNLhA290gFQSwECPwAUAAAAAACBg5hKAAAAAAAAAAAA
AAAAEwAkAAAAAAAAABAAAABsCwAAc3JjL3Rlc3QvcmVzb3VyY2VzLwoAIAAAAAAAAQAYAOL2nfkG
vdIB4vad+Qa90gHi9p35Br3SAVBLBQYAAAAAEgASACoHAACdCwAAAAA=
--001a1143e1c8e1d001054deba11e--