1 Reply Latest reply on Apr 19, 2007 3:17 AM by Tim Fox

    SQLException when flushing messages from server memory to sy

    Taudo Wenzel Newbie

      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