Failed to Deliver: java.lang.IllegalStateException: Unexpected pageOrd:

[Rajesh MadhanGopal]

Hi,

We have our application deployed on JBoss 5.1.1 and we use Mysql 5.1 for messaging persistance in JBoss (we recently moved from using the default Hypersonic DB to Mysql). We see the following exception every time we restart JBoss while we run a test.

Failed to deliver
java.lang.IllegalStateException: Unexpected pageOrd: -4618 expected: -4617
	at org.jboss.messaging.core.impl.JDBCPersistenceManager.getPagedReferenceInfos(JDBCPersistenceManager.java:990)
	at org.jboss.messaging.core.impl.PagingChannelSupport.loadPagedReferences(PagingChannelSupport.java:259)
	at org.jboss.messaging.core.impl.PagingChannelSupport.checkLoad(PagingChannelSupport.java:372)
	at org.jboss.messaging.core.impl.PagingChannelSupport.removeFirstInMemory(PagingChannelSupport.java:356)
	at org.jboss.messaging.core.impl.ChannelSupport.deliverInternal(ChannelSupport.java:736)
	at org.jboss.messaging.core.impl.MessagingQueue.deliverInternal(MessagingQueue.java:540)
	at org.jboss.messaging.core.impl.ChannelSupport.deliver(ChannelSupport.java:386)
	at org.jboss.jms.server.endpoint.ServerSessionEndpoint$2.run(ServerSessionEndpoint.java:1707)
	at org.jboss.messaging.util.OrderedExecutorFactory$ChildExecutor.run(OrderedExecutorFactory.java:104)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)

Can some one please help me figure out why this could occur? I can see that its related to the way the messages are persisted in the persistant store which is Mysql in this case, but dont understand why this occurs.

[Ifteqar Ahmed]

Hi,

Did you delete the data folder before restarting?.

Try Deleting the Data folder before restarting the server. This may contain messages related to Hypersonic DB

[Rajesh MadhanGopal]

I use Mysql and not hypersonic..do you still think Hypersonic causes this issue?