You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Alexey Kukushkin (Jira)" <ji...@apache.org> on 2021/08/03 19:14:00 UTC

[jira] [Commented] (IGNITE-14381) Failed to initialize DB connection- Unsupported connection setting "MULTI_THREADED"

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

Alexey Kukushkin commented on IGNITE-14381:
-------------------------------------------

Opened IGNITE-15241 to address the issue.

> Failed to initialize DB connection- Unsupported connection setting "MULTI_THREADED" 
> ------------------------------------------------------------------------------------
>
>                 Key: IGNITE-14381
>                 URL: https://issues.apache.org/jira/browse/IGNITE-14381
>             Project: Ignite
>          Issue Type: Bug
>    Affects Versions: 2.10
>            Reporter: Devansh Arora
>            Priority: Major
>
> Our Application with dependency to *ignite spring 2.10.0* and *h2 1.4.200*
>   fails to start with error 
>  
> org.apache.ignite.internal.IgniteKernal:?|?|Exception during start processors, node will be stopped and close connections
> org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to initialize DB connection: jdbc:h2:mem:9feea9ed-f89e-4818-b9d7-638749a474d2;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;MAX_OPERATION_MEMORY=0;BATCH_JOINS=1;ROW_FACTORY="org.apache.ignite.internal.processors.query.h2.opt.H2PlainRowFactory";DEFAULT_TABLE_ENGINE=org.apache.ignite.internal.processors.query.h2.opt.GridH2DefaultTableEngine
> Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Unsupported connection setting "MULTI_THREADED" [90113-200]
> Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Unsupported connection setting "MULTI_THREADED" [90113-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:622) at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
> If we revert *h2* version to *1.4.197* it works. But this version has some security vulnerabilities associated to it.
>  [https://www.cvedetails.com/vulnerability-list/vendor_id-17893/product_id-45580/version_id-243447/H2database-H2-1.4.197.html]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)