[
https://issues.apache.org/jira/browse/IGNITE-10007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16666914#comment-16666914
]
Vladimir Ozerov commented on IGNITE-10007:
------------------------------------------
Improved test is attached which reproduces the problem. Root cause:
{{GridQueryProcessor.querySqlFields}} - it doesn't allow to execute COMMIT on
deactivated cluster, hence we cannot finish transaction. Need to move that
check deeper inside H2 indexing and make sure that it is not performed for
COMMIT/ROLLBACK commands.
> Deactivation hangs if an open transaction exists
> ------------------------------------------------
>
> Key: IGNITE-10007
> URL: https://issues.apache.org/jira/browse/IGNITE-10007
> Project: Ignite
> Issue Type: Bug
> Components: mvcc
> Affects Versions: 2.7
> Reporter: Sergey Kozlov
> Assignee: Vladimir Ozerov
> Priority: Major
> Fix For: 2.7
>
> Attachments:
> PersistenceDeactivationWIthActiveMvccTransactionSelfTest.java,
> stacktrace_18308.txt, stacktrace_7808.txt
>
>
> 1. Start 2 node with PDS
> 2. Activate cluster
> 3. Connect sqlline
> 4. Create table {{create table t1(a int, b varchar, primary key(a)) with
> "ATOMICITY=TRANSACTIONAL_SNAPSHOT,backups=1";}}
> 3.Start TX and execute a DML commnd:
> {noformat}
> begin;
> insert into t1 values (1, '1');
> {noformat}
> 4. Try deactivate cluster {{bin/control.bat --deactivate}}. The scripts
> doesn't return control.
> 5. Show LRT:
> {noformat}
> c:\Work\apache-ignite-2.7.0-SNAPSHOT-bin>bin\control.bat --tx
> Control utility [ver. 2.7.0-SNAPSHOT#19700101-sha1:DEV]
> 2018 Copyright(C) Apache Software Foundation
> User:
> --------------------------------------------------------------------------------
> Matching transactions:
> TcpDiscoveryNode [id=5d3e8936-174d-42e2-a47f-c70ec02bccab, addrs=[127.0.0.1],
> order=1, ver=2.7.0#19700101-sha1:00000000,
> isClient=false, consistentId=1]
> Tx: [xid=74bc1aba661-00000000-090e-b121-0000-000000000001, label=null,
> state=ACTIVE, startTime=2018-10-25 17:34:35.5
> 22, duration=352, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC,
> topVer=AffinityTopologyVersion [topVer=2, minorTop
> Ver=6], timeout=0, size=0, dhtNodes=[41ff88d2],
> nearXid=74bc1aba661-00000000-090e-b121-0000-000000000001, parentNodeIds=
> [5d3e8936]]
> {noformat}
> 6. Complete TX:
> {noformat}
> 0: jdbc:ignite:thin://127.0.0.1/> commit;
> Error: class org.apache.ignite.IgniteException: Can not perform the operation
> because the cluster is inactive. Note, tha
> t the cluster is considered inactive by default if Ignite Persistent Store is
> used to let all the nodes join the cluster
> . To activate the cluster call Ignite.active(true). (state=50000,code=1)
> java.sql.SQLException: class org.apache.ignite.IgniteException: Can not
> perform the operation because the cluster is ina
> ctive. Note, that the cluster is considered inactive by default if Ignite
> Persistent Store is used to let all the nodes
> join the cluster. To activate the cluster call Ignite.active(true).
> 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 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)
> 0: jdbc:ignite:thin://127.0.0.1/>
> {noformat}
> It.s ok but LRT is still presented and deactivation script doesn't return
> control back to user:
> {noformat}
> c:\Work\apache-ignite-2.7.0-SNAPSHOT-bin>bin\control.bat --tx
> Control utility [ver. 2.7.0-SNAPSHOT#19700101-sha1:DEV]
> 2018 Copyright(C) Apache Software Foundation
> User:
> --------------------------------------------------------------------------------
> Matching transactions:
> TcpDiscoveryNode [id=5d3e8936-174d-42e2-a47f-c70ec02bccab, addrs=[127.0.0.1],
> order=1, ver=2.7.0#19700101-sha1:00000000,
> isClient=false, consistentId=1]
> Tx: [xid=74bc1aba661-00000000-090e-b121-0000-000000000001, label=null,
> state=ACTIVE, startTime=2018-10-25 17:34:35.5
> 22, duration=510, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC,
> topVer=AffinityTopologyVersion [topVer=2, minorTop
> Ver=6], timeout=0, size=0, dhtNodes=[41ff88d2],
> nearXid=74bc1aba661-00000000-090e-b121-0000-000000000001, parentNodeIds=
> [5d3e8936]]
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
