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.
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)
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.