Improve clean up stored procedures to remove expired data in IDN_AUTH_TEMP_SESSION_STORE

[Dinithi-Hasanika]

Current Limitation

In identity server 7.0.0, the session and temp data separation is enabled by default [1]. Because of this temporary authentication context data is inserted to IDN_AUTH_TEMP_SESSION_STORE. When using stored procedures for session data clean up [2], expired data in IDN_AUTH_TEMP_SESSION_STORE table is not removed. This leads to IDN_AUTH_TEMP_SESSION_STORE table to take unnecessary huge space.

[1] - wso2/carbon-identity-framework#5335
[2] - https://is.docs.wso2.com/en/latest/deploy/configure/databases/data-purging/

Suggested Improvement

it is required to improve the clean up stored procedures to remove expired data in IDN_AUTH_TEMP_SESSION_STORE table as well. This has been addressed for mysql[1]. Similarly this needs to be improved for other databases as well, for an example mssql [2].

[1] - wso2/carbon-identity-framework#4568
[2] - https://github.com/wso2/carbon-identity-framework/blob/master/features/identity-core/org.wso2.carbon.identity.core.server.feature/resources/dbscripts/stored-procedures/mssql/sessiondata-cleanup/mssql-session-data-cleanup.sql

Version

Identity server 7.0.0