Hi, quick question: I had to add drives to my cluster after it filled up. There is plenty of storage on all nodes now, and the cluster and node checks are all passing, but I get the following when I try to insert anything: SQLActionException[ClusterBlockException: blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];] Is there something I need to reset this or some restoration step I have likely missed?
Seems like some
blocks are set on the table, see https://crate.io/docs/crate/reference/en/latest/sql/statements/create-table.html#blocks-read-only-allow-delete. Check the settings of your table and reset them should help.
ALTER TABLE <tablename> SET ("blocks.read_only_allow_delete" = FALSE)
Run this command for all those tables where blocks.read_only_allow_delete = TRUE ( To check it run
SHOW CREATE TABLE <TABLENAME> )