Hi,

We are encountering a problem with the PersistenceManager when it is trying to delete messages. We are running with JBoss 3.2.1. Included are two stack traces, the first one showing the exception appearing in the JBoss logs, the second exception is the error being thrown by the message consumer. As you can see the message consumer is being shut down.

We have experienced other problems with the Persistence Manager as described in.

http://www.jboss.org/index.html?module=bb&op=viewtopic&t=48851

the solution for which is to upgrade to JBoss 3.2.3.

Does anyone know whether there is a known bug in 3.2.1 to do with the removal of messages that has been fixed in a subsequent release.

Note at the time of the error the system was not under heavy load.

- Kevin.

2004-04-28 21:40:48,428 ERROR [org.jboss.mq.il.uil2.SocketManager] Failed to handle: org.jboss.mq.il.uil2.msgs.AcknowledgementRequestMsg634813[msgType: m_acknowledge, msgID: 8156, error: null]
org.jboss.mq.SpyJMSException: Could not delete the message from the database: delete affected 0 rows
at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.java:919)
at org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:382)
at org.jboss.mq.server.JMSTopic.acknowledge(JMSTopic.java:264)
at org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:328)
at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:529)
at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:513)
at org.jboss.mq.server.JMSServerInterceptorSupport.acknowledge(JMSServerInterceptorSupport.java:197)
at org.jboss.mq.server.TracingInterceptor.acknowledge(TracingInterceptor.java:405)
at org.jboss.mq.server.JMSServerInvoker.acknowledge(JMSServerInvoker.java:199)
at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:81)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:355)
at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:377)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:732)
at java.lang.Thread.run(Thread.java:536)


[MessageListenerThread - GPRS] WARN org.jboss.util.NestedThrowable - Duplicate throwable nesting of same base type: class org.jboss.mq.SpyJMSException is assignable from: class org.jboss.mq.SpyJMSException
[MessageListenerThread - GPRS] WARN org.jboss.mq.SpyMessageConsumer - Message consumer closing due to error in listening thread.
org.jboss.mq.SpyJMSException: Cannot acknowlege a message; - nested throwable: (org.jboss.mq.SpyJMSException: Could not delete the message from the database: delete affected 0 rows)
at org.jboss.mq.Connection.send(Connection.java:907)
at org.jboss.mq.SpySession.doAcknowledge(SpySession.java:603)
at org.jboss.mq.SpyMessage.doAcknowledge(SpyMessage.java:544)
at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:567)
at java.lang.Thread.run(Thread.java:536)
Caused by: org.jboss.mq.SpyJMSException: Could not delete the message from the database: delete affected 0 rows
at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.java:919)
at org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:382)
at org.jboss.mq.server.JMSTopic.acknowledge(JMSTopic.java:264)
at org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:328)
at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:529)
at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:513)
at org.jboss.mq.server.JMSServerInterceptorSupport.acknowledge(JMSServerInterceptorSupport.java:197)
at org.jboss.mq.server.TracingInterceptor.acknowledge(TracingInterceptor.java:405)
at org.jboss.mq.server.JMSServerInvoker.acknowledge(JMSServerInvoker.java:199)
at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:81)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:355)
at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:377)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:732)
... 1 more