New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ScanRow error when running backup list/restore commands #856
Comments
Using the
When we run |
could you create separate issue for the last message? |
@tman5 which |
Could you share under following SQL query results SHOW GRANTS FORMAT Vertical;
SELECT countIf(name='type') AS is_disk_type_present,
countIf(name='free_space') AS is_free_space_present,
countIf(name='disks') AS is_storage_policy_present
FROM system.columns WHERE database='system' AND table IN ('disks','storage_policies'); |
Sure Clickhouse-server version:
|
Weird SELECT d.path, any(d.name) AS name,
'local' AS type,
0 AS free_space,
['default'] AS storage_policies
FROM system.disks AS d
GROUP BY d.path
How do you create |
Via users.d
Role
We did confirm this appears to work when assigning the default profile |
FYI we could not get this to work without granting the sysadmin role
|
So, this is grants to system.* related issue, thanks for sharing your experience |
@Slach so is it expected to have to use `GRANT ALL ON ".*" for the backup account? It just requires that many privileges? |
if you want to backup |
This looks like a permission issue with the backup account, but it does have quote a few permissions
This is the config for the backup user being used:
Backup config:
The text was updated successfully, but these errors were encountered: