[jboss-user] [MQ] - Re: JMS error with SQLServer
I am having this same problem, intermittently, in JBOSS 4.2.3.GA, running on Windows 2003
Server, MS SQL Server 2005:
org.jboss.mq.SpyJMSException: Could not store message: 3682 msg=3669 hard NOT_STORED
PERSISTENT queue=QUEUE.VPSEmailQueue priority=4 lateClone=false hashCode=23743259; -
nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert
duplicate key row in object 'dbo.JMS_MESSAGES' with unique index
'JMS_MESSAGES_IDX'.)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1133)
at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:58)
at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:180)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:439)
at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:422)
at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:112)
at
org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:114)
at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:419)
at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:398)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key
row in object 'dbo.JMS_MESSAGES' with unique index 'JMS_MESSAGES_IDX'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1172)
at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1118)
... 10 more
We have had to turn on JMS queuing of our outbound emails until a resolution can be found.
We are dropping notification emails on the floor due to this JMS issue!
Please help!?
Thanks
John Hagewood
Manager of Software Development
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4260186#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...