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
• Update schema queries: Hide tables that have reached their hard-delete date from information_schema queries.