Got an error XX000: blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];

I got an error

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

while insert the data into crate db

It seems like you ran into a disk watermark/threshold that prevents any writes to tables until you free up space and manually allow writes again on that table.

1 Like

if the issue occurred, that table can’t use after maximum size reached.
use below command to reuse it again

ALTER TABLE SET (“blocks.read_only_allow_delete” = FALSE)

1 Like

Dear @testjob_tyu,

I also wanted to let you know that I compiled some information about this topic recently, see "Flood stage disk watermark [95%] exceeded" happens quickly when running on Docker · Issue #11458 · crate/crate · GitHub.

It might specifically help you if you are running CrateDB on Docker for evaluation purposes.

With kind regards,
Andreas.

1 Like