[jira] [Created] (IGNITE-14109) Calcite integration. Sqlline tool freezes at the authorization step.

[Anton Vinogradov (Jira)]

Fedor Malchikov  created IGNITE-14109:
-----------------------------------------

             Summary: 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
         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.IgniteJdbcThinDriverConnecting to jdbc:ignite:thin://127.0.0.1/?distributedJoins=trueWARNING: An illegal reflective access operation has occurredWARNING: Illegal reflective access by org.apache.ignite.internal.util.GridUnsafe$2 (file:/home/prom1se/GG/calcite_work/var/suite-sql_combination/art-gg-com/libs/ignite-core-8.7.33.jar) to field java.nio.Buffer.addressWARNING: Please consider reporting this to the maintainers of org.apache.ignite.internal.util.GridUnsafe$2WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operationsWARNING: All illegal access operations will be denied in a future releaseConnected 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: trueTransaction isolation: TRANSACTION_REPEATABLE_READ1/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)