Symptoms

After enabling Crowd SSO, JIRA and Confluence Page Load Times become extremely high.

Diagnosis

Crowd SSO is connected to Bamboo, Stash, and FeCru but only JIRA and Confluence is affected.

Cause

Locks on the cwd_token table are not being released back to the pool. Related bug repots:

CWD-3692 - Crowd freezes under heavy load RESOLVED  

CWD-3688 - Transaction errors due to cwd_token constraint violation RESOLVED   

Workaround

Workaround is to switch to in-memory session storage:

Session Configuration