Thanks Andrey. I have the issue fixed with specifying the h2.version=1.4.191, it became 1.4.193 because of spring boot.
On Wed, Apr 19, 2017 at 9:43 AM, Andrey Mashenkov < [email protected]> wrote: > Hi David, > > Looks like your H2 version is not compatible with ignite. Please, check if > correct version of H2 is in classpath. > > On Wed, Apr 19, 2017 at 4:37 AM, David Li <[email protected]> wrote: > >> I have a working ignite cluster and clients. However, then I added the >> ignite-indexing to the project dependency, only add the dependency, not yet >> change anything else yet. I got the following error: >> >> Anyone got any idea? >> >> Caused by: class >> org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to >> initialize DB connection: >> jdbc:h2:mem:7ff06a4c-add4-4cff-900b-3ebeec393757;LOCK_MODE=3;MULTI_THREADED=1;DB_CLOSE_ON_EXIT=FALSE;DEFAULT_LOCK_TIMEOUT=10000;FUNCTIONS_IN_SCHEMA=true;OPTIMIZE_REUSE_RESULTS=0;QUERY_CACHE_SIZE=0;RECOMPILE_ALWAYS=1;MAX_OPERATION_MEMORY=0;NESTED_JOINS=0;BATCH_JOINS=1;ROW_FACTORY="org.apache.ignite.internal.processors.query.h2.opt.GridH2RowFactory";DEFAULT_TABLE_ENGINE=org.apache.ignite.internal.processors.query.h2.opt.GridH2DefaultTableEngine >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.initialValue(IgniteH2Indexing.java:346) >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.initialValue(IgniteH2Indexing.java:314) >> at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:180) >> at java.lang.ThreadLocal.get(ThreadLocal.java:170) >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.get(IgniteH2Indexing.java:316) >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.get(IgniteH2Indexing.java:314) >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:490) >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeStatement(IgniteH2Indexing.java:555) >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createSchema(IgniteH2Indexing.java:527) >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerCache(IgniteH2Indexing.java:2231) >> at >> org.apache.ignite.internal.processors.query.GridQueryProcessor.initializeCache(GridQueryProcessor.java:224) >> at >> org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:529) >> at >> org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1078) >> at >> org.apache.ignite.internal.processors.cache.GridCacheProcessor.onKernalStart(GridCacheProcessor.java:814) >> at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:959) >> at >> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1799) >> at >> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1602) >> at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042) >> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569) >> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516) >> at org.apache.ignite.Ignition.start(Ignition.java:322) >> at >> com.dashur.data.ignite.IgniteClientConfig.ignite(IgniteClientConfig.java:45) >> at >> com.dashur.data.ignite.IgniteClientConfig$$EnhancerBySpringCGLIB$$29481e2c.CGLIB$ignite$1(<generated>) >> at >> com.dashur.data.ignite.IgniteClientConfig$$EnhancerBySpringCGLIB$$29481e2c$$FastClassBySpringCGLIB$$e8449de0.invoke(<generated>) >> at >> org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) >> at >> org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:356) >> at >> com.dashur.data.ignite.IgniteClientConfig$$EnhancerBySpringCGLIB$$29481e2c.ignite(<generated>) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:498) >> at >> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:162) >> ... 126 more >> Caused by: org.h2.jdbc.JdbcSQLException: General error: >> "java.lang.IncompatibleClassChangeError: >> org/apache/ignite/internal/processors/query/h2/opt/GridH2MetaTable$MetaRow" >> [50000-193] >> at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) >> at org.h2.message.DbException.get(DbException.java:168) >> at org.h2.message.DbException.convert(DbException.java:291) >> at org.h2.engine.Database.openDatabase(Database.java:304) >> at org.h2.engine.Database.<init>(Database.java:267) >> at org.h2.engine.Engine.openSession(Engine.java:64) >> at org.h2.engine.Engine.openSession(Engine.java:176) >> at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) >> at org.h2.engine.Engine.createSession(Engine.java:137) >> at org.h2.engine.Engine.createSession(Engine.java:27) >> at >> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) >> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115) >> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99) >> at org.h2.Driver.connect(Driver.java:69) >> at java.sql.DriverManager.getConnection(DriverManager.java:664) >> at java.sql.DriverManager.getConnection(DriverManager.java:270) >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.initialValue(IgniteH2Indexing.java:343) >> ... 157 more >> Caused by: java.lang.IncompatibleClassChangeError: >> org/apache/ignite/internal/processors/query/h2/opt/GridH2MetaTable$MetaRow >> at >> org.apache.ignite.internal.processors.query.h2.opt.GridH2MetaTable.getTemplateRow(GridH2MetaTable.java:81) >> at org.h2.engine.Database.addMeta(Database.java:867) >> at org.h2.engine.Database.addDatabaseObject(Database.java:1035) >> at org.h2.engine.Database.open(Database.java:777) >> at org.h2.engine.Database.openDatabase(Database.java:273) >> ... 170 more >> >> > > > -- > Best regards, > Andrey V. Mashenkov >
