Vladimir Dmitrienko created IGNITE-24918:
--------------------------------------------
Summary: [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
*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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)