Payload Retention Period not working as expected

[navdeepgsp]

Bug Report

Payload retention period not working

Version

Svix-server image version 1.65.0

Platform

docker image

Description

I am using svix-server docker image version 1.65.0 and calling svix create message api.
In this POST API request body, I am passing payloadRetentionPeriod=14. This retention period is reflected in message table and not in messagecontent table.

Actual result:

message table contains an entry where expiration is created based on value passed in request i.e. today+14 days
messagecontent table still uses default value 90 days and expiration is created using default value i.e. today + 90 days
payload records from messagecontent records are deleted which are older than 90 days

Expected result:

messagecontent table should use retention period passed in request i.e 14 days and expiration should be created using value in request i.e. today + 14 days
payload records from messagecontent table should be deleted which are older than 14 days

[tasn]

Thanks for the report!

[navdeepgsp]

Hi @tasn , @svix-jplatte
Till the time we get fix for this issue, We are trying to delete data manually as our DB storage is quite high due to large payload size.
When we delete data older than 14 days, query hangs. Initially we used cascade delete and deleted data from message table which would eventually delete from messageattempt and messagedestination as well however query hangs. Even for one single message id query keeps on running for minutes
Later, we deleted data from all 3 tables separately but query still take huge time and hangs.
What approach we can use as workaround to delete data from message, messageattempt, messagedestination, messagecontent tables.

[tasn]

This has now been fixed and will be included in the next release. Thanks @svix-james!