Authentication service clean-up

The Authentication Service table is only populated when authsvc.stateMgmt.store is set to HVDB. When the clean-up is performed, rows are deleted when they expire.

Manual clean-up queries

To disable the out-of-the-box cleanup set authsvc.stateMgmt.HVDB.cleanupWait to 0. Select the rows to delete with:

SELECT STATE_ID as v1
FROM AUTH_SVC_SESSION_CACHE
WHERE EXPIRY < CURRENT_TIME_MILLIS

The CURRENT_TIME_MILLS variable must be populated. It is an integer representing the current time in miliseconds. Delete rows with:

DELETE FROM AUTH_SVC_SESSION_CACHE
WHERE STATE_ID = v1

where, v1 is the STATE_ID that is selected in the prior query.

Parent topic: Manual database clean-up