Allow users to update the hard-delete time of a soft-deleted schema object

[stuartcarnie]

Summary

Unable to delete previously soft-deleted databases or tables.

• Error when attempting to delete a previously soft-deleted database: Delete command failed: server responded with error [409 Conflict]: attempted to delete resource that was already deleted
• No way to convert soft-deleted databases and tables to hard-deleted state
• Pre-3.2 soft-deleted databases don't have hard delete timestamps set

Information Schema queries

It is confusing to a user to continue showing hard-deleted tables in information_schema queries after the hard-delete date has expired.

This is due to the INFLUXDB3_DELETE_GRACE_PERIOD setting, which is 24 hours by default, at which point the table is completely removed from the catalog.

Proposed Solution

• Update DELETE API: Allow users to update the hard_delete_time of a database that has already been deleted
• Improve Log Messages: Update log output to display correctly and include the hard_delete_time information, when specified

[pauldix]

Yes, would be great to get this in for 3.2.1

[hiltontj]

@stuartcarnie do you know if this one can be closed out?

[stuartcarnie]

@hiltontj yes, this can be closed. I have converted the last item to an issue:

• Hide tables that have reached their hard-delete date from information_schema queries #26887