Eugene Klimov
Eugene Klimov
@oplehto when use UInt64, shall we define how many right pad digits will use for fractional seconds? or just need to define 3 right digits always and use is as...
We are open to pull requests, this is hard to debug keeperTeardown.sh
@akshayparseja which clickhouse-backup version do you use? how did you create users via SQL or via YAML / XML?
> Also the users i am trying to migrate were created via the yaml of clickhouseinstallation Is your destination clickhouse cluster also managed by `clickhouse-operator`?
In this case, clickhouse-backup allows only restore data. You need just copy / paste YAML users definition from source `kind: ClickHouseInstallation` to destination `kind: ClickHouseInstallation` manifest
`--rbac` and `--rbac-only` applicable only for SQL created RBAC objects, not for YAML Which command you executed? `restore_remote --rbac-only`? or `download` + `restore --rbac-only` ? you need to `create_remote --rbac-only`...
you didn't read my comments --rbac-only will not applicable for your use case, cause you create users via `.spec.users` about 660gb look https://github.com/Altinity/clickhouse-backup/issues/1042
try to use `create_remote --rbac-only` + `restore_remote --rbac-only`
> Attempt to use admin user to modify permissions but this fails > ```sql > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, DROP TABLE, ALTER TABLE, > SHOW TABLES, SHOW...
could you try ``` veronica/grants: - SHOW DATABASES,SELECT,INSERT,ALTER,CREATE TABLE,DROP TABLE,TRUNCATE,OPTIMIZE ON pantry_assistant.* ``` and check ``` kubectl exec -it chi-ck3-replicated-0-0-0 -n ck -- clickhouse-client --user veronica --password xxxxx SELECT currentUser(),...