There are many messages in the jms tables to be delivered, that the other server is working on. When starting the 2nd one, the following shows up: 10:27:19,645 INFO [JmsActivation] Attempting to reconnect org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@f99e17(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@1482a37 destination=queue/AlertConditionQueue isTopic=false tx=true durable=false reconnect=10 provider=java:/DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=60000 useDLQ=true DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5) 10:27:19,659 INFO [JmsActivation] Reconnected with messaging provider. 10:27:19,662 WARN [JmsActivation] Failure in jms activation org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@f99e17(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@1482a37 destination=queue/AlertConditionQueue isTopic=false tx=true durable=false reconnect=10 provider=java:/DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=60000 useDLQ=true DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5) org.jboss.mq.SpyJMSException: Could not update the message in the database: update affected 0 rows at org.jboss.mq.pm.jdbc2.PersistenceManager.update(PersistenceManager.java:1331) at org.jboss.mq.server.BasicQueue.updateRedeliveryFlags(BasicQueue.java:1212) at org.jboss.mq.server.BasicQueue.receive(BasicQueue.java:720) at org.jboss.mq.server.JMSQueue.receive(JMSQueue.java:185) at org.jboss.mq.server.ClientConsumer.receive(ClientConsumer.java:242) at org.jboss.mq.server.JMSDestinationManager.receive(JMSDestinationManager.java:628) at org.jboss.mq.server.JMSServerInterceptorSupport.receive(JMSServerInterceptorSupport.java:141) at org.jboss.mq.security.ServerSecurityInterceptor.receive(ServerSecurityInterceptor.java:115) at org.jboss.mq.server.TracingInterceptor.receive(TracingInterceptor.java:450) at org.jboss.mq.server.JMSServerInvoker.receive(JMSServerInvoker.java:147) at org.jboss.mq.il.jvm.JVMServerIL.receive(JVMServerIL.java:141) at org.jboss.mq.Connection.receive(Connection.java:868) at org.jboss.mq.SpyConnectionConsumer.run(SpyConnectionConsumer.java:277) at java.lang.Thread.run(Thread.java:595)
Heiko, can we get some repro steps here?
I think this happened when I had an error on alert sending (bad condition in the plugin like non-existing smtp server) in HA. 1 Server was running, the other was down and the JMS queue filled up. Then the error condition was cleared up and the 1. Server was delivering messages. When the 2nd server started, this issue showed up. But then JBossMQ is no known to be the most reliable JMS provider. It may be the case that we are not using the HA singleton service for JMS and that the JMS providers on the two HA servers are both looking into the same database table(s) and thus fighting for the queue entries there.
Now HornetQ and lots of backend updates, likely not an issue