MySQL- Data load problem -javax.transaction.RollbackException Can't commit
because the transaction is in aborted state
----------------------------------------------------------------------------------------------------------------------
Key: NXP-3937
URL: http://jira.nuxeo.org/browse/NXP-3937
Project: Nuxeo Enterprise Platform
Issue Type: Problem
Components: Core
Affects Versions: 5.2 GA
Environment: Nuxeo 5.2, MySql 5.0.8
Here is the info in datasource (default-repository-ds.xml)
<jndi-name>NXRepository/default</jndi-name>
<xa-transaction/>
<track-connection-by-tx/>
<adapter-display-name>Nuxeo SQL Repository DataSource</adapter-display-name>
<rar-name>nuxeo.ear#nuxeo-core-storage-sql-ra-1.5.0-RC1.rar</rar-name> -->
<connection-definition>org.nuxeo.ecm.core.storage.sql.Repository</connection-definition>
<config-property name="name">default</config-property>
<config-property name="xaDataSource"
type="java.lang.String">com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</config-property>
<config-property name="property"
type="java.lang.String">ServerName=127.0.0.1</config-property>
<config-property name="property"
type="java.lang.String">PortNumber/Integer=3306</config-property>
<config-property name="property"
type="java.lang.String">DatabaseName=MySql</config-property>
<config-property name="property"
type="java.lang.String">User=root</config-property>
<config-property name="property"
type="java.lang.String">Password=test1234</config-property>
<max-pool-size>20</max-pool-size>
and in unified-nuxeo-ds.xml
<local-tx-datasource>
<jndi-name>NuxeoDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/MySql</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>test1234</password>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
Reporter: Radha Kota
Assignee: Thierry Delprat
Priority: Blocker
We can load data into Derby and Postgres, but with MySql getting this exception
after loading bunch of documents
javax.script.ScriptException: java.lang.RuntimeException:
javax.transaction.RollbackException:
[com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted]
[com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted]
Can't commit because the transaction is in aborted state
at com.sun.script.groovy.GroovyScriptEngine.eval(GroovyScriptEngine.java
:245)
at com.sun.script.groovy.GroovyCompiledScript.eval(GroovyCompiledScript.
java:46)
at javax.script.CompiledScript.eval(CompiledScript.java:75)
at org.nuxeo.ecm.shell.commands.scripting.ScriptingCommand.run(Scripting
Command.java:61)
at org.nuxeo.ecm.shell.CommandLineService.runCommand(CommandLineService.
java:329)
at org.nuxeo.ecm.shell.commands.InteractiveCommand.runCommand(Interactiv
eCommand.java:132)
at org.nuxeo.ecm.shell.commands.InteractiveCommand.processInput(Interact
iveCommand.java:116)
at org.nuxeo.ecm.shell.commands.InteractiveCommand.run(InteractiveComman
d.java:96)
at org.nuxeo.ecm.shell.CommandLineService.runCommand(CommandLineService.
java:329)
at org.nuxeo.ecm.shell.Main.main(Main.java:101)
at org.nuxeo.ecm.shell.CommandLineService$1.run(CommandLineService.java:
357)
at org.nuxeo.osgi.application.StandaloneApplication.main(StandaloneAppli
cation.java:300)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.nuxeo.osgi.application.Main.main(Main.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.nuxeo.runtime.launcher.Main.main(Main.java:83)
Caused by: java.lang.RuntimeException: javax.transaction.RollbackException: [com
.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.a
ts.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because t
he transaction is in aborted state
at org.jboss.aspects.tx.TxPolicy.handleEndTransactionException(TxPolicy.
java:198)
at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:180)
at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java
:191)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInt
erceptor.java:95)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(Stateles
sInstanceInterceptor.java:62)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.aspects.security.AuthenticationInterceptor.invoke(Authentic
ationInterceptor.java:77)
at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3Auth
enticationInterceptor.java:110)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterce
ptor.java:46)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(Asynchrono
usInterceptor.java:106)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessCo
ntainer.java:304)
at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)
at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRem
otingInvocationHandler.java:82)
at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:809)
at org.jboss.remoting.transport.socket.ServerThread.processInvocation(Se
rverThread.java:608)
at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.j
ava:406)
at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.jav
a:173)
Caused by: javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.tra
nsaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.
arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted
state
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.c
ommitAndDisassociate(TransactionImple.java:1401)
at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.co
mmit(BaseTransaction.java:135)
at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTra
nsactionManagerDelegate.java:87)
at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175)
at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java
:191)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInt
erceptor.java:95)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(Stateles
sInstanceInterceptor.java:62)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.aspects.security.AuthenticationInterceptor.invoke(Authentic
ationInterceptor.java:77)
at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3Auth
enticationInterceptor.java:110)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterce
ptor.java:46)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(Asynchrono
usInterceptor.java:106)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessCo
ntainer.java:304)
at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)
at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRem
otingInvocationHandler.java:82)
at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:809)
at org.jboss.remoting.transport.socket.ServerThread.processInvocation(Se
rverThread.java:608)
at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.j
ava:406)
at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.jav
a:173)
at org.jboss.remoting.MicroRemoteClientInvoker.invoke(MicroRemoteClientI
nvoker.java:163)
at org.jboss.remoting.Client.invoke(Client.java:1634)
at org.jboss.remoting.Client.invoke(Client.java:548)
at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemot
eInterceptor.java:62)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(ClientTxPr
opagationInterceptor.java:67)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.aspects.security.SecurityClientInterceptor.invoke(SecurityC
lientInterceptor.java:53)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.
java:74)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteP
roxy.java:107)
at $Proxy17.createAssetFromXMlBlob(Unknown Source)
at com.gale.grzimek.documentloader.loader.impl.DocumentLoaderImpl.loadDo
cument(DocumentLoaderImpl.java:37)
at com.gale.grzimek.documentloader.loader.impl.DocumentLoaderImpl.loadDo
cument(DocumentLoaderImpl.java:32)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.getNuxeoIdF
orResource(GrzimekPageCreationServiceImpl.java:233)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.getFilePath
AndNuxeoIdMapForResources(GrzimekPageCreationServiceImpl.java:225)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.generatePag
eDocumentContents(GrzimekPageCreationServiceImpl.java:211)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.getPageDocu
mentNuxeoId(GrzimekPageCreationServiceImpl.java:198)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.createEssay
Page(GrzimekPageCreationServiceImpl.java:166)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.createEssay
Pages(GrzimekPageCreationServiceImpl.java:158)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.handleEssay
Pages(GrzimekPageCreationServiceImpl.java:139)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.createPages
(GrzimekPageCreationServiceImpl.java:117)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:
95)
at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassH
elper.java:599)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:904)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:740)
at org.codehaus.groovy.runtime.InvokerHelper.invokePojoMethod(InvokerHel
per.java:761)
at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.
java:749)
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(Scrip
tBytecodeAdapter.java:167)
at Script1.run(Script1.groovy:52)
at com.sun.script.groovy.GroovyScriptEngine.eval(GroovyScriptEngine.java
:243)
at com.sun.script.groovy.GroovyCompiledScript.eval(GroovyCompiledScript.
java:46)
at javax.script.CompiledScript.eval(CompiledScript.java:75)
at org.nuxeo.ecm.shell.commands.scripting.ScriptingCommand.run(Scripting
Command.java:61)
at org.nuxeo.ecm.shell.CommandLineService.runCommand(CommandLineService.
java:329)
at org.nuxeo.ecm.shell.commands.InteractiveCommand.runCommand(Interactiv
eCommand.java:132)
at org.nuxeo.ecm.shell.commands.InteractiveCommand.processInput(Interact
iveCommand.java:116)
at org.nuxeo.ecm.shell.commands.InteractiveCommand.run(InteractiveComman
d.java:96)
at org.nuxeo.ecm.shell.CommandLineService.runCommand(CommandLineService.
java:329)
at org.nuxeo.ecm.shell.Main.main(Main.java:101)
at org.nuxeo.ecm.shell.CommandLineService$1.run(CommandLineService.java:
357)
at org.nuxeo.osgi.application.StandaloneApplication.main(StandaloneAppli
cation.java:300)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.nuxeo.osgi.application.Main.main(Main.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.nuxeo.runtime.launcher.Main.main(Main.java:83)
at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemot
eInterceptor.java:74)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(ClientTxPr
opagationInterceptor.java:67)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.aspects.security.SecurityClientInterceptor.invoke(SecurityC
lientInterceptor.java:53)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.
java:74)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
java:101)
at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteP
roxy.java:107)
at $Proxy17.createAssetFromXMlBlob(Unknown Source)
at com.gale.grzimek.documentloader.loader.impl.DocumentLoaderImpl.loadDo
cument(DocumentLoaderImpl.java:37)
at com.gale.grzimek.documentloader.loader.impl.DocumentLoaderImpl.loadDo
cument(DocumentLoaderImpl.java:32)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.getNuxeoIdF
orResource(GrzimekPageCreationServiceImpl.java:233)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.getFilePath
AndNuxeoIdMapForResources(GrzimekPageCreationServiceImpl.java:225)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.generatePag
eDocumentContents(GrzimekPageCreationServiceImpl.java:211)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.getPageDocu
mentNuxeoId(GrzimekPageCreationServiceImpl.java:198)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.createEssay
Page(GrzimekPageCreationServiceImpl.java:166)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.createEssay
Pages(GrzimekPageCreationServiceImpl.java:158)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.handleEssay
Pages(GrzimekPageCreationServiceImpl.java:139)
at com.gale.grzimek.page.impl.GrzimekPageCreationServiceImpl.createPages
(GrzimekPageCreationServiceImpl.java:117)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:
95)
at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassH
elper.java:599)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:904)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:740)
at org.codehaus.groovy.runtime.InvokerHelper.invokePojoMethod(InvokerHel
per.java:761)
at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.
java:749)
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(Scrip
tBytecodeAdapter.java:167)
at Script1.run(Script1.groovy:52)
at com.sun.script.groovy.GroovyScriptEngine.eval(GroovyScriptEngine.java
:243)
at com.sun.script.groovy.GroovyCompiledScript.eval(GroovyCompiledScript.
java:46)
at javax.script.CompiledScript.eval(CompiledScript.java:75)
at org.nuxeo.ecm.shell.commands.scripting.ScriptingCommand.run(Scripting
Command.java:61)
at org.nuxeo.ecm.shell.CommandLineService.runCommand(CommandLineService.
java:329)
at org.nuxeo.ecm.shell.commands.InteractiveCommand.runCommand(Interactiv
eCommand.java:132)
at org.nuxeo.ecm.shell.commands.InteractiveCommand.processInput(Interact
iveCommand.java:116)
at org.nuxeo.ecm.shell.commands.InteractiveCommand.run(InteractiveComman
d.java:96)
at org.nuxeo.ecm.shell.CommandLineService.runCommand(CommandLineService.
java:329)
at org.nuxeo.ecm.shell.Main.main(Main.java:101)
at org.nuxeo.ecm.shell.CommandLineService$1.run(CommandLineService.java:
357)
at org.nuxeo.osgi.application.StandaloneApplication.main(StandaloneAppli
cation.java:300)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.nuxeo.osgi.application.Main.main(Main.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.nuxeo.runtime.launcher.Main.main(Main.java:83)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
