[
https://issues.apache.org/jira/browse/IGNITE-24159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17911042#comment-17911042
]
Igor commented on IGNITE-24159:
-------------------------------
[~v.pyatkov] in original code there was some chance it could take the other
node in step 8 to get a connection. Rewrote the code to take the same node
every time, the result is the same.
> 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, important
> Fix For: 3.0
>
> Attachments: cluster_logs.zip
>
>
> *Steps to reproduce:*
> 1. 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)
