# Cannot drop table?

**URL:** <https://community.cratedb.com/t/cannot-drop-table/609>\
**Category:** CrateDB\
**Created:** [April 1, 2021, 6:12am UTC](https://community.cratedb.com/t/cannot-drop-table/609 "2021-04-01T06:12:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sampope](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@sampope](https://community.cratedb.com/u/sampope)\
**Post date:** [April 1, 2021, 6:12am UTC](https://community.cratedb.com/t/cannot-drop-table/609/1 "2021-04-01T06:12:21Z")

</div>

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

```auto
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?

---

<div class="post-metadata">

**Author:** ![smu](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/smu/32/60_2.png) [@smu](https://community.cratedb.com/u/smu)\
**Post date:** [April 1, 2021, 7:33am UTC](https://community.cratedb.com/t/cannot-drop-table/609/2 "2021-04-01T07:33:29Z")

</div>

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](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` .

---

<div class="post-metadata">

**Author:** ![sampope](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@sampope](https://community.cratedb.com/u/sampope)\
**Post date:** [April 1, 2021, 6:19pm UTC](https://community.cratedb.com/t/cannot-drop-table/609/3 "2021-04-01T18:19:39Z")

</div>

Thanks. ALTER TABLE done.