You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
add a error_count field for the retry so we can have a backoff policy.
The query for selecting the ids of the mail to be sent will be something like select id from email_message where status in ('WAIT', 'RETRY') and request_ts < sysdate)
in case of error when sending the email, we set the request_ts in the future and increment the error_count and set the status to RETRY. The amount of minutes added from now depend of the number of error_count. If error_count is over a certain amount, the email status is marked as 'ERROR'.
The text was updated successfully, but these errors were encountered:
Currently the email queue has some shortcomings coming from a previous design that must be addressed:
Proposed design:
select id from email_message where status in ('WAIT', 'RETRY') and request_ts < sysdate)
The text was updated successfully, but these errors were encountered: