org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException

tip

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.

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

  • GitHub comment 729#249481722
    via GitHub by njovy
    ,
  • GitHub comment 729#250366236
    via GitHub by njovy
    ,
  • Hikari connection Timeout Scala SBT 2.11
    via Stack Overflow by Lucas Soares
    ,
  • GitHub comment 418#141114687
    via GitHub by Shredder121
    ,
  • HikariCP - connection is not available
    via Stack Overflow by dfche
    ,
    • org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException: java.sql.SQLTransientConnectionException: generic-jdbc-query-executor - Connection is not available, request timed out after 27780ms. 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: generic-jdbc-query-executor - Connection is not available, request timed out after 27780ms. 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:73) at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) at org.skife.jdbi.v2.DBI.open(DBI.java:212) ... 23 more

    Users with the same issue

    balintn
    3 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    13 more bugmates