Bug 1087209 - Infinispan issue: Preloading fails with JdbcBinaryCacheStore on DB2
Summary: Infinispan issue: Preloading fails with JdbcBinaryCacheStore on DB2
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: Clustering
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ER4
: EAP 6.3.0
Assignee: Paul Ferraro
QA Contact: Jitka Kozana
Russell Dickenson
URL:
Whiteboard:
Depends On: 1087264
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-04-14 06:53 UTC by Boleslaw Dawidowicz
Modified: 2014-06-28 15:42 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2014-06-28 15:42:12 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker ISPN-3689 0 Major Resolved Preloading fails with JdbcBinaryCacheStore on DB2 2016-03-16 16:36:08 UTC

Description Boleslaw Dawidowicz 2014-04-14 06:53:45 UTC
I use the JdbcBinaryCacheStore with preloading enabled, when I test it on DB2 I get an exception of type:

06.11.2013 16:27:51 *ERROR* [main] DataManipulationHelper: ISPN008007: SQL error while fetching all StoredEntries (DataManipulationHelper.java, line 253)
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=?;r_quota" FETCH FIRST;<space>, DRIVER=4.13.80
	at com.ibm.db2.jcc.am.id.a(id.java:677)
	at com.ibm.db2.jcc.am.id.a(id.java:60)
	at com.ibm.db2.jcc.am.id.a(id.java:127)
	at com.ibm.db2.jcc.am.fo.c(fo.java:2653)
	at com.ibm.db2.jcc.am.fo.d(fo.java:2641)
	at com.ibm.db2.jcc.am.fo.a(fo.java:2090)
	at com.ibm.db2.jcc.am.go.a(go.java:7639)
	at com.ibm.db2.jcc.t4.cb.h(cb.java:141)
	at com.ibm.db2.jcc.t4.cb.b(cb.java:41)
	at com.ibm.db2.jcc.t4.q.a(q.java:32)
	at com.ibm.db2.jcc.t4.sb.i(sb.java:135)
	at com.ibm.db2.jcc.am.fo.ib(fo.java:2059)
	at com.ibm.db2.jcc.am.go.sc(go.java:3555)
	at com.ibm.db2.jcc.am.go.b(go.java:4344)
	at com.ibm.db2.jcc.am.go.fc(go.java:741)
	at com.ibm.db2.jcc.am.go.executeQuery(go.java:711)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.infinispan.loaders.jdbc.DataManipulationHelper.loadSome(DataManipulationHelper.java:245)
	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.loadLockSafe(JdbcBinaryCacheStore.java:312)
	at org.infinispan.loaders.LockSupportCacheStore.load(LockSupportCacheStore.java:167)
	at org.infinispan.loaders.CacheLoaderManagerImpl.loadState(CacheLoaderManagerImpl.java:285)
	at org.infinispan.loaders.CacheLoaderManagerImpl.preload(CacheLoaderManagerImpl.java:238)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:203)
	at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:886)
	at org.infinispan.factories.AbstractComponentRegistry.invokeStartMethods(AbstractComponentRegistry.java:657)
	at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:646)
	at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:549)
	at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:217)
	at org.infinispan.CacheImpl.start(CacheImpl.java:582)
	at org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:686)
	at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:649)
	at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:545)

I looks like you cannot use a parameter to set your query limit in case of DB2 9.7.5 at least

Comment 1 Boleslaw Dawidowicz 2014-04-14 06:57:14 UTC
Needed for JBoss Portal 6.2

Comment 2 Kabir Khan 2014-04-23 21:23:36 UTC
Fixed by component upgrade https://bugzilla.redhat.com/show_bug.cgi?id=1087264

Comment 3 Kabir Khan 2014-04-25 15:31:48 UTC
Moving to ER4 since ER3 is the new beta candidate, and is ER2+beta blockers only

Comment 4 Ladislav Thon 2014-05-23 10:11:24 UTC
Verified with EAP 6.3.0.ER4.


Note You need to log in before you can comment on or make changes to this bug.