[jboss-user] [JBoss Messaging] - SQLException when flushing messages from server memory to sy

[oleznew]

Hi,
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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4038585#4038585

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4038585