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

    Jboss Messaging 1.4.0.CR1 and postgresql...

    asddsa dsasd Newbie

      ... 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)

        • 3. Re: Jboss Messaging 1.4.0.CR1 and postgresql...
          asddsa dsasd Newbie

          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

          • 4. Re: Jboss Messaging 1.4.0.CR1 and postgresql...
            Tim Fox Master

             

            "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


            • 5. Re: Jboss Messaging 1.4.0.CR1 and postgresql...
              Jeremy Stone Newbie

              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.