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 [email protected].
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