s3Cluster Insert issue

[Appurv06]

I have created a new clickhouse cluster with 10 shards (2 replicas each) using Altinity provided Yamls. The clickhouse version I am currently using is the latest one 25.6.4.12. When I am trying to run insert statement using s3Cluster I am getting an error:

INSERT INTO test
SELECT *
FROM s3Cluster('db','s3_file/','Parquet')
SETTINGS
-- Parallel Processing Settings
max_insert_threads = 32,                    -- Utilize multiple CPU cores
max_threads = 32,                           -- Parallel reading threads
input_format_parallel_parsing=0,
parallel_distributed_insert_select = 2,
insert_distributed_timeout = 0              -- No timeout for distributed insert
;

Error: Code: 49. DB::Exception: Received request with invalid replica number 14, max possible replica number 9: While executing Remote. (LOGICAL_ERROR) (version 25.6.4.12 (official build))

The replica number changes every time I try to run the query. I have also checked the remote servers yaml and it looks fine.

I did run the below query to get all the shards and their replicas. All I see is 10 shards with 2 replicas each, so unsure why I am getting the above error while inserting with s3Cluster.

SELECT cluster, shard_num, shard_weight, replica_num, host_name, host_address, port, is_local FROM system.clusters ORDER BY cluster ASC, shard_num ASC, replica_num ASC;

Can someone please help on this issue?

[alex-zaitsev]

Is test table a distributed one for the same cluster 'db'?

[Appurv06]

Yes, Alexander.