Skip to content

No connection available #5

@msteiger

Description

@msteiger

The server list retrieval failed after 3 months of successful operation due to missing connections in the Hikari pool:

2016-01-10 20:29:35.129 [Thread-1190] INFO  o.t.web.model.ModuleListModelImpl - Would delete engine-tests-0.54.5-20151212.064209-26.jar_info.json
2016-01-10 20:30:39.883 [qtp1348453796-19] INFO  o.t.web.servlet.ModuleServlet - Requested lastest info as json
2016-01-10 20:37:32.796 [qtp1348453796-14] INFO  o.t.web.servlet.ModuleServlet - Requested lastest info as json
2016-01-10 20:39:32.391 [qtp1348453796-14] INFO  o.t.web.servlet.ModuleServlet - Requested lastest info as json
2016-01-10 20:46:51.698 [qtp1348453796-19] INFO  o.t.web.servlet.ModuleServlet - Requested lastest info as json
2016-01-10 20:52:36.425 [qtp1348453796-15] INFO  o.t.web.servlet.ServerServlet - Requested server list
2016-01-10 20:53:06.429 [qtp1348453796-15] ERROR o.t.web.servlet.ServerServlet - Could not connect to database
java.io.IOException: java.sql.SQLTransientConnectionException: HikariPool-0 - Connection is not available, request timed out after 30000ms.
    at org.terasology.web.model.ServerListModelImpl.getServers(ServerListModelImpl.java:72) ~[main/:na]
    at org.terasology.web.servlet.ServerServlet.list(ServerServlet.java:113) ~[main/:na]

As I understand it, Hikari refreshes all connections after a few minutes, but it still broke and it does not recover.

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/29752385-no-connection-available?utm_campaign=plugin&utm_content=tracker%2F13452641&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F13452641&utm_medium=issues&utm_source=github).

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions