Trouble with ClickHouse backup
3 posts from 3 people2d activeFading, +0 this week
Posts per day
The posts behind it
`Dictionary` database lacks `getTablesForBackup`: `BACKUP ALL` fails
...as a `URL` database is; actual is error 647. - `SQLite` databases have the same gap; workaround is listing the database in `EXCEPT DATABASES`, and data is not affected. Root cause: `DatabaseDictionary` does not override `getTablesForBackup`, so `findTablesInDatabase` in...
ENGINE = Backup cannot pass open settings such as use_same_s3_credentials_for_base_backup
...first is opened with the locator stored in the preceding link's `.backup`, and there is no way to influence that: the engine accepts exactly two arguments and no `SETTINGS` clause. That makes an incremental chain unreadable whenever the credentials that wrote it are not the...
RESTORE from a tar-family backup archive with a `password` crashes Debug/CI builds (LOGICAL_ERROR abort)
## Summary `RESTORE ... FROM File(' .tar[.gz|.xz|.zst|.bz2|.lzma]'|' .7z') SETTINGS password=' '` reaches `LibArchiveReader::setPassword`, which throws **`ErrorCodes::LOGICAL_ERROR`** ("Cannot set password to {} archive") because libarchive (tar/7z) doesn't support passwords....
Companies and products named
About this problem
Evidence
3 posts from 3 people in 1 place, about 1 a week over 29 days. Mostly on ClickHouse/ClickHouse. Tools named alongside: GitHub, PostgreSQL, MySQL, SQLite.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts about ClickHouse with no known issue, sharing the word "backup". First post Oct 13, 2026, latest Nov 10, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other ClickHouse problems
ClickHouse upgrades break working setups
37 posts from 21 people on GitHub issues.
ClickHouse users keep filing bugs
Top post: "Tighten seccomp policy for optional kernel interfaces", one of 22 posts from 10 people on GitHub issues.
Trouble with ClickHouse column
Top post: "Top-K reads with a `minmax` index on the sort column: read the granules with the best bounds first", one of 17 posts from 10 people on GitHub issues.
ClickHouse costs outgrow the value it gives
11 posts from 3 people on GitHub issues.
Experiments on ClickHouse are hard to reproduce and track
11 posts from 2 people on GitHub issues.
Trouble with ClickHouse table
Top post: "`SYSTEM RESTORE REPLICA` on a second replica over-bumps the table `metadata` znode version; every later", one of 9 posts from 5 people on GitHub issues.
Trouble with ClickHouse join
Top post: "JOIN runtime filter pruning drops rows for CAST(UInt8 AS Bool) probe key", one of 7 posts from 5 people on GitHub issues.
Trouble with ClickHouse read
Top post: "Bucketed `Map` serialization loses the key order in Compact parts written with", one of 6 posts from 6 people on GitHub issues.
ClickHouse error messages are cryptic
6 posts from 3 people on GitHub issues.
Trouble with ClickHouse tables
Top post: "Paimon: resolve columns by field id, so tables with renamed or re-added columns are readable", one of 5 posts from 4 people on GitHub issues.
Trouble with ClickHouse default
Top post: "`merge('', regexp)` still resolves against the shard's default database", one of 5 posts from 4 people on GitHub issues.
Trouble with ClickHouse index
Top post: "Text index: exact hasPhrase on Array columns with a position increment gap", one of 4 posts from 2 people on GitHub issues.
History