Bug 1011016 - Cannot use DB2 as jdbc cache store
Summary: Cannot use DB2 as jdbc cache store
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: Clustering
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
: EAP 6.2.0
Assignee: Paul Ferraro
QA Contact: Jitka Kozana
Russell Dickenson
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-09-23 13:34 UTC by Jitka Kozana
Modified: 2013-12-15 13:32 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-09-26 14:02:30 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Description Jitka Kozana 2013-09-23 13:34:06 UTC 
EAP 6.2.0.ER2. This error is logged after server startup if jdbc-cache store uses DB2:

[JBossINF] [0m[31m09:05:57,956 ERROR [org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore] (ContainerBackgroundProcessor[StandardEngine[jboss.web]]) ISPN008013: Sql failure while updating bucket: Bucket{entries={}, bucketId='706882560'}: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22003, SQLERRMC=null, DRIVER=4.13.127
[JBossINF] 	at com.ibm.db2.jcc.am.id.a(id.java:669)
[JBossINF] 	at com.ibm.db2.jcc.am.id.a(id.java:60)
[JBossINF] 	at com.ibm.db2.jcc.am.id.a(id.java:127)
[JBossINF] 	at com.ibm.db2.jcc.am.no.b(no.java:2310)
[JBossINF] 	at com.ibm.db2.jcc.am.no.c(no.java:2293)
[JBossINF] 	at com.ibm.db2.jcc.t4.cb.l(cb.java:370)
[JBossINF] 	at com.ibm.db2.jcc.t4.cb.a(cb.java:62)
[JBossINF] 	at com.ibm.db2.jcc.t4.q.a(q.java:50)
[JBossINF] 	at com.ibm.db2.jcc.t4.tb.b(tb.java:220)
[JBossINF] 	at com.ibm.db2.jcc.am.oo.oc(oo.java:3428)
[JBossINF] 	at com.ibm.db2.jcc.am.oo.b(oo.java:4383)
[JBossINF] 	at com.ibm.db2.jcc.am.oo.gc(oo.java:784)
[JBossINF] 	at com.ibm.db2.jcc.am.oo.executeUpdate(oo.java:763)
[JBossINF] 	at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:115)
[JBossINF] 	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
[JBossINF] 	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.updateBucket(JdbcBinaryCacheStore.java:248)
[JBossINF] 	at org.infinispan.loaders.bucket.BucketBasedCacheStore.removeLockSafe(BucketBasedCacheStore.java:112)
[JBossINF] 	at org.infinispan.loaders.bucket.BucketBasedCacheStore.removeLockSafe(BucketBasedCacheStore.java:49)
[JBossINF] 	at org.infinispan.loaders.LockSupportCacheStore.remove(LockSupportCacheStore.java:230)
[JBossINF] 	at org.infinispan.loaders.AbstractCacheStore.applyModifications(AbstractCacheStore.java:133)
[JBossINF] 	at org.infinispan.loaders.AbstractCacheStore.commit(AbstractCacheStore.java:163)
[JBossINF] 	at org.infinispan.interceptors.CacheStoreInterceptor.commitCommand(CacheStoreInterceptor.java:161)
[JBossINF] 	at org.infinispan.interceptors.CacheStoreInterceptor.visitCommitCommand(CacheStoreInterceptor.java:143)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:134)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.EntryWrappingInterceptor.visitCommitCommand(EntryWrappingInterceptor.java:116)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:134)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.interceptors.locking.AbstractTxLockingInterceptor.visitCommitCommand(AbstractTxLockingInterceptor.java:101)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.NotificationInterceptor.visitCommitCommand(NotificationInterceptor.java:65)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.TxInterceptor.visitCommitCommand(TxInterceptor.java:153)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:134)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.statetransfer.TransactionSynchronizerInterceptor.visitCommitCommand(TransactionSynchronizerInterceptor.java:73)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.statetransfer.StateTransferInterceptor.handleTopologyAffectedCommand(StateTransferInterceptor.java:216)
[JBossINF] 	at org.infinispan.statetransfer.StateTransferInterceptor.handleTxCommand(StateTransferInterceptor.java:189)
[JBossINF] 	at org.infinispan.statetransfer.StateTransferInterceptor.visitCommitCommand(StateTransferInterceptor.java:121)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:134)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.InvocationContextInterceptor.handleAll(InvocationContextInterceptor.java:128)
[JBossINF] 	at org.infinispan.interceptors.InvocationContextInterceptor.handleDefault(InvocationContextInterceptor.java:92)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.BatchingInterceptor.handleDefault(BatchingInterceptor.java:92)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.InterceptorChain.invoke(InterceptorChain.java:343)
[JBossINF] 	at org.infinispan.transaction.TransactionCoordinator.commit(TransactionCoordinator.java:182)
[JBossINF] 	at org.infinispan.transaction.synchronization.SynchronizationAdapter.afterCompletion(SynchronizationAdapter.java:81)
[JBossINF] 	at org.infinispan.transaction.tm.DummyTransaction.notifyAfterCompletion(DummyTransaction.java:285)
[JBossINF] 	at org.infinispan.transaction.tm.DummyTransaction.runCommitTx(DummyTransaction.java:334)
[JBossINF] 	at org.infinispan.transaction.tm.DummyTransaction.commit(DummyTransaction.java:91)
[JBossINF] 	at org.infinispan.transaction.tm.DummyBaseTransactionManager.commit(DummyBaseTransactionManager.java:102)
[JBossINF] 	at org.infinispan.batch.BatchContainer.resolveTransaction(BatchContainer.java:123)
[JBossINF] 	at org.infinispan.batch.BatchContainer.endBatch(BatchContainer.java:105)
[JBossINF] 	at org.infinispan.batch.BatchContainer.endBatch(BatchContainer.java:86)
[JBossINF] 	at org.infinispan.CacheImpl.endBatch(CacheImpl.java:684)
[JBossINF] 	at org.infinispan.AbstractDelegatingCache.endBatch(AbstractDelegatingCache.java:80)
[JBossINF] 	at org.infinispan.AbstractDelegatingCache.endBatch(AbstractDelegatingCache.java:80)
[JBossINF] 	at org.jboss.as.clustering.infinispan.invoker.BatchCacheInvoker.invoke(BatchCacheInvoker.java:53)
[JBossINF] 	at org.jboss.as.clustering.infinispan.invoker.RetryingCacheInvoker.invoke(RetryingCacheInvoker.java:81)
[JBossINF] 	at org.jboss.as.clustering.web.infinispan.DistributedCacheManager$ForceSynchronousCacheInvoker.invoke(DistributedCacheManager.java:550)
[JBossINF] 	at org.jboss.as.clustering.web.infinispan.DistributedCacheManager.removeSession(DistributedCacheManager.java:281)
[JBossINF] 	at org.jboss.as.clustering.web.infinispan.DistributedCacheManager.removeSessionLocal(DistributedCacheManager.java:294)
[JBossINF] 	at org.jboss.as.web.session.DistributableSessionManager.processExpirationPassivation(DistributableSessionManager.java:1294) [jboss-as-web-7.3.0.Final-redhat-1.jar:7.3.0.Final-redhat-1]
[JBossINF] 	at org.jboss.as.web.session.AbstractSessionManager.processExpires(AbstractSessionManager.java:137) [jboss-as-web-7.3.0.Final-redhat-1.jar:7.3.0.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.session.ManagerBase.backgroundProcess(ManagerBase.java:367) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1302) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1588) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1600) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1600) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1574) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_40]
[JBossINF] 
[JBossINF] [0m[31m09:05:57,974 ERROR [org.infinispan.interceptors.InvocationContextInterceptor] (ContainerBackgroundProcessor[StandardEngine[jboss.web]]) ISPN000136: Execution error: org.infinispan.loaders.CacheLoaderException: Sql failure while updating bucket: Bucket{entries={}, bucketId='706882560'}
[JBossINF] 	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.updateBucket(JdbcBinaryCacheStore.java:254)
[JBossINF] 	at org.infinispan.loaders.bucket.BucketBasedCacheStore.removeLockSafe(BucketBasedCacheStore.java:112)
[JBossINF] 	at org.infinispan.loaders.bucket.BucketBasedCacheStore.removeLockSafe(BucketBasedCacheStore.java:49)
[JBossINF] 	at org.infinispan.loaders.LockSupportCacheStore.remove(LockSupportCacheStore.java:230)
[JBossINF] 	at org.infinispan.loaders.AbstractCacheStore.applyModifications(AbstractCacheStore.java:133)
[JBossINF] 	at org.infinispan.loaders.AbstractCacheStore.commit(AbstractCacheStore.java:163)
[JBossINF] 	at org.infinispan.interceptors.CacheStoreInterceptor.commitCommand(CacheStoreInterceptor.java:161)
[JBossINF] 	at org.infinispan.interceptors.CacheStoreInterceptor.visitCommitCommand(CacheStoreInterceptor.java:143)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:134)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.EntryWrappingInterceptor.visitCommitCommand(EntryWrappingInterceptor.java:116)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:134)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.interceptors.locking.AbstractTxLockingInterceptor.visitCommitCommand(AbstractTxLockingInterceptor.java:101)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.NotificationInterceptor.visitCommitCommand(NotificationInterceptor.java:65)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.TxInterceptor.visitCommitCommand(TxInterceptor.java:153)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:134)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.statetransfer.TransactionSynchronizerInterceptor.visitCommitCommand(TransactionSynchronizerInterceptor.java:73)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.statetransfer.StateTransferInterceptor.handleTopologyAffectedCommand(StateTransferInterceptor.java:216)
[JBossINF] 	at org.infinispan.statetransfer.StateTransferInterceptor.handleTxCommand(StateTransferInterceptor.java:189)
[JBossINF] 	at org.infinispan.statetransfer.StateTransferInterceptor.visitCommitCommand(StateTransferInterceptor.java:121)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:134)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.InvocationContextInterceptor.handleAll(InvocationContextInterceptor.java:128)
[JBossINF] 	at org.infinispan.interceptors.InvocationContextInterceptor.handleDefault(InvocationContextInterceptor.java:92)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)
[JBossINF] 	at org.infinispan.interceptors.BatchingInterceptor.handleDefault(BatchingInterceptor.java:92)
[JBossINF] 	at org.infinispan.commands.AbstractVisitor.visitCommitCommand(AbstractVisitor.java:136)
[JBossINF] 	at org.infinispan.commands.tx.CommitCommand.acceptVisitor(CommitCommand.java:60)
[JBossINF] 	at org.infinispan.interceptors.InterceptorChain.invoke(InterceptorChain.java:343)
[JBossINF] 	at org.infinispan.transaction.TransactionCoordinator.commit(TransactionCoordinator.java:182)
[JBossINF] 	at org.infinispan.transaction.synchronization.SynchronizationAdapter.afterCompletion(SynchronizationAdapter.java:81)
[JBossINF] 	at org.infinispan.transaction.tm.DummyTransaction.notifyAfterCompletion(DummyTransaction.java:285)
[JBossINF] 	at org.infinispan.transaction.tm.DummyTransaction.runCommitTx(DummyTransaction.java:334)
[JBossINF] 	at org.infinispan.transaction.tm.DummyTransaction.commit(DummyTransaction.java:91)
[JBossINF] 	at org.infinispan.transaction.tm.DummyBaseTransactionManager.commit(DummyBaseTransactionManager.java:102)
[JBossINF] 	at org.infinispan.batch.BatchContainer.resolveTransaction(BatchContainer.java:123)
[JBossINF] 	at org.infinispan.batch.BatchContainer.endBatch(BatchContainer.java:105)
[JBossINF] 	at org.infinispan.batch.BatchContainer.endBatch(BatchContainer.java:86)
[JBossINF] 	at org.infinispan.CacheImpl.endBatch(CacheImpl.java:684)
[JBossINF] 	at org.infinispan.AbstractDelegatingCache.endBatch(AbstractDelegatingCache.java:80)
[JBossINF] 	at org.infinispan.AbstractDelegatingCache.endBatch(AbstractDelegatingCache.java:80)
[JBossINF] 	at org.jboss.as.clustering.infinispan.invoker.BatchCacheInvoker.invoke(BatchCacheInvoker.java:53)
[JBossINF] 	at org.jboss.as.clustering.infinispan.invoker.RetryingCacheInvoker.invoke(RetryingCacheInvoker.java:81)
[JBossINF] 	at org.jboss.as.clustering.web.infinispan.DistributedCacheManager$ForceSynchronousCacheInvoker.invoke(DistributedCacheManager.java:550)
[JBossINF] 	at org.jboss.as.clustering.web.infinispan.DistributedCacheManager.removeSession(DistributedCacheManager.java:281)
[JBossINF] 	at org.jboss.as.clustering.web.infinispan.DistributedCacheManager.removeSessionLocal(DistributedCacheManager.java:294)
[JBossINF] 	at org.jboss.as.web.session.DistributableSessionManager.processExpirationPassivation(DistributableSessionManager.java:1294) [jboss-as-web-7.3.0.Final-redhat-1.jar:7.3.0.Final-redhat-1]
[JBossINF] 	at org.jboss.as.web.session.AbstractSessionManager.processExpires(AbstractSessionManager.java:137) [jboss-as-web-7.3.0.Final-redhat-1.jar:7.3.0.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.session.ManagerBase.backgroundProcess(ManagerBase.java:367) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1302) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1588) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1600) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1600) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1574) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
[JBossINF] 	at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_40]
[JBossINF] Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22003, SQLERRMC=null, DRIVER=4.13.127
[JBossINF] 	at com.ibm.db2.jcc.am.id.a(id.java:669)
[JBossINF] 	at com.ibm.db2.jcc.am.id.a(id.java:60)
[JBossINF] 	at com.ibm.db2.jcc.am.id.a(id.java:127)
[JBossINF] 	at com.ibm.db2.jcc.am.no.b(no.java:2310)
[JBossINF] 	at com.ibm.db2.jcc.am.no.c(no.java:2293)
[JBossINF] 	at com.ibm.db2.jcc.t4.cb.l(cb.java:370)
[JBossINF] 	at com.ibm.db2.jcc.t4.cb.a(cb.java:62)
[JBossINF] 	at com.ibm.db2.jcc.t4.q.a(q.java:50)
[JBossINF] 	at com.ibm.db2.jcc.t4.tb.b(tb.java:220)
[JBossINF] 	at com.ibm.db2.jcc.am.oo.oc(oo.java:3428)
[JBossINF] 	at com.ibm.db2.jcc.am.oo.b(oo.java:4383)
[JBossINF] 	at com.ibm.db2.jcc.am.oo.gc(oo.java:784)
[JBossINF] 	at com.ibm.db2.jcc.am.oo.executeUpdate(oo.java:763)
[JBossINF] 	at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:115)
[JBossINF] 	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
[JBossINF] 	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.updateBucket(JdbcBinaryCacheStore.java:248)
[JBossINF] 	... 76 more
[JBossINF]

 <binary-keyed-jdbc-store datasource="java:jboss/datasources/testDS" preload="true" passivation="false" purge="false">
<binary-keyed-table prefix="b">
<id-column name="id" type="VARCHAR(255)"/>
<data-column name="datum" type="BLOB"/>
<timestamp-column name="ver" type="INTEGER"/>
</binary-keyed-table>
</binary-keyed-jdbc-store>
Comment 1 Jitka Kozana 2013-09-23 13:41:10 UTC 
Link to server log:
https://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/eap-6x-failover-db-session-shutdown-repl-sync-db2/10/console-perf18/consoleText
Comment 2 Paul Ferraro 2013-09-24 01:56:52 UTC 
@Jitka Are you able to decipher that DB2 error message?
Comment 3 Paul Ferraro 2013-09-26 14:02:30 UTC 
I'm no DB2 expert, but according to:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.codes%2Fsrc%2Ftpc%2Fn302.htm

a -302 SQLCODE means the size allocation of a column is too small to support the data being inserted.

The timestamp-column stores the value of a java long.  This requires a 64-bit numerical type.  According to:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.intro%2Fsrc%2Ftpc%2Fdb2z_numericdatatypes.htm
... a DB2 INTEGER is only 32-bit.

The configuration of the cache store should be changed to:

<timestamp-column name="ver" type="BIGINT"/>
Comment 4 Tomas Remes 2013-09-27 05:55:18 UTC 
@Paul

I suspected some kind of this problem and I've tried that also with BIGINT, but with same results. We can give it one more try, but I am not too optimistic.
Comment 5 Jitka Kozana 2013-10-09 10:34:33 UTC 
I can report, this is the successful run with the following configuration:

<binary-keyed-jdbc-store datasource="java:jboss/datasources/testDS" preload="true" passivation="false" purge="false">
<binary-keyed-table prefix="b">
<id-column name="id" type="VARCHAR(255)"/>
<data-column name="datum" type="BLOB"/>
<timestamp-column name="ver" type="BIGINT"/>
</binary-keyed-table>
</binary-keyed-jdbc-store>

Link to job: 
https://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/eap-6x-failover-db-session-shutdown-repl-sync-db2/15/
Note You need to log in before you can comment on or make changes to this bug.