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

["Roman Guseinov (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16440269#comment-16440269 ] 

Roman Guseinov commented on IGNITE-8197:
----------------------------------------

I attached a reproducer - [^spring-boot-ignite.zip]. I guess the solution is related to handling "Unsupported connection setting" exceptions.

I think Apache Ignite should be able to work with new H2 versions and such types of error should not lead node stop.

> ignite won't start with spring-boot 1.5.11 - h2 property NESTED_JOINS doesn't exist
> -----------------------------------------------------------------------------------
>
>                 Key: IGNITE-8197
>                 URL: https://issues.apache.org/jira/browse/IGNITE-8197
>             Project: Ignite
>          Issue Type: Bug
>            Reporter: Scott Feldstein
>            Priority: Major
>         Attachments: spring-boot-ignite.zip
>
>
> 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
> {code:java}
> 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]{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)