症状

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

診断

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

原因

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 is to switch to in-memory session storage:

Session Configuration