Data and AI struggles

2,114 problems · 377 companies

Databases

Trouble with ClickHouse backup

3 posts from 3 people2d activeFading, +0 this week

Posts per day

Posts per day3 posts, Oct 13 to Nov 21

The posts behind it

GitHub issuesClickHouse/ClickHouse · clickgapaiNov 10

`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...

GitHub issuesClickHouse/ClickHouse · jkartsevaNov 10

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...

GitHub issuesClickHouse/ClickHouse · PedroTadimOct 13

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....

2 replies

Companies and products named

3 posts
2 posts
1 post
1 post
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

Momentum went from rising to fading.

Nov 17, 2026

Corroborated: 3 or more posts from 2 or more people or places.

Nov 16, 2026

Momentum went from fading to rising.

Nov 16, 2026

First seen with 1 post; the top post now: "RESTORE from a tar-family backup archive with a `password` crashes Debug/CI builds (LOGICAL_ERROR abort)".

Oct 28, 2026