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