Cannot drop table?

CrateDB
1

When trying to drop any table, I get this error in crash/adminui:

ClusterBlockException[blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];]

I can’t find anything about cratedb and this error, just elasticsearch. And yes, one of the nodes did get to 96% full disk. But it is now resolved (currently at 75% full) and crate restarted. Not sure how to proceed.

Advice?

2

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
3

Thanks. ALTER TABLE done.

2 Likes