Hello,

We have installed at my university uLille at Monday 6 December the cas server 
v6.3.7,

But recently we have theses errors :

> Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire 
> JDBC Connection
> Caused by: java.sql.SQLTransientConnectionException: HikariPool-2 - 
> Connection is not available, request timed out after 30000ms.

At pool settings in cas.properties for jpa service registry we have :
> cas.service-registry.jpa.user=cas6
> cas.service-registry.jpa.password=*****************
> cas.service-registry.jpa.driver-class=org.mariadb.jdbc.Driver
> cas.service-registry.jpa.url=jdbc:mysql://mysql56-1.univ-lille.fr/cas6?autoReconnect=true
> cas.service-registry.jpa.dialect=org.hibernate.dialect.MariaDB10Dialect
> cas.service-registry.jpa.health-query=select 1
> cas.service-registry.jpa.batch-size=10
> cas.service-registry.jpa.autocommit=false
> cas.service-registry.jpa.idle-timeout=PT10M
> cas.service-registry.jpa.autocommit=false
> cas.service-registry.jpa.pool.suspension=false
> cas.service-registry.jpa.pool.min-size=6
> cas.service-registry.jpa.pool.max-size=18
> cas.service-registry.jpa.pool.max-wait=PT2S
> cas.service-registry.jpa.pool.timeout-millis=1000

Perhaps it is PT10M or PT2S ?
Thanks for your help

Best regards,

Mathieu HETRU

-- 
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
--- 
You received this message because you are subscribed to the Google Groups "CAS 
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/F230CA97-0931-4E2B-AC3D-4350A452C32B%40gmail.com.

Reply via email to