[
https://issues.apache.org/jira/browse/IGNITE-14109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-14109:
---------------------------------------
Labels: calcite2-required calcite3-required (was: )
> Calcite integration. Sqlline tool freezes at the authorization step.
> --------------------------------------------------------------------
>
> Key: IGNITE-14109
> URL: https://issues.apache.org/jira/browse/IGNITE-14109
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Fedor Malchikov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: calcite2-required, calcite3-required
> Attachments: 42187, 42274, 42383, server.xml
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Although authorization is not even enabled in the config:
> {code:java}
> Feb 01, 2021 6:44:21 PM org.jline.utils.Log logr
> WARNING: Unable to create a system terminal, creating a dumb terminal (enable
> debug logging for more information)
> Setting property: [force, true]
> Setting property: [showWarnings, true]
> Setting property: [showNestedErrs, true]
> issuing: !connect -p driver org.apache.ignite.IgniteJdbcThinDriver
> "jdbc:ignite:thin://127.0.0.1?useExperimentalQueryEngine=true"
> Connecting to jdbc:ignite:thin://127.0.0.1?useExperimentalQueryEngine=true
> Enter username for
> jdbc:ignite:thin://127.0.0.1?useExperimentalQueryEngine=true:
> {code}
>
> If you run the same test but using the 8733 build, then everything is
> successful:
> {code:java}
> Setting property: [force, true]
> Setting property: [showWarnings, true]
> Setting property: [showNestedErrs, true]
> issuing: !connect jdbc:ignite:thin://127.0.0.1/?distributedJoins=true '' ''
> org.apache.ignite.IgniteJdbcThinDriver
> Connecting to jdbc:ignite:thin://127.0.0.1/?distributedJoins=true
> WARNING: An illegal reflective access operation has occurred
> WARNING: Illegal reflective access by
> org.apache.ignite.internal.util.GridUnsafe$2
> (file:art-gg-com/libs/ignite-core-8.7.33.jar) to field java.nio.Buffer.address
> WARNING: Please consider reporting this to the maintainers of
> org.apache.ignite.internal.util.GridUnsafe$2
> WARNING: Use --illegal-access=warn to enable warnings of further illegal
> reflective access operations
> WARNING: All illegal access operations will be denied in a future release
> Connected to: Apache Ignite (version 8.7.33#20201223-sha1:253a2146)
> Driver: Apache Ignite Thin JDBC Driver (version 8.7.33#20201223-sha1:253a2146)
> Autocommit status: true
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> 1/436 !outputformat csv
> {code}
> I also tried to enable authorization and connect with options, but tool hangs
> in the same place:
> {code:java}
> Feb 01, 2021 6:27:32 PM org.jline.utils.Log logr
> WARNING: Unable to create a system terminal, creating a dumb terminal (enable
> debug logging for more information)
> Setting property: [force, true]
> Setting property: [showWarnings, true]
> Setting property: [showNestedErrs, true]
> issuing: !connect -p driver org.apache.ignite.IgniteJdbcThinDriver
> "jdbc:ignite:thin://127.0.0.1;user=ignite;password=ignite?useExperimentalQueryEngine=true"
> WARNING: An illegal reflective access operation has occurred
> WARNING: Illegal reflective access by
> org.apache.ignite.internal.util.GridUnsafe$2
> (file:/home/prom1se/GG/calcite_work/var/suite-sql_combination/app-ign-calcite/libs/ignite-core-2.9.0.t48.jar)
> to field java.nio.Buffer.address
> WARNING: Please consider reporting this to the maintainers of
> org.apache.ignite.internal.util.GridUnsafe$2
> WARNING: Use --illegal-access=warn to enable warnings of further illegal
> reflective access operations
> WARNING: All illegal access operations will be denied in a future release
> Connecting to
> jdbc:ignite:thin://127.0.0.1;user=ignite;password=ignite?useExperimentalQueryEngine=true
> Enter username for
> jdbc:ignite:thin://127.0.0.1;user=ignite;password=ignite?useExperimentalQueryEngine=true:
> {code}
> Command line:
> ['app-ign-calcite/bin/sqlline.sh', '-d',
> 'org.apache.ignite.IgniteJdbcThinDriver', '--verbose=true', '--force=true',
> '--showWarnings=true', '--showNestedErrs=true', '-u',
> 'jdbc:ignite:thin://127.0.0.1?useExperimentalQueryEngine=true', '-f',
> 'test_sql_combination/ddl_create_with_memory/ddl_create_with_memory..calcite.sql.1.batch.txt']
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
