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

2018-04-16 Thread Roman Guseinov (JIRA)

 [ 
https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Guseinov updated IGNITE-8197:
---
Attachment: spring-boot-ignite.zip

> 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)
>  ~[ignite-core-2.4.0.jar:2.4.0]
> at 

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

2018-04-16 Thread Roman Guseinov (JIRA)

 [ 
https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Guseinov updated IGNITE-8197:
---
Attachment: (was: spring-boot-ignite.zip)

> 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
>
> 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)
>  ~[ignite-core-2.4.0.jar:2.4.0]
> at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) 
> 

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

2018-04-16 Thread Roman Guseinov (JIRA)

 [ 
https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Guseinov updated IGNITE-8197:
---
Attachment: spring-boot-ignite.zip

> 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)
>  ~[ignite-core-2.4.0.jar:2.4.0]
> at