Data and AI struggles

1,730 problems · 342 companies

Databases

Trouble with ClickHouse silently

2 posts from 2 people2d activeFading, +0 this weekunverified

Posts per day

Posts per day2 posts, Oct 5 to Nov 9

The posts behind it

GitHub issuesClickHouse/ClickHouse · fm4vNov 2

Lightweight `UPDATE`s made on 26.8+ silently disappear after a rollback to 26.6: v2 patch parts are detached as `broken-on-start` (`Invalid version of SourcePartsSetForPatch: 1`)

...newer) to 26.6, every patch part written by a lightweight `UPDATE` on the new version fails to load, is moved to `detached/` as `broken-on-start`, and all queries return the pre-update values without any error. The only trace is in the server log: `Part...

4 replies
GitHub issuesClickHouse/ClickHouse · clickgapaiOct 5

Multi-shard DISTINCT with LIMIT silently drops rows on type collapse

### Describe what's wrong - On a multi-shard Distributed table, `SELECT DISTINCT ts ... LIMIT 5` can return fewer distinct values than exist. - Trigger: shard column is `DateTime64(3)`, declared type on the Distributed table is `DateTime`, 10 distinct seconds underneath. -...

Companies and products named

2 posts
2 posts
About this problem

Evidence

2 posts from 2 people in 1 place, about 1 a week over 29 days. Mostly on ClickHouse/ClickHouse. Tools named alongside: GitHub.

Frustration Frustration 0 of 3· Seen on GitHub issues

How it was grouped

Posts about ClickHouse with no known issue, sharing the word "silently". First post Oct 5, 2026, latest Nov 2, 2026. Unverified: fewer than 3 posts, or one person or place only. Method

Other ClickHouse problems

ClickHouse upgrades break working setups

31 posts from 20 people on GitHub issues.

ClickHouse users keep filing bugs

Top post: "Tighten seccomp policy for optional kernel interfaces", one of 19 posts from 8 people on GitHub issues.

Trouble with ClickHouse column

Top post: "MaterializedPostgreSQL: reading a Nullable column's .null subcolumn (x IS NULL, count(x)) fails with", one of 15 posts from 9 people on GitHub issues.

ClickHouse costs outgrow the value it gives

11 posts from 3 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 8 posts from 5 people on GitHub issues.

Experiments on ClickHouse are hard to reproduce and track

8 posts from 1 person on GitHub issues. Unverified.

Trouble with ClickHouse tables

Top post: "Paimon: resolve columns by field id, so tables with renamed or re-added columns are readable", one of 7 posts from 6 people on GitHub issues.

Trouble with ClickHouse join

Top post: "Explicit grace_hash now spills at max_bytes_ratio_before_external_join = 0.5 although the build side fits in", one of 5 posts from 4 people on GitHub issues.

ClickHouse error messages are cryptic

5 posts from 3 people on GitHub issues.

Trouble with ClickHouse read

Top post: "ORC: a corrupt PostScript `metadata_length` makes ORC predicate pushdown read `stripe_stats` out of bounds,", one of 4 posts from 4 people on GitHub issues.

Trouble with ClickHouse database

Top post: "`DROP NAMED COLLECTION` succeeds while a database uses the collection, and the server then fails to start", one of 4 posts from 2 people on GitHub issues.

Trouble with ClickHouse query

Top post: "Memory tracker counts jemalloc's freed pages as used, so a heavy query started right after another spills to", one of 4 posts from 3 people on GitHub issues.

History

Momentum went from steady to fading.

Nov 9, 2026

Momentum went from fading to steady.

Nov 6, 2026

First seen with 1 post; the top post now: "Lightweight `UPDATE`s made on 26.8+ silently disappear after a rollback to 26.6: v2 patch parts are detached".

Oct 28, 2026