[IGNITE-8197] ignite won't start with spring-boot 1.5.11 - h2 property NESTED_JOINS doesn't exist

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Scott Feldstein
• Created: 09/Apr/18 19:13
• Updated: 20/Nov/21 00:46

Description

I just upgraded to spring-boot 1.5.11 and am seeing the error below. I think this is an issue with the version of h2 associated with spring boot 1.5.11. In 1.5.10 the h2 version was 1.4.196 and with 1.5.11 it is 1.4.197. The NESTED_JOINS property comes from org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing, i assume it was deprecated but not sure. When I lock in my h2 version to 1.4.196 by overriding the spring-dependencies parent everything works fine

Caused by: org.h2.jdbc.JdbcSQLException: Unsupported connection setting "NESTED_JOINS" [90113-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357) ~[h2-1.4.197.jar:1.4.197]
at org.h2.message.DbException.get(DbException.java:179) ~[h2-1.4.197.jar:1.4.197]
at org.h2.message.DbException.get(DbException.java:155) ~[h2-1.4.197.jar:1.4.197]
at org.h2.engine.ConnectionInfo.readSettingsFromURL(ConnectionInfo.java:268) ~[h2-1.4.197.jar:1.4.197]
at org.h2.engine.ConnectionInfo.<init>(ConnectionInfo.java:76) ~[h2-1.4.197.jar:1.4.197]
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:103) ~[h2-1.4.197.jar:1.4.197]
at org.h2.Driver.connect(Driver.java:69) ~[h2-1.4.197.jar:1.4.197]
at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_131]
at java.sql.DriverManager.getConnection(DriverManager.java:270) ~[?:1.8.0_131]
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.initialValue(IgniteH2Indexing.java:317) ~[ignite-indexing-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.initialValue(IgniteH2Indexing.java:288) ~[ignite-indexing-2.4.0.jar:2.4.0]
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:180) ~[?:1.8.0_131]
at java.lang.ThreadLocal.get(ThreadLocal.java:170) ~[?:1.8.0_131]
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.get(IgniteH2Indexing.java:290) ~[ignite-indexing-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.get(IgniteH2Indexing.java:288) ~[ignite-indexing-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:514) ~[ignite-indexing-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeStatement(IgniteH2Indexing.java:582) ~[ignite-indexing-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createSchema(IgniteH2Indexing.java:551) ~[ignite-indexing-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerCache(IgniteH2Indexing.java:2667) ~[ignite-indexing-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.query.GridQueryProcessor.registerCache0(GridQueryProcessor.java:1594) ~[ignite-core-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart0(GridQueryProcessor.java:800) ~[ignite-core-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:861) ~[ignite-core-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1158) ~[ignite-core-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1900) ~[ignite-core-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCachesOnLocalJoin(GridCacheProcessor.java:1764) ~[ignite-core-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.initCachesOnLocalJoin(GridDhtPartitionsExchangeFuture.java:744) ~[ignite-core-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:626) ~[ignite-core-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:2337) ~[ignite-core-2.4.0.jar:2.4.0]
at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) ~[ignite-core-2.4.0.jar:2.4.0]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_131]