[jboss-user] [JBoss Messaging] - SQLException when flushing messages from server memory to sy
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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...