I finally figured out why some database session storage don’t get purged
Turns out as configured and due to the nature of how application scopes work, Lucee currently will only purge the cf_session_data table hourly, if the datasource is configured in the admin, so just go and a datasource pointing to that schema with the storage flag set and Lucee will purge the expired sessions.
It’s a bit more complicated architecturally to address this (Application configs are per request, only the application scope is shared)
but in the meantime, this is a good workaround
https://luceeserver.atlassian.net/browse/LDEV-4846?focusedCommentId=59524