Continuum aborts when running Postgres under JBoss
--------------------------------------------------

                 Key: CONTINUUM-1181
                 URL: http://jira.codehaus.org/browse/CONTINUUM-1181
             Project: Continuum
          Issue Type: Bug
          Components: Database
    Affects Versions: 1.1
         Environment: MS Windows XP Pro SP2
postgres 8.1.4-1 with JDBC Driver postgresql-8.1-408.jdbc3
JBoss 4.0.5.GA


            Reporter: thierry lach


I'm trying to get Continuum to store its data in a postgres database while 
running under JBoss and I'm getting an exception.  It seems that someone is 
trying to change the transaction isolation during a transaction.

Excerpt from JBoss logs follows...

2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      - 
Starting Continuum.
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      -
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      -
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      - 
< Continuum 1.1-SNAPSHOT started! >
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      - 
-----------------------------------
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      -  
      \   ^__^
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      -  
       \  (oo)\_______
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      -  
          (__)\       )\/\
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      -  
              ||----w |
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      -  
              ||     ||
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      -
2007-02-21 12:56:02,613 [ScannerThread] INFO  Continuum                      -
2007-02-21 12:56:02,613 [ScannerThread] INFO  ContinuumInitializer:default   - 
Continuum initializer running ...
2007-02-21 12:56:02,644 [ScannerThread] WARN  LocalManagedConnectionFactory  - 
Error resetting transaction isolation
org.postgresql.util.PSQLException: Cannot change transaction isolation level in 
the middle of a transaction.
    at 
org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(AbstractJdbc2Connection.java:733)
    at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cleanup(BaseWrapperManagedConnection.java:189)
    at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java
 :320)
    at 
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.returnConnection(JBossManagedConnectionPool.java:620)
    at 
org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection
 (BaseConnectionManager2.java:363)
    at 
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:623)
    at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle 
(BaseWrapperManagedConnection.java:266)
    at 
org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:129)
    at 
org.jpox.store.rdbms.adapter.DatabaseAdapter.getConnection(DatabaseAdapter.java 
:928)
    at 
org.jpox.store.rdbms.RDBMSNonmanagedTransaction.begin(RDBMSNonmanagedTransaction.java:324)
    at 
org.codehaus.plexus.jdo.PlexusJdoUtils.getAllObjectsDetached(PlexusJdoUtils.java:356)
    at org.codehaus.plexus.jdo.PlexusJdoUtils.getAllObjectsDetached 
(PlexusJdoUtils.java:346)
    at 
org.apache.maven.continuum.store.JdoContinuumStore.getAllObjectsDetached(JdoContinuumStore.java:1302)
    at 
org.apache.maven.continuum.store.JdoContinuumStore.getAllObjectsDetached( 
JdoContinuumStore.java:1287)
    at 
org.apache.maven.continuum.store.JdoContinuumStore.getAllObjectsDetached(JdoContinuumStore.java:1282)
    at org.apache.maven.continuum.store.JdoContinuumStore.getAllObjectsDetached 
(JdoContinuumStore.java:1277)
    at 
org.apache.maven.continuum.store.JdoContinuumStore.getSystemConfiguration(JdoContinuumStore.java:1375)
    at 
org.apache.maven.continuum.initialization.DefaultContinuumInitializer.initialize
 (DefaultContinuumInitializer.java:90)
    at 
org.apache.maven.continuum.DefaultContinuum.start(DefaultContinuum.java:2281)
    at 
org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java
 :33)
    at 
org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:130)
    at 
org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java
 :143)
    at 
org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:133)
    at 
org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent
 (ClassicSingletonComponentManager.java:87)
    at 
org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:101)
    at 
org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java 
:313)
    at 
org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
    at 
org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java
 :54)
    at 
org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:928)
    at 
org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:876)
    at org.codehaus.plexus.DefaultPlexusContainer.construct 
(DefaultPlexusContainer.java:853)
    at 
org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
    at 
org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java 
:236)
    at 
org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
    at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
    at org.apache.catalina.core.StandardContext.start 
(StandardContext.java:4211)
    at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
    at org.apache.catalina.core.StandardHost.addChild (StandardHost.java:524)
    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:585)
    at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
    at org.jboss.mx.server.RawDynamicInvoker.invoke (RawDynamicInvoker.java:164)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    at org.apache.catalina.core.StandardContext.init(StandardContext.java:5052)
    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:585)
    at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
    at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
    at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
    at 
org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDeployer.java:297)
    at 
org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.java:103)
    at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:371)
    at org.jboss.web.WebModule.startModule(WebModule.java:83)
    at org.jboss.web.WebModule.startService(WebModule.java:61)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalStart 
(ServiceMBeanSupport.java:289)
    at 
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
    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:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke 
(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke 
(AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
    at $Proxy0.start(Unknown Source)
    at org.jboss.system.ServiceController.start(ServiceController.java:417)
    at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java
 :25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java :94)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
    at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java :659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
    at $Proxy38.start(Unknown Source)
    at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)
    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:585)
    at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    at org.jboss.mx.interceptor.AbstractInterceptor.invoke 
(AbstractInterceptor.java:133)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
    at 
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
    at 
org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
    at 
org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
    at org.jboss.ws.integration.jboss.DeployerInterceptor.start 
(DeployerInterceptor.java:92)
    at 
org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
    at 
org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java 
:95)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
    at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java :659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
    at $Proxy39.start(Unknown Source)
    at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
    at org.jboss.deployment.MainDeployer.start (MainDeployer.java:1015)
    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
    at sun.reflect.GeneratedMethodAccessor54.invoke (Unknown Source)
    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke 
(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    at 
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:88)
    at 
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke 
(AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
    at $Proxy8.deploy(Unknown Source)
    at 
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
    at 
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
    at 
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan 
(AbstractDeploymentScanner.java:263)
    at 
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)
    at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run 
(AbstractDeploymentScanner.java:225)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to