Cannot drop table?

You need to lift the block on the related table, see https://crate.io/docs/crate/reference/en/4.4/sql/statements/create-table.html#blocks-read-only-allow-delete.

When a disk on a node exceeds the cluster.routing.allocation.disk.watermark.flood_stage threshold, this block is applied (set to true ) to all tables on that affected node. Once you’ve freed disk space again and the threshold is undershot, you need to set the blocks.read_only_allow_delete table setting to false .

3 Likes