You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/10/11 09:41:00 UTC
[jira] [Commented] (IGNITE-9620) MVCC: select throwing
`Transaction is already completed` exception after mvcc missmatch
[ https://issues.apache.org/jira/browse/IGNITE-9620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16646192#comment-16646192 ]
ASF GitHub Bot commented on IGNITE-9620:
----------------------------------------
GitHub user devozerov opened a pull request:
https://github.com/apache/ignite/pull/4952
IGNITE-9620
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gridgain/apache-ignite ignite-9620-1
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/4952.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #4952
----
commit 6fc6f146223c1b71ab14a8e139da8308d8e18592
Author: devozerov <vo...@...>
Date: 2018-10-11T08:06:24Z
WIP.
commit d6a93ba8a866d0572445fa901e88ec09f3cad404
Author: devozerov <vo...@...>
Date: 2018-10-11T08:34:40Z
WIP.
commit 7ed6b9a5e102e2d6b700b8cf69a49b143faed912
Author: devozerov <vo...@...>
Date: 2018-10-11T08:49:08Z
WIP.
commit 0f0f6c79e58319c0807b6183afd31f7dea7a507c
Author: devozerov <vo...@...>
Date: 2018-10-11T09:14:15Z
WIP.
commit 76566c13aebc6291a6c30bc7c8de8ddc05bd4e05
Author: devozerov <vo...@...>
Date: 2018-10-11T09:19:14Z
SQL state,
commit bb72f863f2f83c34e4592ec3afe33312fd0639c9
Author: devozerov <vo...@...>
Date: 2018-10-11T09:32:52Z
SQL test.
commit ad04fcd854aa484e4aa3b31bb26f13be8ffda5f8
Author: devozerov <vo...@...>
Date: 2018-10-11T09:35:41Z
WIP
commit 75d5df8687ee42c3c4d5183895c4df4e4b18e7ef
Author: devozerov <vo...@...>
Date: 2018-10-11T09:39:09Z
WIP.
----
> 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
> Reporter: Stepan Pilschikov
> Assignee: Vladimir Ozerov
> Priority: Major
> Fix For: 2.7
>
>
> 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)