[ https://issues.apache.org/jira/browse/BEAM-7230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16841455#comment-16841455 ]
Ismaël Mejía commented on BEAM-7230: ------------------------------------ Great to know the singleton static idea works. I created a PR to improve the documentation for the case of PoolableDataSources. I also double checked the implementation of `PoolableDataSourceProvider`and it is doing exactly what it should so I think it should be an issue of configuration. I think we cannot fix that without an approach that adds tons of knobs so I am going to propose to deprecate that object and remove it in the future. Thanks a lot for all your help and feedback with this issue [~brachi_packter]. I am glad to know you don't need to fork JdbcIO now. > Using JdbcIO creates huge amount of connections > ----------------------------------------------- > > Key: BEAM-7230 > URL: https://issues.apache.org/jira/browse/BEAM-7230 > Project: Beam > Issue Type: Bug > Components: runner-dataflow > Affects Versions: 2.11.0 > Reporter: Brachi Packter > Assignee: Ismaël Mejía > Priority: Major > > I want to write form DataFlow to GCP cloud SQL, I'm using connection pool, > and still I see huge amount of connections in GCP SQL (4k while I set > connection pool to 300), and most of them in sleep. -- This message was sent by Atlassian JIRA (v7.6.3#76005)