Issue
- There are a large number of records on the
SamlSpSessiontable, which is causing issues with my upgrade.
Environment
- Portal 6.2
- DXP 7.2
- All DXP versions
Resolution
- Extra records can be removed using the attached groovy script (this script has been verified on Portal 6.2 and DXP 7.2, but it may run on other Liferay versions).
NOTE: Be sure to take a backup of your database prior to making any changes. Always test the changes in a lower environment before making changes in production.
Making manual changes to the database is not recommended, and should be carefully assessed based on your own business needs and risk factors. Any such operation is performed at the sole discretion of your own team.
Additional Information
- The large number of records is caused by the known issue LPS-60573: Records are not removed from
SamlSpSessiontable if the user closes the browser instead of logging out. -
This was fixed in SAML connector version 2.1.0 for Portal 6.2, but the extra records were not removed by the fix. This means that if you used an affected version of the SAML connector, the records remained on the
SamlSpSessiontable even after the issue was fixed. - While the extra records won't cause issues in normal circumstances, the large
SamlSpSessiontable can stall upgrades.