org.jboss.mq.SpyJMSException: Could not store message

[htrivedi]

I have JBoss 3.2.5 installed and it use to send requests into JMS Queues, but from last couple of days it throws the following exception and after this we have to restart Jboss to make it work Following is the exception:

org.jboss.mq.SpyJMSException: Could not store message: 16965 msg=165 hard NOT_STORED PERSISTENT queue=QUEUE.CallSetQueue priority=4 lateClone=false hashCode=1034514; - nested throwable: (java.sql.SQLException: out of memory)

Can anyone please help us in this regard and let us know why this is happening.

Thanks
Himanshu

[genman]

Are you using HSQLDB? Probably something to look at would be replacing it with MySQL.

[htrivedi]

Yes. We are using HSQLDB. Can you tell us why this problem happens with HSQLDB, I mean if you know the cause please let us know as the application was working fine for almost 1 1/2 years.

Thanks.

[htrivedi]

We have resolved this issue by clearing up JMS_messages and JMS_transactions table in HSQLDB, by deleting the records in these table. We can delete the records by adding the delete statement in hsqldb-jdbc2-servcie.xml file and then starting the JBoss again. This will delete all the pending queues and messages and clear the DB, so that we can re-use it. Once we clear the DB, we need to remove the delete statements from the above file and restart JBoss again, so that it builds up again the transactions and messages in the queue.

I have posted the above solution so that if some one is facing the issue similar to us this will help them. Hope this will help someone facing similar problem.

Thanks.