[
https://issues.apache.org/jira/browse/IGNITE-14109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fedor Malchikov updated IGNITE-14109:
--------------------------------------
Description:
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:/home/prom1se/GG/calcite_work/var/suite-sql_combination/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']
was:
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:gg-h2:mem:test '' '' org.gridgain.internal.h2.Driver
Connecting to jdbc:gg-h2:mem:test
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/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: H2 (version 1.4.199 (2019-03-13))
Driver: H2 JDBC Driver (version 1.4.199 (2019-03-13))
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']
> 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
> 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:/home/prom1se/GG/calcite_work/var/suite-sql_combination/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)
