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
You can enable writes by using ALTER TABLE ... SET ("blocks.read_only_allow_delete" = FALSE), see our allocation setting docs for more information.
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
Hi. While working on GitHub - crate/mlflow-cratedb: MLflow adapter for CrateDB. · GitHub, 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.
