[jira] [Commented] (NIFI-10908) Weird JDBC Connection Closed Error

["David Handermann (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/NIFI-10908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641359#comment-17641359 ] 

David Handermann commented on NIFI-10908:
-----------------------------------------

Thanks for reporting this issue [~cemremengu].

Can you provide some additional details on the configuration? It would be helpful to know the database server used, including the exact version of the JDBC driver. It would also be helpful to know all of the properties configured in HikariCPConnectionPool, in particular the Max Connection Lifetime and Minimum Idle Connections. A Validation Query may also be useful if not already configured.

> Weird JDBC Connection Closed Error
> ----------------------------------
>
>                 Key: NIFI-10908
>                 URL: https://issues.apache.org/jira/browse/NIFI-10908
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Core Framework
>    Affects Versions: 1.16.3
>            Reporter: Cemre Mengu
>            Priority: Critical
>         Attachments: image-2022-11-30-16-38-53-210.png
>
>
> Using hikari connection pool, I am getting weird `connection is closed` error for a flow during sql updates. There is nothing wrong with the data or query as far as I can see so I am confused why I am getting this error. I have many flows but the only one with the error is this one.
> Any ideas what can be causing this error?
> !image-2022-11-30-16-38-53-210.png!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)