[ 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)