crashing IdP db connection

[John Morrison]

Hi all,

We have a problem with CAS in IdP v3.2 and some IIS sites crashing the
db (mysql) connection due to some URL session change. When session is
created by https://www.someurl.com/Default.aspx then changing to https:
//www.someurl.com/default.aspx with the same session id.

Causing some sort of problem with the db and then crashing the tomcat
instance.

Any idea why?

See logs below.

2017-04-01 11:14:21,043 - ERROR
[org.opensaml.storage.impl.JPAStorageService:188] - Error committing
transaction
javax.persistence.RollbackException: Error while committing the
transaction
	at
org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:
94)
Caused by: javax.persistence.PersistenceException:
org.hibernate.HibernateException: identifier of an instance of
org.opensaml.storage.impl.JPAStorageRecord was altered from
69a3f9634b91ef06e65040b94b9f338918477c04fda037dbcc9f
df99c6174ee9:https://www.someurl.com/Default.aspx to
69a3f9634b91ef06e65040b94b9f338918477c04fda037dbcc9fdf99c6174ee9:https:
//www.someurl.com/default.aspx
	at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityM
anagerImpl.java:1763)
Caused by: org.hibernate.HibernateException: identifier of an instance
of org.opensaml.storage.impl.JPAStorageRecord was altered from
69a3f9634b91ef06e65040b94b9f338918477c04fda037dbcc9fdf99c6174ee9:https:
//www.someurl.com/Def
ault.aspx to
69a3f9634b91ef06e65040b94b9f338918477c04fda037dbcc9fdf99c6174ee9:https:
//www.someurl.com/default.aspx
	at
org.hibernate.event.internal.DefaultFlushEntityEventListener.checkId(De
faultFlushEntityEventListener.java:80)
2017-04-01 11:14:22,797 - INFO
[net.shibboleth.idp.authn.impl.ValidateUsernamePasswordAgainstLDAP:152]
- Profile Action ValidateUsernamePasswordAgainstLDAP: Login by 'user'
succeeded
2017-04-01 11:14:51,046 - ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper:146] - HikariPool-1 -
Connection is not available, request timed out after 30000ms.
2017-04-01 11:14:51,049 - ERROR
[org.opensaml.storage.impl.JPAStorageService:454] - Error updating
record 'https://www.someurl.com/Default.aspx' in context
'69a3f9634b91ef06e65040b94b9f338918477c04fda037dbcc9fdf99c6174ee9'
javax.persistence.PersistenceException:
org.hibernate.exception.JDBCConnectionException: Could not open
connection
	at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityM
anagerImpl.java:1763)
Caused by: org.hibernate.exception.JDBCConnectionException: Could not
open connection
	at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLEx
ceptionTypeDelegate.java:65)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 -
Connection is not available, request timed out after 30000ms.
	at
com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.jav
a:591)
2017-04-01 11:14:51,052 - ERROR
[net.shibboleth.idp.session.impl.StorageBackedIdPSession:700] -
OPException saving SPSession for service https://www.someurl.com/Defaul
t.aspx to storage
java.io.IOException: javax.persistence.PersistenceException:
org.hibernate.exception.JDBCConnectionException: Could not open
connection
	at
org.opensaml.storage.impl.JPAStorageService.updateImpl(JPAStorageServic
e.java:462)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.JDBCConnectionException: Could not open
connection
	at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityM
anagerImpl.java:1763)
Caused by: org.hibernate.exception.JDBCConnectionException: Could not
open connection
	at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLEx
ceptionTypeDelegate.java:65)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 -
Connection is not available, request timed out after 30000ms.
	at
com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.jav
a:591)
2017-04-01 11:14:51,054 - ERROR
[net.shibboleth.idp.session.impl.StorageBackedIdPSession:425] -
Exception saving SPSession record for IdP session
69a3f9634b91ef06e65040b94b9f338918477c04fda037dbcc9fdf99c6174ee9 and
service htt
ps://www.someurl.com/Default.aspx
java.io.IOException: javax.persistence.PersistenceException:
org.hibernate.exception.JDBCConnectionException: Could not open
connection
	at
org.opensaml.storage.impl.JPAStorageService.updateImpl(JPAStorageServic
e.java:462)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.JDBCConnectionException: Could not open
connection
	at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityM
anagerImpl.java:1763)
Caused by: org.hibernate.exception.JDBCConnectionException: Could not
open connection
	at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLEx
ceptionTypeDelegate.java:65)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 -
Connection is not available, request timed out after 30000ms.
	at
com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.jav
a:591)
2017-04-01 11:14:51,571 - INFO
[net.shibboleth.idp.authn.impl.ValidateUsernamePasswordAgainstLDAP:152]
- Profile Action ValidateUsernamePasswordAgainstLDAP: Login by 'user'
succeeded
2017-04-01 11:14:52,844 - ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper:146] - HikariPool-1 -
Connection is not available, request timed out after 30000ms.
2017-04-01 11:14:52,850 - ERROR
[org.opensaml.storage.impl.JPAStorageService:180] - Error creating
record '_session' in context
'179951543f0ebb9379ac971bf84902f7647c4159d743a4d849d6c046d04b9684' with
expiration '1491153262844'
javax.persistence.PersistenceException:
org.hibernate.exception.JDBCConnectionException: Could not open
connection
	at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityM
anagerImpl.java:1763)
Caused by: org.hibernate.exception.JDBCConnectionException: Could not
open connection
	at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLEx
ceptionTypeDelegate.java:65)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 -
Connection is not available, request timed out after 30000ms.
	at
com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.jav
a:591)
2017-04-01 11:14:52,855 - ERROR
[net.shibboleth.idp.session.impl.StorageBackedSessionManager:527] -
Exception while storing new session for principal joca7735
java.io.IOException: javax.persistence.PersistenceException:
org.hibernate.exception.JDBCConnectionException: Could not open
connection
	at
org.opensaml.storage.impl.JPAStorageService.create(JPAStorageService.ja
va:182)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.JDBCConnectionException: Could not open
connection
	at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityM
anagerImpl.java:1763)
Caused by: org.hibernate.exception.JDBCConnectionException: Could not
open connection
	at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLEx
ceptionTypeDelegate.java:65)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 -
Connection is not available, request timed out after 30000ms.