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
