SQLException when flushing messages from server memory to sy
oleznew Apr 18, 2007 2:40 PMHi,
I am getting a SQLException when the server (1.0.1 SP4) starts storing
messages from the server memory to the database (Sybase).
2007-04-18 19:56:13,286 WARN @Thread-15 [JDBCPersistenceManager] SQLException caught - assuming deadlock detected, try:25 org.jboss.util.NestedSQLException: Error; - nested throwable: (java.lang.NullPointerException) at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:557) at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:563) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:523) at org.jboss.messaging.core.plugin.JDBCPersistenceManager.updateWithRetry(JDBCPersistenceManager.java:4380) at org.jboss.messaging.core.plugin.JDBCPersistenceManager.updateWithRetryBatch(JDBCPersistenceManager.java:4361) at org.jboss.messaging.core.plugin.JDBCPersistenceManager.addReferences(JDBCPersistenceManager.java:924) at org.jboss.messaging.core.ChannelSupport.flushDownCache(ChannelSupport.java:1159) at org.jboss.messaging.core.ChannelSupport.addToDownCache(ChannelSupport.java:1115) at org.jboss.messaging.core.ChannelSupport.addReferenceInMemory(ChannelSupport.java:1063) at org.jboss.messaging.core.ChannelSupport.handleInternal(ChannelSupport.java:836) at org.jboss.messaging.core.ChannelSupport$HandleRunnable.run(ChannelSupport.java:1732) at EDU.oswego.cs.dl.util.concurrent.QueuedExecutor$RunLoop.run(QueuedExecutor.java:89) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.sybase.jdbc2.jdbc.SybStatement.batchToString(SybStatement.java:1251) at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeBatch(SybPreparedStatement.java:667) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeBatch(CachedPreparedStatement.java:478) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:519) ... 10 more 2007-04-18 19:56:13,286 ERROR @Thread-15 [JDBCPersistenceManager] Retried 25 times, now giving up 2007-04-18 19:56:13,291 ERROR @Thread-15 [ChannelSupport] Failed to handle message java.lang.IllegalStateException: Failed to update references at org.jboss.messaging.core.plugin.JDBCPersistenceManager.updateWithRetry(JDBCPersistenceManager.java:4400) at org.jboss.messaging.core.plugin.JDBCPersistenceManager.updateWithRetryBatch(JDBCPersistenceManager.java:4361) at org.jboss.messaging.core.plugin.JDBCPersistenceManager.addReferences(JDBCPersistenceManager.java:924) at org.jboss.messaging.core.ChannelSupport.flushDownCache(ChannelSupport.java:1159) at org.jboss.messaging.core.ChannelSupport.addToDownCache(ChannelSupport.java:1115) at org.jboss.messaging.core.ChannelSupport.addReferenceInMemory(ChannelSupport.java:1063) at org.jboss.messaging.core.ChannelSupport.handleInternal(ChannelSupport.java:836) at org.jboss.messaging.core.ChannelSupport$HandleRunnable.run(ChannelSupport.java:1732) at EDU.oswego.cs.dl.util.concurrent.QueuedExecutor$RunLoop.run(QueuedExecutor.java:89) at java.lang.Thread.run(Thread.java:595)
What is the cause for this?
Many thanks,
oleznew