Cas v6.3.7, database errors

44 views
Skip to first unread message

Mathieu HETRU

unread,
Dec 9, 2021, 6:47:47 PM12/9/21
to cas-...@apereo.org

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

Reply all
Reply to author
Forward
0 new messages