menakaprabu

Hi, Were you able to resolve the above "Connection closed" exception? I am getting the same problem. Please let me know the solution if you got to know? Thank you!

Hi @mp911de , Thanks for finding the root cause and posting it. I am getting the same issue "org.springframework.dao.DataAccessResourceFailureException: Failed to obtain R2DBC Connection nested exception is io.r2dbc.spi.R2dbcNonTransientResourceException: Connection validation...

Hi Mark, Thanks for the response. Here are more logs. at io.r2dbc.pool.Validation.lambda$validate$2(Validation.java:45) ~[r2dbc-pool-1.0.0.RELEASE.jar!/:1.0.0.RELEASE]","" *"4/9/2024, 3:57:10.276 PM","Caused by: io.r2dbc.spi.R2dbcNonTransientResourceException: Connection validation failed",""* .... .... at org.springframework.r2dbc.connection.ConnectionFactoryUtils.lambda$getConnection$0(ConnectionFactoryUtils.java:100) ~[spring-r2dbc-6.1.1.jar!/:6.1.1]","" *"Caused by: org.springframework.dao.DataAccessResourceFailureException: Failed...

Here is my configuration. poolInitialSize=10 poolMaxSize=30 maxIdleTime=60 mins (1hr) -Thanks On Wed, Apr 10, 2024 at 12:26 AM MBec ***@***.***> wrote: > Maybe I will add more information, because I'm...

Hi @mp911de , Do you have any update for me. This issue is acting like a blocker, please let me know if you need more details from me. -Thanks.

Hi Mark, Any suggestion, I tried with maxIdle from 60 mins to 10 mins but still I see the issue. We are struggling with this issue in the production environment....

Hi @CennyMo , We are getting this issue when database is normal. We are having below config. poolInitialSize=10 poolMaxSize=30 maxIdleTime=60 mins (1hr) I don't have maxLifeTime and minIdle set.