I have only 1 instance but getting a replication_num table error since the default of 3 is wrong

am getting following error on
database.go:1162 ExecContext —
Error 1064: Unexpected exception: Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10004]. , table=orders_tmp, default_replication_num=3
(venv) soumilshah@Soumils-MB

1 Like

Run on the starrocks server to set the server variable.

ADMIN SET FRONTEND CONFIG ('default_replication_num' ="1");

or set it on table create.

create table xxx (id int) properties('replication_num' = '1')
1 Like

Thanks this has helped to to solve my issue

Thanks Albert