javax.transaction.RollbackException: javax.transaction.xa.XAException

Pentaho BI Platform Tracking | Mat Lowery | 7 years ago
  1. 0

    The JCR API provides a way to tell if a node is being referenced. See http://www.day.com/maven/jsr170/javadocs/jcr-1.0/javax/jcr/Node.html#getReferences() We could even use this value to find specifically what files are referring to the database connection. Note that the same referential integrity problem applies to database connections, slave servers, partition schemas, and cluster schemas. How to repro: * Connect to enterprise repository. * Create a transformation with a table output step. * Save the transformation. * Explore the repository and attempt to delete the database connection used in the table output step. Note the error dialog and stack trace: org.pentaho.di.core.exception.KettleException: Unable to delete database with name [test123] Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException at org.pentaho.di.repository.pur.PurRepository.deleteDatabaseMeta(PurRepository.java:966) at org.pentaho.di.ui.repository.repositoryexplorer.controllers.ConnectionsController.removeConnection(ConnectionsController.java:285) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119) at org.pentaho.ui.xul.swt.tags.SwtButton.access$300(SwtButton.java:31) at org.pentaho.ui.xul.swt.tags.SwtButton$2.mouseUp(SwtButton.java:88) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:300) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:256) at org.pentaho.di.ui.repository.repositoryexplorer.RepositoryExplorer.show(RepositoryExplorer.java:161) at org.pentaho.di.ui.spoon.Spoon.exploreRepository(Spoon.java:3348) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119) at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:24) at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:74) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1187) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6647) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:538) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:110) Caused by: javax.xml.ws.soap.SOAPFaultException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:189) at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:130) at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:119) at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89) at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:140) at $Proxy45.deleteFileWithPermanentFlag(Unknown Source) at com.pentaho.repository.pur.ws.UnifiedRepositoryToWebServiceAdapter.deleteFile(UnifiedRepositoryToWebServiceAdapter.java:52) at org.pentaho.di.repository.pur.PurRepository.deleteDatabaseMeta(PurRepository.java:964) ... 43 more Caused by: org.springframework.transaction.TransactionSystemException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:192) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy14.deleteFile(Unknown Source) at com.pentaho.repository.pur.ws.DefaultUnifiedRepositoryWebService.deleteFileWithPermanentFlag(DefaultUnifiedRepositoryWebService.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.sun.xml.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:246) at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146) at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257) at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95) at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:629) at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:588) at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:573) at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:470) at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:295) at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:515) at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:285) at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:143) at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:155) at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:189) at com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:76) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.RequestDumperValve.invoke(RequestDumperValve.java:151) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:101) at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:189) ... 72 more Caused by: javax.transaction.xa.XAException at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:171) at org.apache.jackrabbit.core.XASessionImpl.prepare(XASessionImpl.java:331) at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:91) ... 73 more Caused by: org.apache.jackrabbit.core.TransactionException: Unable to prepare transaction. at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:166) at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:154) ... 75 more Caused by: javax.jcr.ReferentialIntegrityException: ff87f7bb-1c44-4769-9519-ff38ba189e39: the node cannot be removed because it is still being referenced. at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.checkReferentialIntegrity(SharedItemStateManager.java:1013) at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:577) at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1085) at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:163) ... 76 more

    Pentaho BI Platform Tracking | 7 years ago | Mat Lowery
    javax.transaction.RollbackException: javax.transaction.xa.XAException
  2. 0

    The JCR API provides a way to tell if a node is being referenced. See http://www.day.com/maven/jsr170/javadocs/jcr-1.0/javax/jcr/Node.html#getReferences() We could even use this value to find specifically what files are referring to the database connection. Note that the same referential integrity problem applies to database connections, slave servers, partition schemas, and cluster schemas. How to repro: * Connect to enterprise repository. * Create a transformation with a table output step. * Save the transformation. * Explore the repository and attempt to delete the database connection used in the table output step. Note the error dialog and stack trace: org.pentaho.di.core.exception.KettleException: Unable to delete database with name [test123] Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException at org.pentaho.di.repository.pur.PurRepository.deleteDatabaseMeta(PurRepository.java:966) at org.pentaho.di.ui.repository.repositoryexplorer.controllers.ConnectionsController.removeConnection(ConnectionsController.java:285) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119) at org.pentaho.ui.xul.swt.tags.SwtButton.access$300(SwtButton.java:31) at org.pentaho.ui.xul.swt.tags.SwtButton$2.mouseUp(SwtButton.java:88) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:300) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:256) at org.pentaho.di.ui.repository.repositoryexplorer.RepositoryExplorer.show(RepositoryExplorer.java:161) at org.pentaho.di.ui.spoon.Spoon.exploreRepository(Spoon.java:3348) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119) at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:24) at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:74) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1187) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6647) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:538) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:110) Caused by: javax.xml.ws.soap.SOAPFaultException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:189) at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:130) at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:119) at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89) at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:140) at $Proxy45.deleteFileWithPermanentFlag(Unknown Source) at com.pentaho.repository.pur.ws.UnifiedRepositoryToWebServiceAdapter.deleteFile(UnifiedRepositoryToWebServiceAdapter.java:52) at org.pentaho.di.repository.pur.PurRepository.deleteDatabaseMeta(PurRepository.java:964) ... 43 more Caused by: org.springframework.transaction.TransactionSystemException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:192) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy14.deleteFile(Unknown Source) at com.pentaho.repository.pur.ws.DefaultUnifiedRepositoryWebService.deleteFileWithPermanentFlag(DefaultUnifiedRepositoryWebService.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.sun.xml.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:246) at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146) at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257) at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95) at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:629) at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:588) at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:573) at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:470) at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:295) at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:515) at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:285) at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:143) at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:155) at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:189) at com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:76) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.RequestDumperValve.invoke(RequestDumperValve.java:151) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:101) at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:189) ... 72 more Caused by: javax.transaction.xa.XAException at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:171) at org.apache.jackrabbit.core.XASessionImpl.prepare(XASessionImpl.java:331) at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:91) ... 73 more Caused by: org.apache.jackrabbit.core.TransactionException: Unable to prepare transaction. at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:166) at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:154) ... 75 more Caused by: javax.jcr.ReferentialIntegrityException: ff87f7bb-1c44-4769-9519-ff38ba189e39: the node cannot be removed because it is still being referenced. at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.checkReferentialIntegrity(SharedItemStateManager.java:1013) at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:577) at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1085) at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:163) ... 76 more

    Pentaho BI Platform Tracking | 7 years ago | Mat Lowery
    javax.transaction.RollbackException: javax.transaction.xa.XAException
  3. 0

    [BISERVER-8317] Error when trying to disable ability to schedule a report when the report is in a schedule - Pentaho BI Platform Tracking

    pentaho.com | 1 year ago
    org.springframework.transaction.TransactionSystemException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I'm seeing this sporadically, and turned up the logging to get the actual exception: org.apache.jackrabbit.core.state.NoSuchItemStateException: 8c0c0e78-6c90-4db6-82a3-feed4ca4ea90/{http://artifactory.jfrog.org/1.0}lastDownloadedBy Here's the full exception: {quote} 2012-11-01 18:42:36,360 [pool-1-thread-18] [DEBUG] (o.a.w.s.RepoFilter :206) - Sending HTTP error code 500: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException org.springframework.transaction.TransactionSystemException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:192) [se-jcr-0.9.jar:na] at org.artifactory.jcr.JcrTransactionManager.doCommit(JcrTransactionManager.java:76) [artifactory-jcr-storage-2.6.3.jar:na] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:121) [artifactory-jcr-storage-2.6.3.jar:na] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:49) [artifactory-jcr-storage-2.6.3.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at $Proxy51.uploadWithinTransaction(Unknown Source) [na:na] at org.artifactory.engine.UploadServiceImpl.adjustResponseAndUpload(UploadServiceImpl.java:222) [artifactory-core-2.6.3.jar:na] at org.artifactory.engine.UploadServiceImpl.validateRequestAndUpload(UploadServiceImpl.java:177) [artifactory-core-2.6.3.jar:na] at org.artifactory.engine.UploadServiceImpl.upload(UploadServiceImpl.java:138) [artifactory-core-2.6.3.jar:na] at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) [na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [na:1.6.0_26] at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_26] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at $Proxy51.upload(Unknown Source) [na:na] at org.artifactory.webapp.servlet.RepoFilter.doUpload(RepoFilter.java:203) [artifactory-web-application-2.6.3.jar:na] at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:145) [artifactory-web-application-2.6.3.jar:na] at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:84) [artifactory-web-application-2.6.3.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190) [jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:272) [artifactory-web-application-2.6.3.jar:na] at org.artifactory.webapp.servlet.AccessFilter.authenticateAndExecute(AccessFilter.java:193) [artifactory-web-application-2.6.3.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:175) [artifactory-web-application-2.6.3.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:143) [artifactory-web-application-2.6.3.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190) [jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:57) [artifactory-web-application-2.6.3.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190) [jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:72) [artifactory-web-application-2.6.3.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190) [jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:424) [jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:494) [jetty-security-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:931) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:361) [jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:245) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.Server.handle(Server.java:337) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:581) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1020) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:775) [jetty-http-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:228) [jetty-http-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:417) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:474) [jetty-io-7.0.2.v20100331.jar:7.0.2.v20100331] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] at org.eclipse.jetty.server.Server.handle(Server.java:337) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:581) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1020) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:775) [jetty-http-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:228) [jetty-http-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:417) [jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:474) [jetty-io-7.0.2.v20100331.jar:7.0.2.v20100331] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] Caused by: javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:101) [se-jcr-0.9.jar:na] at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:189) [se-jcr-0.9.jar:na] ... 54 common frames omitted Caused by: javax.transaction.xa.XAException: null at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:176) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.XASessionImpl.prepare(XASessionImpl.java:312) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:91) [se-jcr-0.9.jar:na] ... 55 common frames omitted Caused by: org.apache.jackrabbit.core.TransactionException: Unable to prepare transaction. at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:169) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:159) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] ... 57 common frames omitted Caused by: org.apache.jackrabbit.core.state.NoSuchItemStateException: 8c0c0e78-6c90-4db6-82a3-feed4ca4ea90/{http://artifactory.jfrog.org/1.0}lastDownloadedBy at org.apache.jackrabbit.core.state.SharedItemStateManager.getItemState(SharedItemStateManager.java:280) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:676) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1460) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:163) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] ... 58 common frames omitted {quote}

    JFrog JIRA | 4 years ago | Andrew Bayer
    org.springframework.transaction.TransactionSystemException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException
  6. 0

    l:207) - Datastore garbage collector deleted 0 unreferenced item(s). 2009-08-03 13:17:54,574 [pool-1-thread-1] [INFO ] (o.a.j.JcrServiceImpl:207) - Datastore garbage collector deleted 0 unreferenced item(s). 2009-08-03 13:27:54,574 [pool-1-thread-1] [INFO ] (o.a.j.JcrServiceImpl:207) - Datastore garbage collector deleted 0 unreferenced item(s). 2009-08-03 13:32:10,215 [pool-1-thread-1] [ERROR] (o.a.j.JcrTransactionManager:255) - Could not commit transaction: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException 2009-08-03 13:32:10,215 [pool-1-thread-1] [INFO ] (o.a.j.JcrTransactionManager:207) - status = org.springframework.transaction.support.DefaultTransactionStatus@4f02246c 2009-08-03 13:32:10,216 [pool-1-thread-1] [INFO ] (o.a.j.JcrTransactionManager:207) - txobj = org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager$JcrTransactionObject@15a556fa 2009-08-03 13:32:10,218 [pool-1-thread-1] [INFO ] (o.a.j.JcrTransactionManager:207) - sh = org.springframework.extensions.jcr.jackrabbit.support.UserTxSessionHolder@1a7a84a0 2009-08-03 13:32:10,218 [pool-1-thread-1] [INFO ] (o.a.j.JcrTransactionManager:207) - tx = org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction@619931f4 2009-08-03 13:32:10,224 [pool-1-thread-4] [ERROR] (o.a.j.JcrTransactionManager:255) - Could not commit transaction: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException 2009-08-03 13:32:10,225 [pool-1-thread-4] [INFO ] (o.a.j.JcrTransactionManager:207) - status = org.springframework.transaction.support.DefaultTransactionStatus@2e4263ee 2009-08-03 13:32:10,226 [pool-1-thread-4] [INFO ] (o.a.j.JcrTransactionManager:207) - txobj = org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager$JcrTransactionObject@64591dae 2009-08-03 13:32:10,227 [pool-1-thread-4] [INFO ] (o.a.j.JcrTransactionManager:207) - sh = org.springframework.extensions.jcr.jackrabbit.support.UserTxSessionHolder@32afe5ab 2009-08-03 13:32:10,227 [pool-1-thread-4] [INFO ] (o.a.j.JcrTransactionManager:207) - tx = org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction@3a0f578c 2009-08-03 13:32:10,251 [pool-1-thread-1] [ERROR] (o.a.s.a.AsyncAdvice :271) - Could not execute async method: 'public abstract void org.artifactory.api.security.SecurityService.updateUserLastLogin(java.lang.String,java.lang.String,long)'. org.springframework.transaction.TransactionSystemException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:192) [se-jcr-0.9.jar:na] at org.artifactory.jcr.JcrTransactionManager.doCommit(JcrTransactionManager.java:83) [artifactory-core-2.1.0-SNAPSHOT.jar:na] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) [spring-tx-2.5.6.jar:2.5.6] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) [spring-tx-2.5.6.jar:2.5.6] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) [spring-tx-2.5.6.jar:2.5.6] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) [spring-tx-2.5.6.jar:2.5.6] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:71) [artifactory-core-2.1.0-SNAPSHOT.jar:na] at org.artifactory.schedule.aop.AsyncAdvice$1.run(AsyncAdvice.java:119) [artifactory-core-2.1.0-SNAPSHOT.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [na:1.6.0_12] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [na:1.6.0_12] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [na:1.6.0_12] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_12] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_12] at java.lang.Thread.run(Thread.java:619) [na:1.6.0_12] Caused by: javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:101) [se-jcr-0.9.jar:na] at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:189) [se-jcr-0.9.jar:na] ... 13 common frames omitted Caused by: javax.transaction.xa.XAException: null at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:171) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.XASessionImpl.prepare(XASessionImpl.java:324) [jackrabbit-core-1.5.6.jar:na] at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:91) [se-jcr-0.9.jar:na] ... 14 common frames omitted Caused by: org.apache.jackrabbit.core.TransactionException: Unable to prepare transaction. at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:162) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:154) [jackrabbit-core-1.5.6.jar:na] ... 16 common frames omitted Caused by: org.apache.jackrabbit.core.state.NoSuchItemStateException: b015f993-56c0-4d29-9912-3ae584d51d1f/{}groups at org.apache.jackrabbit.core.state.SharedItemStateManager.getItemState(SharedItemStateManager.java:270) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:648) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1062) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:156) [jackrabbit-core-1.5.6.jar:na] ... 17 common frames omitted 2009-08-03 13:32:10,252 [pool-1-thread-4] [ERROR] (o.a.s.a.AsyncAdvice :271) - Could not execute async method: 'public abstract void org.artifactory.api.security.SecurityService.updateUserLastLogin(java.lang.String,java.lang.String,long)'. org.springframework.transaction.TransactionSystemException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:192) [se-jcr-0.9.jar:na] at org.artifactory.jcr.JcrTransactionManager.doCommit(JcrTransactionManager.java:83) [artifactory-core-2.1.0-SNAPSHOT.jar:na] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) [spring-tx-2.5.6.jar:2.5.6] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) [spring-tx-2.5.6.jar:2.5.6] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) [spring-tx-2.5.6.jar:2.5.6] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) [spring-tx-2.5.6.jar:2.5.6] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:71) [artifactory-core-2.1.0-SNAPSHOT.jar:na] at org.artifactory.schedule.aop.AsyncAdvice$1.run(AsyncAdvice.java:119) [artifactory-core-2.1.0-SNAPSHOT.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [na:1.6.0_12] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [na:1.6.0_12] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [na:1.6.0_12] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_12] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_12] at java.lang.Thread.run(Thread.java:619) [na:1.6.0_12] Caused by: javax.transaction.RollbackException: javax.transaction.xa.XAException at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:101) [se-jcr-0.9.jar:na] at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:189) [se-jcr-0.9.jar:na] ... 13 common frames omitted Caused by: javax.transaction.xa.XAException: null at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:171) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.XASessionImpl.prepare(XASessionImpl.java:324) [jackrabbit-core-1.5.6.jar:na] at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:91) [se-jcr-0.9.jar:na] ... 14 common frames omitted Caused by: org.apache.jackrabbit.core.TransactionException: Unable to prepare transaction. at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:162) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:154) [jackrabbit-core-1.5.6.jar:na] ... 16 common frames omitted Caused by: org.apache.jackrabbit.core.state.NoSuchItemStateException: b015f993-56c0-4d29-9912-3ae584d51d1f/{}groups at org.apache.jackrabbit.core.state.SharedItemStateManager.getItemState(SharedItemStateManager.java:270) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:648) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1062) [jackrabbit-core-1.5.6.jar:na] at org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:156) [jackrabbit-core-1.5.6.jar:na] ... 17 common frames omitted 2009-08-03 13:37:54,574 [pool-1-thread-4] [INFO ] (o.a.j.JcrServiceImpl:207) - Datastore garbage collector deleted 0 unreferenced item(s). 2009-08-03 13:43:36,989 [TP-Processor52] [INFO ] (o.a.r.HttpRepo :207) - repo1: Retrieving

    JFrog JIRA | 7 years ago | Tal Abramson
    org.springframework.transaction.TransactionSystemException: Could not commit JCR transaction; nested exception is javax.transaction.RollbackException: javax.transaction.xa.XAException

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. javax.jcr.ReferentialIntegrityException

      ff87f7bb-1c44-4769-9519-ff38ba189e39: the node cannot be removed because it is still being referenced.

      at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.checkReferentialIntegrity()
    2. Jackrabbit Core
      XASessionImpl.prepare
      1. org.apache.jackrabbit.core.state.SharedItemStateManager$Update.checkReferentialIntegrity(SharedItemStateManager.java:1013)
      2. org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:577)
      3. org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1085)
      4. org.apache.jackrabbit.core.state.XAItemStateManager.prepare(XAItemStateManager.java:163)
      5. org.apache.jackrabbit.core.TransactionContext.prepare(TransactionContext.java:154)
      6. org.apache.jackrabbit.core.XASessionImpl.prepare(XASessionImpl.java:331)
      6 frames
    3. org.springframework.extensions
      LocalTransactionManager.doCommit
      1. org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:91)
      2. org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:189)
      2 frames
    4. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
      2. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
      3. org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
      4. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
      4 frames
    5. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    6. Unknown
      $Proxy14.deleteFile
      1. $Proxy14.deleteFile(Unknown Source)
      1 frame
    7. com.pentaho.repository
      DefaultUnifiedRepositoryWebService.deleteFileWithPermanentFlag
      1. com.pentaho.repository.pur.ws.DefaultUnifiedRepositoryWebService.deleteFileWithPermanentFlag(DefaultUnifiedRepositoryWebService.java:77)
      1 frame
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    9. JAX-WS RI Runtime Bundle
      WSServlet.doPost
      1. com.sun.xml.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:246)
      2. com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
      3. com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
      4. com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
      5. com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:629)
      6. com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:588)
      7. com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:573)
      8. com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:470)
      9. com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:295)
      10. com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:515)
      11. com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:285)
      12. com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:143)
      13. com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:155)
      14. com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:189)
      15. com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:76)
      15 frames
    10. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      2 frames
    11. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    12. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
      1 frame
    13. org.springframework.security
      FilterSecurityInterceptor.doFilter
      1. org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
      2. org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
      2 frames
    14. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    15. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    16. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    17. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    18. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    19. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    20. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    21. Spring Security - Portlet support
      HttpSessionContextIntegrationFilter.doFilterHttp
      1. org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
      1 frame
    22. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      1 frame
    23. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    24. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    25. spring-security-core
      FilterToBeanProxy.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      2. org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
      3. org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
      3 frames
    26. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    27. com.pentaho.ui
      SystemStatusFilter.doFilter
      1. com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SystemStatusFilter.java:43)
      1 frame
    28. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    29. org.pentaho.platform
      SetCharacterEncodingFilter.doFilter
      1. org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
      1 frame
    30. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      9. org.apache.catalina.valves.RequestDumperValve.invoke(RequestDumperValve.java:151)
      10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
      10 frames
    31. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
      3 frames
    32. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame