Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14109

Calcite integration. Sqlline tool freezes at the authorization step.

    XMLWordPrintableJSON

    Details

    • Ignite Flags:
      Docs Required, Release Notes Required

      Description

      Although authorization is not even enabled in the config:

      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:
      

       

      If you run the same test but using the 8733 build, then everything is successful:

      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
      

      I also tried to enable authorization and connect with options, but tool hangs in the same place:

      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:
      

      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']
       

       

        Attachments

        1. server.xml
          5 kB
          Fedor Malchikov
        2. 42383
          8 kB
          Fedor Malchikov
        3. 42187
          5 kB
          Fedor Malchikov
        4. 42274
          55 kB
          Fedor Malchikov

          Issue Links

            Activity

              People

              • Assignee:
                korlov Konstantin Orlov
                Reporter:
                prom1se Fedor Malchikov
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m