Igor created IGNITE-24159:
-----------------------------
Summary: Open transaction doesn't see previously inserted data
when c3p0 used
Key: IGNITE-24159
URL: https://issues.apache.org/jira/browse/IGNITE-24159
Project: Ignite
Issue Type: Bug
Components: persistence
Affects Versions: 3.0.0-beta1
Environment: 3 nodes (each node is CMG, each node
{color:#067d17}"-Xms4096m"{color}, {color:#067d17}"-Xmx4096m"{color}), each on
separate host. Each host vCPU: 4, Memory: 32GB.
Reporter: Igor
Attachments: cluster_logs.zip
*Steps to reproduce:*
# Setup c3p0 as connection pool for datasource
{code:java}
ComboPooledDataSource c3p0Pool = new ComboPooledDataSource();
c3p0Pool.setJdbcUrl("jdbc:ignite:thin://" + thinClientEndpoint);
c3p0Pool.setAcquireRetryAttempts(3);
c3p0Pool.setMaxPoolSize(20);
c3p0Pool.setAcquireRetryDelay(1000); {code}
# All next queries are executed with this pool.
# Insert data into table with JDBC auto commit.
# Open transaction 1, disable auto commit.
# Open transaction 2, disable auto commit.
# Insert data using transaction 1, don't commit.
# Insert data using transaction 2, don't commit.
# Execute select query with new connection from connection pool to check the
data in DB equals the data before step 4.
*Expected:*
Data in steps 8 and 3 are equals.
*Actual:*
No data returned in select on step 8.
[^cluster_logs.zip]
*Additional info:*
It is not reproduced without connection pool.
Started to reproduce on snapshot builds since 28.12.2024.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
