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

SQLLine: can't run with option --autoCommit=false or true

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.7
    • Fix Version/s: 2.7
    • Component/s: mvcc, sql
    • Labels:
      None

      Description

      Trying to run sqlline with additional options

      $ /bin/sqlline.sh --autoCommit=false --color=true --outputFormat=csv --showNestedErrs=true --showWarnings=true --verbose=true -u jdbc:ignite:thin://127.0.0.1:10800
      

      SQLline is working but with exception on start:

      issuing: !connect jdbc:ignite:thin://127.0.0.1:10800 '' '' org.apache.ignite.IgniteJdbcThinDriver
      Connecting to jdbc:ignite:thin://127.0.0.1:10800
      Connected to: Apache Ignite (version 2.7.1#20181023-sha1:0ccde7c4)
      Driver: Apache Ignite Thin JDBC Driver (version 2.7.1#20181023-sha1:0ccde7c4)
      Error: MVCC must be enabled in order to invoke transactional operation: COMMIT (state=25000,code=5002)
      java.sql.SQLException: MVCC must be enabled in order to invoke transactional operation: COMMIT
              at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750)
              at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)
              at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)
              at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.doCommit(JdbcThinConnection.java:369)
              at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.setAutoCommit(JdbcThinConnection.java:328)
              at sqlline.DatabaseConnection.connect(DatabaseConnection.java:178)
              at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:204)
              at sqlline.Commands.connect(Commands.java:1095)
              at sqlline.Commands.connect(Commands.java:1001)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
              at sqlline.SqlLine.dispatch(SqlLine.java:791)
              at sqlline.SqlLine.initArgs(SqlLine.java:566)
              at sqlline.SqlLine.begin(SqlLine.java:643)
              at sqlline.SqlLine.start(SqlLine.java:373)
              at sqlline.SqlLine.main(SqlLine.java:265)
      Transaction isolation: TRANSACTION_REPEATABLE_READ
      

      Without --autoCommit option sqlline running without this exception

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Pavlukhin Ivan Pavlukhin
                Reporter:
                spilschikov Stepan Pilschikov
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: