Temp data cleanup

Noticed that there's a lot of stuff being left in SX_STORAGE_ITEMS table. There is no automatic clean-up.

Can you add such auto-clean-up into the next release?

Or document what and how can or should be cleaned up?

1 Like

Such table is only to temporarily save an authentication flow. You can safely delete the records there. Even if you delete all the records, worse case you would have some current users failing in their authentication process. If they start again, it will work.

But to be safe, you can delete records which are expired before a specified date, for example:

DELETE FROM sx_storage_items WHERE expiration < '2024-07-03 23:59:59.999'