org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException

java.sql.SQLTransientConnectionException: rakam@jdbc:postgresql://rakam-prod-rakam.chmo5weps9zn.us-east-1.rds.amazonaws.com:5432/rakam - Connection is not available, request timed out after 135328ms.

Samebug tips1

This might be cause due to an overload in your database accesses. Try to implement a queue or using an Executor to access the database server.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web9

  • java.sql.SQLTransientConnectionException: rakam@jdbc:postgresql://rakam-prod-rakam.chmo5weps9zn.us-east-1.rds.amazonaws.com:5432/rakam - Connection is not available, request timed out after 135328ms.
  • java.sql.SQLTransientConnectionException: generic-jdbc-query-executor - Connection is not available, request timed out after 27780ms.
  • via Stack Overflow by Unknown author, 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 129.21.208.42, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on
  • Stack trace

    • org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException: java.sql.SQLTransientConnectionException: rakam@jdbc:postgresql://rakam-prod-rakam.chmo5weps9zn.us-east-1.rds.amazonaws.com:5432/rakam - Connection is not available, request timed out after 135328ms. at org.skife.jdbi.v2.DBI.open(DBI.java:230) at org.rakam.ui.user.WebUserService.getUser(WebUserService.java:631) at org.rakam.ui.user.WebUserHttpService.me(WebUserHttpService.java:297) at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627) at org.rakam.server.http.JsonParametrizedRequestHandler.handleInternal(JsonParametrizedRequestHandler.java:126) at org.rakam.server.http.JsonParametrizedRequestHandler.handle(JsonParametrizedRequestHandler.java:93) at org.rakam.server.http.RouteMatcher.handle(RouteMatcher.java:59) at org.rakam.server.http.HttpServerHandler.channelRead(HttpServerHandler.java:75) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:318) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:304) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:276) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:263) at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:147) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:318) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:304) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:846) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:112) at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:137) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLTransientConnectionException: rakam@jdbc:postgresql://rakam-prod-rakam.chmo5weps9zn.us-east-1.rds.amazonaws.com:5432/rakam - Connection is not available, request timed out after 135328ms. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:548) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:145) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:83) at org.rakam.analysis.JDBCPoolDataSource.getConnection(JDBCPoolDataSource.java:79) at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) at org.skife.jdbi.v2.DBI.open(DBI.java:212) ... 23 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    4 times, 4 weeks ago
    3 times, 6 months ago
    Unknown user
    Once, 17 hours ago
    Unknown user
    Once, 17 hours ago
    Unknown user
    Once, 17 hours ago
    27 more bugmates