/remind should retry and log after failure

[Zabuzard]

Problem

Our reminder system (/reminder create ...) sometimes fails to send the reminder. This is totally normal and can happen due to Discord/JDA hicups and whatever.

But, when it happens, we completely lose the message and it does not retry. That is a problem.

Fix

Instead, the system should just retry failed reminders (maybe 3 times), by putting them into the DB again with an Instant that is maybe set 1 minute into the future. If it ultimately failed, the log message should log the actual reminder-text and the target user, so that the reminder can be rerouted manually by an admin at least.

Details

For the failure count (~3 times), we likely need to add an additional column in the reminder DB table. Reminders are send from RemindRoutine.java, the table was initially created in V8__Add_Pending_Reminders.sql, the migration script V10__Alter_Top_Helper_Message_Length.sql shows how one can add a new column to an existing table.

[Paru-paru]

Hi, I would like to work on this issue.

[Taz03]

@Paru-paru sure, enjoy 😃

[Taz03]

whats the progress on this one? @Paru-paru

[Paru-paru]

Sorry about the absence, Ill get this done by this Friday and let you know if I can figure this one out.

[Zabuzard]

No worries. Thanks and good luck :)

[Paru-paru]

Couldnt figure it out, got busy with classes starting. If anyone wants to solve it thats fine with me, I just got classwork to focus for now before I can look at this again.

[Zabuzard]

Alrighty, thanks for trying though :)

[ankitsmt211]

I'd like to be assigned to this issue please.