Shibboleth IdP freezing issue

[Feinstein, Moses]

Hi

Lately, we have been experiencing Shibboleth IdP freezing which  required a restart.

These are two primary errors that keeps showing up. Any insights would be very helpful. Thanks.

2020-10-19 08:09:23,179 - ERROR [org.springframework.webflow.execution.repository.NoSuchFlowExecutionException:76] -
org.springframework.webflow.execution.repository.NoSuchFlowExecutionException: No flow execution could be found with key 'e1s2' -- perhaps this executing flow has ended or expired? This could happen if your users are relying on browser history (typically via the back button) that references ended flows.
               at org.springframework.webflow.execution.repository.support.AbstractFlowExecutionRepository.getConversation(AbstractFlowExecutionRepository.java:172)
Caused by: org.springframework.webflow.conversation.NoSuchConversationException: No conversation could be found with id '1' -- perhaps this conversation has ended?
               at org.springframework.webflow.conversation.impl.ConversationContainer.getConversation(ConversationContainer.java:126)



When we check SQL we don't see any dead locks, so it's not clear why IdP is not able to read it.

2020-10-19 08:08:21,849 - ERROR [net.shibboleth.idp.session.impl.UpdateSessionWithAuthenticationResult:178] - Profile Action UpdateSessionWithAuthenticationResult: Error creating session for principal testUser
net.shibboleth.idp.session.SessionException: Exception while storing new session
               at net.shibboleth.idp.session.impl.StorageBackedSessionManager.createSession(StorageBackedSessionManager.java:530)
Caused by: java.io.IOException: javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not load an entity: [org.opensaml.storage.impl.JPAStorageRecord#component[context,key]{context=7ca527826ca73f106622f100e12a77b768956acbbf0d76a17075d6f9fd070143, key=_session}]
               at org.opensaml.storage.impl.JPAStorageService.create(JPAStorageService.java:182)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not load an entity: [org.opensaml.storage.impl.JPAStorageRecord#component[context,key]{context=7ca527826ca73f106622f100e12a77b768956acbbf0d76a17075d6f9fd070143, key=_session}]
               at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
Caused by: org.hibernate.exception.LockAcquisitionException: could not load an entity: [org.opensaml.storage.impl.JPAStorageRecord#component[context,key]{context=7ca527826ca73f106622f100e12a77b768956acbbf0d76a17075d6f9fd070143, key=_session}]
               at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:140)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 112) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
               at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)




Moses Feinstein


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20201021/d3d37970/attachment.htm>