[ https://issues.apache.org/jira/browse/IGNITE-9620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stepan Pilschikov updated IGNITE-9620: -------------------------------------- Description: Using sqlline with autoCommit=true {code} switch to first user - select * from test: result: [[1, 1, test_1]] switch to second user - insert into test(id, field_int, field_var) values (2, 2, 'test_2'): - commit: - select * from test: result: [[1, 1, test_1], [2, 2, test_2]] switch to first user - insert into test(id, field_int, field_var) values (2, 2, 'test_2'): error: Mvcc version mismatch. - select * from test {code} During last select throwing exception {code} 0: jdbc:ignite:thin://127.0.0.1:10800> select * from test; select * from test; [1;31mError: Transaction is already completed. (state=25000,code=0)[m java.sql.SQLException: Transaction is already completed. at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:764) 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 sqlline.Commands.execute(Commands.java:823) at sqlline.Commands.sql(Commands.java:733) at sqlline.SqlLine.dispatch(SqlLine.java:795) at sqlline.SqlLine.begin(SqlLine.java:668) at sqlline.SqlLine.start(SqlLine.java:373) at sqlline.SqlLine.main(SqlLine.java:265) {code} Exception in node logs: {code} [17:44:36,234][SEVERE][jdbc-request-handler-worker-#61][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=select * from test, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=false]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Transaction is already completed. at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.checkActive(MvccUtils.java:623) at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.requestSnapshot(MvccUtils.java:780) at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.mvccTracker(MvccUtils.java:761) at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.mvccTracker(MvccUtils.java:744) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.runQueryTwoStep(IgniteH2Indexing.java:1731) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunDistributedQuery(IgniteH2Indexing.java:2521) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2074) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2139) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2134) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2711) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2148) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at java.lang.Thread.run(Thread.java:748) {code} Works for any query which is throwing mvcc missmatch exception After commit select query works again was: Using sqlline with autoCommit=false {code} switch to first user - select * from test: result: [[1, 1, test_1]] switch to second user - insert into test(id, field_int, field_var) values (2, 2, 'test_2'): - commit: - select * from test: result: [[1, 1, test_1], [2, 2, test_2]] switch to first user - insert into test(id, field_int, field_var) values (2, 2, 'test_2'): error: Mvcc version mismatch. - select * from test {code} During last select throwing exception {code} 0: jdbc:ignite:thin://127.0.0.1:10800> select * from test; select * from test; [1;31mError: Transaction is already completed. (state=25000,code=0)[m java.sql.SQLException: Transaction is already completed. at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:764) 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 sqlline.Commands.execute(Commands.java:823) at sqlline.Commands.sql(Commands.java:733) at sqlline.SqlLine.dispatch(SqlLine.java:795) at sqlline.SqlLine.begin(SqlLine.java:668) at sqlline.SqlLine.start(SqlLine.java:373) at sqlline.SqlLine.main(SqlLine.java:265) {code} Exception in node logs: {code} [17:44:36,234][SEVERE][jdbc-request-handler-worker-#61][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=select * from test, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=false]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Transaction is already completed. at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.checkActive(MvccUtils.java:623) at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.requestSnapshot(MvccUtils.java:780) at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.mvccTracker(MvccUtils.java:761) at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.mvccTracker(MvccUtils.java:744) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.runQueryTwoStep(IgniteH2Indexing.java:1731) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunDistributedQuery(IgniteH2Indexing.java:2521) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2074) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2139) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2134) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2711) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2148) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at java.lang.Thread.run(Thread.java:748) {code} Works for any query which is throwing mvcc missmatch exception After commit select query works again > MVCC: select throwing `Transaction is already completed` exception after > mvcc missmatch > ---------------------------------------------------------------------------------------- > > Key: IGNITE-9620 > URL: https://issues.apache.org/jira/browse/IGNITE-9620 > Project: Ignite > Issue Type: Bug > Components: mvcc > Affects Versions: 2.7 > Reporter: Stepan Pilschikov > Priority: Major > > Using sqlline with autoCommit=true > {code} > switch to first user > - select * from test: > result: [[1, 1, test_1]] > switch to second user > - insert into test(id, field_int, field_var) values (2, 2, 'test_2'): > - commit: > - select * from test: > result: [[1, 1, test_1], [2, 2, test_2]] > switch to first user > - insert into test(id, field_int, field_var) values (2, 2, 'test_2'): > error: Mvcc version mismatch. > - select * from test > {code} > During last select throwing exception > {code} > 0: jdbc:ignite:thin://127.0.0.1:10800> select * from test; > select * from test; > [1;31mError: Transaction is already completed. (state=25000,code=0)[m > java.sql.SQLException: Transaction is already completed. > at > org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:764) > 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 sqlline.Commands.execute(Commands.java:823) > at sqlline.Commands.sql(Commands.java:733) > at sqlline.SqlLine.dispatch(SqlLine.java:795) > at sqlline.SqlLine.begin(SqlLine.java:668) > at sqlline.SqlLine.start(SqlLine.java:373) > at sqlline.SqlLine.main(SqlLine.java:265) > {code} > Exception in node logs: > {code} > [17:44:36,234][SEVERE][jdbc-request-handler-worker-#61][JdbcRequestHandler] > Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest > [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=select * from test, > args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=false]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: > Transaction is already completed. > at > org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.checkActive(MvccUtils.java:623) > at > org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.requestSnapshot(MvccUtils.java:780) > at > org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.mvccTracker(MvccUtils.java:761) > at > org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.mvccTracker(MvccUtils.java:744) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.runQueryTwoStep(IgniteH2Indexing.java:1731) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunDistributedQuery(IgniteH2Indexing.java:2521) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2074) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2139) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2134) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2711) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2148) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at java.lang.Thread.run(Thread.java:748) > {code} > Works for any query which is throwing mvcc missmatch exception > After commit select query works again -- This message was sent by Atlassian JIRA (v7.6.3#76005)