# SQLActionException on Crate DB

**URL:** <https://community.cratedb.com/t/sqlactionexception-on-crate-db/76>\
**Category:** CrateDB\
**Created:** [November 27, 2018, 12:20pm UTC](https://community.cratedb.com/t/sqlactionexception-on-crate-db/76 "2018-11-27T12:20:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![roman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/roman/32/36_2.png) [@roman](https://community.cratedb.com/u/roman)\
**Post date:** [November 27, 2018, 12:20pm UTC](https://community.cratedb.com/t/sqlactionexception-on-crate-db/76/1 "2018-11-27T12:20:59Z")

</div>

Hi, quick question: I had to add drives to my cluster after it filled up. There is plenty of storage on all nodes now, and the cluster and node checks are all passing, but I get the following when I try to insert anything: SQLActionException[ClusterBlockException: blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];] Is there something I need to reset this or some restoration step I have likely missed?

---

<div class="post-metadata">

**Author:** ![yash](https://avatars.discourse-cdn.com/v4/letter/y/f17d59/32.png) [@yash](https://community.cratedb.com/u/yash)\
**Post date:** [November 27, 2018, 1:53pm UTC](https://community.cratedb.com/t/sqlactionexception-on-crate-db/76/2 "2018-11-27T13:53:56Z")

</div>

Seems like some `blocks` are set on the table, see [https://crate.io/docs/crate/reference/en/latest/sql/statements/create-table.html#blocks-read-only-allow-delete](https://crate.io/docs/crate/reference/en/latest/sql/statements/create-table.html#blocks-read-only-allow-delete). Check the settings of your table and reset them should help.

---

<div class="post-metadata">

**Author:** ![sambhav](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/sambhav/32/293_2.png) [@sambhav](https://community.cratedb.com/u/sambhav)\
**Post date:** [February 4, 2020, 8:40am UTC](https://community.cratedb.com/t/sqlactionexception-on-crate-db/76/3 "2020-02-04T08:40:00Z")

</div>

`ALTER TABLE <tablename> SET ("blocks.read_only_allow_delete" = FALSE)`

Run this command for all those tables where blocks.read\_only\_allow\_delete = TRUE ( To check it run `SHOW CREATE TABLE <TABLENAME>` )