[
https://issues.apache.org/jira/browse/IGNITE-24159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor updated IGNITE-24159:
--------------------------
Description:
*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}
2. All next queries are executed with this pool.
3. Insert data into table with JDBC auto commit.
4. Open transaction 1, disable auto commit.
5. Open transaction 2, disable auto commit.
6. Insert data using transaction 1, don't commit.
7. Insert data using transaction 2, don't commit.
8. 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.
was:
*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.
> 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
> Priority: Blocker
> Labels: ignite-3
> 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}
> 2. All next queries are executed with this pool.
> 3. Insert data into table with JDBC auto commit.
> 4. Open transaction 1, disable auto commit.
> 5. Open transaction 2, disable auto commit.
> 6. Insert data using transaction 1, don't commit.
> 7. Insert data using transaction 2, don't commit.
> 8. 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)
