Skip to content

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

@stuartcarnie

Description

@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

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions