[jira] [Commented] (IGNITE-8197) ignite won't start with spring-boot 1.5.11 - h2 property NESTED_JOINS doesn't exist
[
https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17446727#comment-17446727
]
Matthew Compton commented on IGNITE-8197:
-
I think perhaps this was fixed as part of IGNITE-4150? It looks like Ignite was
[updated to use 1.4.197 and the offending {{NESTED_JOINS}} setting was removed
from the db options
configuration|https://github.com/apache/ignite/commit/50c5809a803f02e2de7b1984c556537568562189].
> 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.(ConnectionInfo.java:76)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.jdbc.JdbcConnection.(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
>
[jira] [Commented] (IGNITE-8197) ignite won't start with spring-boot 1.5.11 - h2 property NESTED_JOINS doesn't exist
[
https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16598228#comment-16598228
]
Dima commented on IGNITE-8197:
--
This setting has been removed from H2
[https://github.com/h2database/h2database/issues/901]
> 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.(ConnectionInfo.java:76)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.jdbc.JdbcConnection.(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)
>
[jira] [Commented] (IGNITE-8197) ignite won't start with spring-boot 1.5.11 - h2 property NESTED_JOINS doesn't exist
[
https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16525939#comment-16525939
]
kcheng.mvp commented on IGNITE-8197:
As h2 is the core of ignite, so it should take every consideration into mind
when do h2 upgrade.
for you case, you can simply to overwrite springboot's h2 version by add below
to your pom
1.4.195
> 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.(ConnectionInfo.java:76)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.jdbc.JdbcConnection.(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
>
[jira] [Commented] (IGNITE-8197) ignite won't start with spring-boot 1.5.11 - h2 property NESTED_JOINS doesn't exist
[
https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1681#comment-1681
]
Łukasz Byjoś commented on IGNITE-8197:
--
I updated spring boot from 2.0.0.RC1 to 2.0.1.RELEASE and have the same issue
> 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.(ConnectionInfo.java:76)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.jdbc.JdbcConnection.(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)
>
[jira] [Commented] (IGNITE-8197) ignite won't start with spring-boot 1.5.11 - h2 property NESTED_JOINS doesn't exist
[
https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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.(ConnectionInfo.java:76)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.jdbc.JdbcConnection.(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)
>
