# Node in read-only mode after low diskspace

**URL:** <https://community.cratedb.com/t/node-in-read-only-mode-after-low-diskspace/166>\
**Category:** CrateDB\
**Created:** [March 5, 2019, 12:35pm UTC](https://community.cratedb.com/t/node-in-read-only-mode-after-low-diskspace/166 "2019-03-05T12:35:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![web64](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/web64/32/85_2.png) [@web64](https://community.cratedb.com/u/web64)\
**Post date:** [March 5, 2019, 12:35pm UTC](https://community.cratedb.com/t/node-in-read-only-mode-after-low-diskspace/166/1 "2019-03-05T12:35:33Z")

</div>

Hi,

The machine was using over 90% diskspace and the cratedb note went into read-only mode.  
I deleted lots of files and the server has now over 30% of available space.  
The cratedb node was restarted, everything is green in the admin console but it is still in read-only mode.

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

How can I enable writes again?

CrateDB version: 3.1.4

---

<div class="post-metadata">

**Author:** ![mfussenegger](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/mfussenegger/32/79_2.png) [@mfussenegger](https://community.cratedb.com/u/mfussenegger)\
**Post date:** [March 5, 2019, 5:16pm UTC](https://community.cratedb.com/t/node-in-read-only-mode-after-low-diskspace/166/2 "2019-03-05T17:16:09Z")

</div>

You can enable writes by using `ALTER TABLE ... SET ("blocks.read_only_allow_delete" = FALSE)`, see our [allocation setting docs](https://crate.io/docs/crate/reference/en/latest/config/cluster.html?highlight=blocks%20read_only_allow_delete#disk-based-shard-allocation) for more information.

---

<div class="post-metadata">

**Author:** ![web64](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/web64/32/85_2.png) [@web64](https://community.cratedb.com/u/web64)\
**Post date:** [March 5, 2019, 5:52pm UTC](https://community.cratedb.com/t/node-in-read-only-mode-after-low-diskspace/166/3 "2019-03-05T17:52:17Z")

</div>

Thank you that worked!

It would be great if the node could detect that disk space is below the threshold again and automatically make the node writable, instead of having to manually update each table.

Cheers,  
Olav

---

<div class="post-metadata">

**Author:** ![amotl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/amotl/32/617_2.png) [@amotl](https://community.cratedb.com/u/amotl)\
**Post date:** [March 31, 2026, 1:48am UTC](https://community.cratedb.com/t/node-in-read-only-mode-after-low-diskspace/166/4 "2026-03-31T01:48:04Z")

</div>

Hi. While working on [GitHub - crate/mlflow-cratedb: MLflow adapter for CrateDB. · GitHub](https://github.com/crate/mlflow-cratedb), I found myself in the same situation that would require recovering from a watermark-blocked state with a number of tables where doing it manually is tedious.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/crate/original/2X/7/755813fac62d74de4ead59699f3fede6955e71ce.png)
