[jira] [Created] (IGNITE-24918) [Flaky] "Transaction is already finished" error on DELETE with subquery

["Vladimir Dmitrienko (Jira)" <ji...@apache.org>]

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)