docker run --rm -it --network=host -e CLICKHOUSE_HOST="172.17.69.13" -e CLICKHOUSE_PORT="9000" -e CLICKHOUSE_USERNAME="admin" -e CLICKHOUSE_PASSWORD="admin_password" -e LOG_LEVEL="debug" -v /mnt2/ch/clickhouse_data:/var/lib/clickhouse altinity/clickhouse-backup:2.8.0 clickhouse-backup create test_backup -s
2026-09-09 23:48:09.959 INF pkg/clickhouse/clickhouse.go:165 > clickhouse connection success: tcp://172.17.69.13:9000
2026-09-09 23:48:09.959 INF pkg/clickhouse/clickhouse.go:1272 > SELECT value FROM `system`.`build_options` where name='VERSION_INTEGER'
2026-09-09 23:48:09.964 INF pkg/clickhouse/clickhouse.go:1272 > SELECT data_path AS metadata_path FROM system.databases WHERE name = 'system' LIMIT 1
2026-09-09 23:48:09.967 INF pkg/clickhouse/clickhouse.go:1272 > SELECT name, engine FROM system.databases WHERE NOT match(name,'^(system|INFORMATION_SCHEMA|information_schema|_temporary_and_external_tables)$')
2026-09-09 23:48:09.972 INF pkg/clickhouse/clickhouse.go:1272 > SHOW CREATE DATABASE `default`
2026-09-09 23:48:09.973 INF pkg/clickhouse/clickhouse.go:1272 > SHOW CREATE DATABASE `test_ha`
2026-09-09 23:48:09.975 INF pkg/clickhouse/clickhouse.go:1270 > SELECT name, count(*) as is_present FROM system.settings WHERE name IN (?, ?) GROUP BY name with args []interface {}{"show_table_uuid_in_table_create_query_if_not_nil", "display_secrets_in_show_and_select"}
2026-09-09 23:48:09.983 INF pkg/clickhouse/clickhouse.go:1272 > SELECT name FROM system.databases WHERE engine IN ('DataLakeCatalog','MySQL','PostgreSQL','MaterializedPostgreSQL')
2026-09-09 23:48:09.985 INF pkg/clickhouse/clickhouse.go:1272 > SELECT countIf(name='data_path') is_data_path_present, countIf(name='data_paths') is_data_paths_present, countIf(name='uuid') is_uuid_present, countIf(name='create_table_query') is_create_table_query_present, countIf(name='total_bytes') is_total_bytes_present FROM system.columns WHERE database='system' AND table='tables'
2026-09-09 23:48:09.990 INF pkg/clickhouse/clickhouse.go:1272 > SELECT database, name, engine , data_paths , uuid , create_table_query , coalesce(total_bytes, 0) AS total_bytes FROM system.tables WHERE is_temporary = 0 ORDER BY total_bytes DESC SETTINGS show_table_uuid_in_table_create_query_if_not_nil=1
2026-09-09 23:48:10.055 INF pkg/clickhouse/clickhouse.go:1272 > SELECT data_path AS metadata_path FROM system.databases WHERE name = 'system' LIMIT 1
2026-09-09 23:48:10.060 INF pkg/clickhouse/clickhouse.go:1272 > SELECT count() as cnt FROM system.columns WHERE database='system' AND table='functions' AND name='create_query' SETTINGS empty_result_for_aggregation_by_empty_set=0
2026-09-09 23:48:10.065 INF pkg/clickhouse/clickhouse.go:1272 > SELECT name, create_query FROM system.functions WHERE create_query!=''
2026-09-09 23:48:10.083 INF pkg/clickhouse/clickhouse.go:1272 > SELECT countIf(name='type') AS is_disk_type_present, countIf(name='object_storage_type') AS is_object_storage_type_present, countIf(name='free_space') AS is_free_space_present, countIf(name='disks') AS is_storage_policy_present, countIf(name='cache_path') AS is_cache_path_present FROM system.columns WHERE database='system' AND table IN ('disks','storage_policies')
2026-09-09 23:48:10.090 INF pkg/clickhouse/clickhouse.go:1272 > SELECT d.path AS path, argMin(d.name, d.cache_path != '') AS name, any(lower(if(d.type='ObjectStorage',d.object_storage_type,d.type))) AS type, min(d.free_space) AS free_space, groupUniqArray(s.policy_name) AS storage_policies FROM system.disks AS d LEFT JOIN (SELECT policy_name, arrayJoin(disks) AS disk FROM system.storage_policies) AS s ON s.disk = d.name GROUP BY d.path
2026-09-09 23:48:10.097 INF pkg/clickhouse/clickhouse.go:1272 > SELECT name FROM system.user_directories WHERE type='replicated'
2026-09-09 23:48:10.100 INF pkg/clickhouse/clickhouse.go:1272 > SELECT data_path AS metadata_path FROM system.databases WHERE name = 'system' LIMIT 1
2026-09-09 23:48:10.111 INF pkg/keeper/keeper.go:404 > isSecure=false, keeperHosts=[172.17.69.11:2181 172.17.69.12:2181 172.17.69.13:2181]
2026-09-09 23:48:10.113 DBG pkg/keeper/keeper.go:432 > k->GetReplicatedAccessPath, userDirectory=replicated, zookeeper_path=/clickhouse/access
2026-09-09 23:48:10.114 DBG pkg/keeper/keeper.go:460 > k->ChildCount, prefix=/clickhouse/access, nodePath=uuid
2026-09-09 23:48:10.114 DBG pkg/keeper/keeper.go:41 > [keeper] connected to 172.17.69.12:2181
2026-09-09 23:48:10.118 DBG pkg/keeper/keeper.go:41 > [keeper] authenticated: id=109, timeout=15000
2026-09-09 23:48:10.118 DBG pkg/keeper/keeper.go:41 > [keeper] re-submitting `0` credentials after reconnect
2026-09-09 23:48:10.119 INF pkg/backup/create.go:954 > keeper.Dump /clickhouse/access -> /var/lib/clickhouse/backup/test_backup/access/replicated.jsonl, logger=createBackupRBACReplicated
2026-09-09 23:48:10.129 DBG pkg/keeper/keeper.go:41 > [keeper] recv loop terminated: failed to read from connection: EOF
2026-09-09 23:48:10.129 DBG pkg/keeper/keeper.go:41 > [keeper] send loop terminated: <nil>
2026-09-09 23:48:10.129 FTL pkg/backup/create.go:207 > error during do RBAC backup: b.createBackupRBACReplicated error: keeper.Dump rbac: dumpNodeRecursive(/clickhouse/access) return error: dumpNodeRecursive child: dumpNodeRecursive child: dumpNodeRecursive conn.Get: zk: not authenticated
┌─name─┬─value─┬─zookeeperName─┬─path───────────────┐
│ Q │ │ default │ /clickhouse/access │
│ U │ │ default │ /clickhouse/access │
│ uuid │ │ default │ /clickhouse/access │
│ R │ │ default │ /clickhouse/access │
│ M │ │ default │ /clickhouse/access │
│ P │ │ default │ /clickhouse/access │
│ S │ │ default │ /clickhouse/access │
└──────┴───────┴───────────────┴────────────────────┘
SELECT value
FROM system.build_options
WHERE name = 'VERSION_INTEGER'
┌─value────┐
│ 26003023 │
used clickhouse/clickhouse-keeper:26.3.23
docker run --rm -it --network=host -e CLICKHOUSE_HOST="172.17.69.13" -e CLICKHOUSE_PORT="9000" -e CLICKHOUSE_USERNAME="admin" -e CLICKHOUSE_PASSWORD="admin_password" -e LOG_LEVEL="debug" -v /mnt2/ch/clickhouse_data:/var/lib/clickhouse altinity/clickhouse-backup:2.8.0 clickhouse-backup create test_backup -s
from clickhouse-client with the same admin`s creds:
SELECT * FROM system.zookeeper WHERE path = '/clickhouse/access';
SELECT *
FROM system.zookeeper
WHERE path = '/clickhouse/access'