You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Konstantin Orlov (Jira)" <ji...@apache.org> on 2021/02/02 13:33:00 UTC
[jira] [Commented] (IGNITE-14109) Calcite integration. Sqlline tool
freezes at the authorization step.
[ https://issues.apache.org/jira/browse/IGNITE-14109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17277124#comment-17277124 ]
Konstantin Orlov commented on IGNITE-14109:
-------------------------------------------
The problem was SqlLine itself which requires authorization by default. This behaviour could be changed by adding {{--connectInteractionMode=notAskCredentials}} to the script: {{./sqlline.sh --connectInteractionMode=notAskCredentials <other params>}}.
> 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
> Attachments: 42187, 42274, 42383, server.xml
>
>
> 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)