Issue
- Users aren't able to sign in to the Dashboard after a period of time.
- Blue circle spinning when attempting to sign in.
- Strange database errors in logs.
The Acrolinx Platform uses EclipseLink and database connection pooling under the hood. This setup automatically reconnects dropped database connections. And although our Core Platform is extremely resilient, sometimes, network issues can cause the database reconnect to fail and hang indefinitely or for long periods. This is extremely rare, and usually hints at a deeper problem on the network level, which needs to be solved.
Applies To
Product |
Version |
---|---|
Acrolinx Core Platform | All (On Premise Only) |
Solution
For the reporting and terminology databases, add the following to your JDBC connection string:
socketTimeout=10&connectTimeout=10&loginTimeout=10
For example:
reporting.jdbcUrl=jdbc:postgresql://postgres-server-url:5433/reporting?socketTimeout=10&connectTimeout=10&loginTimeout=10
The timeouts are in seconds and need to be adjusted to suit your specific requirements. This will lead to warnings in the Acrolinx log-files, which can safely be ignored. But it will improve the self-healing capabilities of the database connection pool.