[
https://issues.apache.org/jira/browse/IGNITE-24918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Dmitrienko updated IGNITE-24918:
-----------------------------------------
Attachment: ignite3db-0.log
Description:
*Steps to reproduce:*
# Create two tables:
{code:java}
create zone if not exists "DEFAULT_ZONE" with storage_profiles='default'
create TABLE table_1(id INTEGER not null, int_field_1 INTEGER not null,
str_field_1 VARCHAR(50) not null, primary key (id)) ZONE "DEFAULT_ZONE"
create TABLE table_2(id INTEGER not null, int_field_1 INTEGER not null,
str_field_1 VARCHAR(50) not null, primary key (id)) ZONE "DEFAULT_ZONE"{code}
# Execute a DELETE query which contains a subquery:
{code:java}
DELETE FROM table_1 WHERE id IN (SELECT id FROM table_2 WHERE id = 2);{code}
*Actual result:*
The DELETE query returns the following error:
{code:java}
SQL query execution error
Transaction is already finished txId=[0195c919-55f5-0002-e3d4-5e3000000001,
txState=FINISHING].{code}
See the full log here: *[^ignite3db-0.log]*
*Note:*
The issue might not be reproduced on the first attempt; multiple retries may be
required.
*Expected result:*
The DELETE query executed successfully.
was:
*Steps to reproduce:*
# Create two tables:
{code:java}
create zone if not exists "DEFAULT_ZONE" with storage_profiles='default'
create TABLE table_1(id INTEGER not null, int_field_1 INTEGER not null,
str_field_1 VARCHAR(50) not null, primary key (id)) ZONE "DEFAULT_ZONE"
create TABLE table_2(id INTEGER not null, int_field_1 INTEGER not null,
str_field_1 VARCHAR(50) not null, primary key (id)) ZONE "DEFAULT_ZONE"{code}
# Execute a DELETE query which contains a subquery:
{code:java}
DELETE FROM table_1 WHERE id IN (SELECT id FROM table_2 WHERE id = 2);{code}
*Actual result:*
The DELETE query returns the following error:
{code:java}
SQL query execution error
Transaction is already finished txId=[0195c919-55f5-0002-e3d4-5e3000000001,
txState=FINISHING].{code}
*Note:*
The issue might not be reproduced on the first attempt; multiple retries may be
required.
*Expected result:*
The DELETE query executed successfully.
> [Flaky] "Transaction is already finished" error on DELETE with subquery
> -----------------------------------------------------------------------
>
> Key: IGNITE-24918
> URL: https://issues.apache.org/jira/browse/IGNITE-24918
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Environment: 1-node cluster.
> JVM params: "-Xms4096m", "-Xmx4096m"
> Host: vCPU: 4, Memory: 32GB.
> Reporter: Vladimir Dmitrienko
> Priority: Major
> Labels: ignite-3
> Attachments: ignite3db-0.log
>
>
> *Steps to reproduce:*
> # Create two tables:
> {code:java}
> create zone if not exists "DEFAULT_ZONE" with storage_profiles='default'
> create TABLE table_1(id INTEGER not null, int_field_1 INTEGER not null,
> str_field_1 VARCHAR(50) not null, primary key (id)) ZONE "DEFAULT_ZONE"
> create TABLE table_2(id INTEGER not null, int_field_1 INTEGER not null,
> str_field_1 VARCHAR(50) not null, primary key (id)) ZONE "DEFAULT_ZONE"{code}
> # Execute a DELETE query which contains a subquery:
> {code:java}
> DELETE FROM table_1 WHERE id IN (SELECT id FROM table_2 WHERE id = 2);{code}
> *Actual result:*
> The DELETE query returns the following error:
>
> {code:java}
> SQL query execution error
> Transaction is already finished txId=[0195c919-55f5-0002-e3d4-5e3000000001,
> txState=FINISHING].{code}
> See the full log here: *[^ignite3db-0.log]*
> *Note:*
> The issue might not be reproduced on the first attempt; multiple retries may
> be required.
> *Expected result:*
> The DELETE query executed successfully.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
