5 Replies Latest reply on Aug 31, 2007 9:53 AM by jeremystone

    Jboss Messaging 1.4.0.CR1 and postgresql...

    boniek Jul 28, 2007 4:03 PM

      ... does not work for me.

      @WorkerThread#0[127.0.0.1:58493] 21:57:00,325 WARN [JDBCPersistenceManager] SQLException caught - assuming deadlock detected, try:1
      [junit] org.postgresql.util.PSQLException: ERROR: relation "jbm_msg_ref" does not exist
      [junit] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
      [junit] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
      [junit] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
      [junit] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
      [junit] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
      [junit] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
      [junit] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
      [junit] at org.jboss.messaging.core.impl.JDBCPersistenceManager.updateWithRetry(Unknown Source)
      [junit] at org.jboss.messaging.core.impl.JDBCPersistenceManager.updateWithRetry(Unknown Source)
      [junit] at org.jboss.messaging.core.impl.JDBCPersistenceManager.addReference(Unknown Source)
      [junit] at org.jboss.messaging.core.impl.ChannelSupport.handleInternal(Unknown Source)
      [junit] at org.jboss.messaging.core.impl.ChannelSupport.handle(Unknown Source)
      [junit] at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.routeInternal(Unknown Source)
      [junit] at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.route(Unknown Source)
      [junit] at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage(Unknown Source)
      [junit] at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send(Unknown Source)
      [junit] at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop(Unknown Source)
      [junit] at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_6145266547759487588.invokeNext(SessionAdvised$send_6145266547759487588.java)
      [junit] at org.jboss.jms.server.container.SecurityAspect.handleSend(Unknown Source)
      [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      [junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      [junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      [junit] at java.lang.reflect.Method.invoke(Method.java:585)
      [junit] at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:121)
      [junit] at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_6145266547759487588.invokeNext(SessionAdvised$send_6145266547759487588.java)
      [junit] at org.jboss.jms.server.container.ServerLogInterceptor.invoke(Unknown Source)
      [junit] at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_6145266547759487588.invokeNext(SessionAdvised$send_6145266547759487588.java)
      [junit] at org.jboss.jms.server.endpoint.advised.SessionAdvised.send(Unknown Source)
      [junit] at org.jboss.jms.wireformat.SessionSendRequest.serverInvoke(Unknown Source)
      [junit] at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(Unknown Source)
      [junit] at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:734)
      [junit] at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:560)
      [junit] at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:383)
      [junit] at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:165)

      • 1980 Views
      • Tags:
        • 1. Re: Jboss Messaging 1.4.0.CR1 and postgresql...
          timfox
          timfox Jul 29, 2007 10:01 AM (in response to boniek)

          This was covered in an earlier thread: http://www.jboss.com/index.html?module=bb&op=viewtopic&t=114049

            • Actions
          • 2. Re: Jboss Messaging 1.4.0.CR1 and postgresql...
            boniek Jul 29, 2007 12:21 PM (in response to boniek)

            Thanks.

              • Actions
            • 3. Re: Jboss Messaging 1.4.0.CR1 and postgresql...
              boniek Jul 29, 2007 2:11 PM (in response to boniek)

              I'm getting this when starting JBoss Messaging with mysql 5:

              20:03:05,175 WARN [JDBCPersistenceManager]

              JBoss Messaging Warning: DataSource connection transaction isolation should be READ_COMMITTED, but it is currently REPEATABLE_READ.
              Using an isolation level less strict than READ_COMMITTED may lead to data consistency problems.
              Using an isolation level more strict than READ_COMMITTED may lead to deadlock.


              And on shutdown:

              20:03:16,387 ERROR [ExceptionUtil] org.jboss.jms.server.connectionfactory.ConnectionFactory@1f34d0 startService
              java.lang.IllegalStateException: Cannot find replicant to remove: CF_jboss.messaging.connectionfactory:service=ConnectionFactory
              at org.jboss.jms.server.connectionfactory.ConnectionFactoryJNDIMapper.unregisterConnectionFactory(Unknown Source)
              at org.jboss.jms.server.connectionfactory.ConnectionFactory.stopService(Unknown Source)
              at org.jboss.system.ServiceMBeanSupport.jbossInternalStop(Unknown Source)
              at org.jboss.system.ServiceMBeanSupport.stop(Unknown Source)
              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(Unknown Source)
              at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
              at org.jboss.mx.interceptor.AbstractInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
              at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(Unknown Source)
              at $Proxy0.stop(Unknown Source)
              at org.jboss.system.ServiceController.stop(Unknown Source)
              at org.jboss.system.ServiceController.stop(Unknown Source)
              at org.jboss.system.ServiceController.stop(Unknown Source)
              at org.jboss.system.ServiceController.stop(Unknown Source)
              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(Unknown Source)
              at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
              at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
              at org.jboss.mx.util.MBeanProxyExt.invoke(Unknown Source)
              at $Proxy4.stop(Unknown Source)
              at org.jboss.deployment.SARDeployer.stop(Unknown Source)
              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(Unknown Source)
              at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
              at org.jboss.mx.interceptor.AbstractInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
              at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
              at org.jboss.mx.util.MBeanProxyExt.invoke(Unknown Source)
              at $Proxy51.stop(Unknown Source)
              at org.jboss.deployment.XSLSubDeployer.stop(Unknown Source)
              at org.jboss.deployment.MainDeployer.stop(Unknown Source)
              at org.jboss.deployment.MainDeployer.undeploy(Unknown Source)
              at org.jboss.deployment.MainDeployer.shutdown(Unknown Source)
              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(Unknown Source)
              at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
              at org.jboss.mx.interceptor.AbstractInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
              at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
              at org.jboss.system.server.ServerImpl$ShutdownHook.shutdownDeployments(Unknown Source)
              at org.jboss.system.server.ServerImpl$ShutdownHook.shutdown(Unknown Source)
              at org.jboss.system.server.ServerImpl$ShutdownHook.run(Unknown Source)
              20:03:16,389 WARN [ConnectionFactory] Stopping failed jboss.messaging.connectionfactory:service=ConnectionFactory
              java.lang.IllegalStateException: Cannot find replicant to remove: CF_jboss.messaging.connectionfactory:service=ConnectionFactory
              at org.jboss.jms.server.connectionfactory.ConnectionFactoryJNDIMapper.unregisterConnectionFactory(Unknown Source)
              at org.jboss.jms.server.connectionfactory.ConnectionFactory.stopService(Unknown Source)
              at org.jboss.system.ServiceMBeanSupport.jbossInternalStop(Unknown Source)
              at org.jboss.system.ServiceMBeanSupport.stop(Unknown Source)
              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(Unknown Source)
              at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
              at org.jboss.mx.interceptor.AbstractInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
              at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(Unknown Source)
              at $Proxy0.stop(Unknown Source)
              at org.jboss.system.ServiceController.stop(Unknown Source)
              at org.jboss.system.ServiceController.stop(Unknown Source)
              at org.jboss.system.ServiceController.stop(Unknown Source)
              at org.jboss.system.ServiceController.stop(Unknown Source)
              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(Unknown Source)
              at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
              at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
              at org.jboss.mx.util.MBeanProxyExt.invoke(Unknown Source)
              at $Proxy4.stop(Unknown Source)
              at org.jboss.deployment.SARDeployer.stop(Unknown Source)
              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(Unknown Source)
              at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
              at org.jboss.mx.interceptor.AbstractInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
              at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
              at org.jboss.mx.util.MBeanProxyExt.invoke(Unknown Source)
              at $Proxy51.stop(Unknown Source)
              at org.jboss.deployment.XSLSubDeployer.stop(Unknown Source)
              at org.jboss.deployment.MainDeployer.stop(Unknown Source)
              at org.jboss.deployment.MainDeployer.undeploy(Unknown Source)
              at org.jboss.deployment.MainDeployer.shutdown(Unknown Source)
              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(Unknown Source)
              at org.jboss.mx.server.Invocation.dispatch(Unknown Source)
              at org.jboss.mx.interceptor.AbstractInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(Unknown Source)
              at org.jboss.mx.server.Invocation.invoke(Unknown Source)
              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Unknown Source)
              at org.jboss.mx.server.MBeanServerImpl.invoke(Unknown Source)
              at org.jboss.system.server.ServerImpl$ShutdownHook.shutdownDeployments(Unknown Source)
              at org.jboss.system.server.ServerImpl$ShutdownHook.shutdown(Unknown Source)
              at org.jboss.system.server.ServerImpl$ShutdownHook.run(Unknown Source)
              20:03:16,399 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@5a9c5d undeployed
              20:03:16,427 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@aaf3d2 undeployed

                • Actions
              • 4. Re: Jboss Messaging 1.4.0.CR1 and postgresql...
                timfox
                timfox Jul 30, 2007 6:20 AM (in response to boniek)

                 

                "boniek" wrote:
                I'm getting this when starting JBoss Messaging with mysql 5:

                20:03:05,175 WARN [JDBCPersistenceManager]

                JBoss Messaging Warning: DataSource connection transaction isolation should be READ_COMMITTED, but it is currently REPEATABLE_READ.
                Using an isolation level less strict than READ_COMMITTED may lead to data consistency problems.
                Using an isolation level more strict than READ_COMMITTED may lead to deadlock.



                This is explained in the user guide


                  • Actions
                • 5. Re: Jboss Messaging 1.4.0.CR1 and postgresql...
                  jeremystone
                  jeremystone Aug 31, 2007 9:53 AM (in response to boniek)

                  We get the same exception on shutdown (using 1.4.0.CR2) but are using a data source (MySql) with READ_COMMITTED tx isolation - so we dont get the warning at startup. We're running as cluster but with single node.

                    • Actions