Creating user on cluster with read-only profile fails #15628
Description
When I try to create a user with the existing readonly profile using a DDL query, it fails giving me that the setting profile does not exist, even though it exists on all the replicas.
However, I can successfully create the user manually on each replica.
CREATE USER IF NOT EXISTS my_user ON CLUSTER clickhouse_cluster IDENTIFIED WITH plaintext_password BY 'XXXX' HOST ANY SETTINGS PROFILE readonly
┌─host──────────────────────────────┬─port─┬─status─┬─error───────────────────────────────────────────────────────────────────────────────────────────────────┬─num_hosts_remaining─┬─num_hosts_active─┐
│ ch-01-01-1.my-domain.com │ 9000 │ 115 │ Code: 115, e.displayText() = DB::Exception: Unknown setting PROFILE (version 20.8.2.3 (official build)) │ 1 │ 0 │
│ ch-01-01-2.my-domain.com │ 9000 │ 115 │ Code: 115, e.displayText() = DB::Exception: Unknown setting PROFILE (version 20.8.2.3 (official build)) │ 0 │ 0 │
└───────────────────────────────────┴──────┴────────┴─────────────────────────────────────────────────────────────────────────────────────────────────────────┴─────────────────────┴──────────────────┘
↓ Progress: 28.00 rows, 5.04 KB (23.36 rows/s., 4.20 KB/s.) ██████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████▍ 92%
Received exception from server (version 20.8.2):
Code: 115. DB::Exception: Received from localhost:9000. DB::Exception: There was an error on [ch-01-01-3.my-domain.com:9000]: Code: 115, e.displayText() = DB::Exception: Unknown setting PROFILE (version 20.8.2.3 (official build)).