[jira] [Issue Comment Deleted] (FLINK-23437) Connection leak in XaFacadePoolingImpl

["Roman Khachatryan (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-23437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Roman Khachatryan updated FLINK-23437:
--------------------------------------
    Comment: was deleted

(was: Thanks for reporting,

could you confirm that "oracle.net.ns.NetException: Got minus one from a read call" is indeed caused by too many connections (maybe from db sessions view/logs)?

And what are the the degree of parallelism (for sink), connection limit, and the actual number of connections if you know it?)

> Connection leak in XaFacadePoolingImpl
> --------------------------------------
>
>                 Key: FLINK-23437
>                 URL: https://issues.apache.org/jira/browse/FLINK-23437
>             Project: Flink
>          Issue Type: Bug
>          Components: Connectors / JDBC
>    Affects Versions: 1.13.1
>            Reporter: Maciej Bryński
>            Priority: Major
>
> Hi,
> I'm using JDBC XA connector to put data into Oracle database.
> I'm facing issue with too many concurrent connection to database.
> I changed this method to return XaFacadeImpl instead of XaFacadePoolingImpl and problem was solved.
> {code:java}
> static XaFacade fromXaDataSourceSupplier(
>         Supplier<XADataSource> dataSourceSupplier, Integer timeoutSec) {
>     return new XaFacadePoolingImpl(() -> new XaFacadeImpl(dataSourceSupplier, timeoutSec));
> }
> {code}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)