Problemsby GlyphClickHouse users keep filing bugs
19 posts from 8 people14d activeFading, +0 this week
Posts per day
The posts behind it
Docs: naiveBayesClassifier has conflicting duplicate configuration instructions
### Documentation page https://clickhouse.com/docs/reference/functions/regular-functions/machine-learning-functions ### Company or project name _No response_ ### Describe the issue The machine-learning functions page contains two `naiveBayesClassifier` sections with conflicting...
[ClickHouse] ADBC driver does not report rows written; Rust adbc_ffi ignores the rows-affected out-parameter
Part of #16932. ### Problem ClickHouse reports no rows written to dbt v2. ### Fix needed - [ ] **`ClickHouse/adbc_clickhouse`:** parse the `X-ClickHouse-Summary` response header (`written_rows`) and report it (there is a FIXME for it at `src/statement.rs`). - [ ] **Rust...
Tighten seccomp policy for optional kernel interfaces
The `seccomp` system call policy (`src/Common/SeccompFilter.cpp`, #119545) allows several groups of system calls unconditionally that most servers never use. Each of them is kernel attack surface that stays reachable for code running inside the server process. Tighten the policy...
darwin fast test: fix the tests newly failing on macOS ARM and remove their no-darwin tag
Fix each test below on macOS and remove its `no-darwin` tag; that brings it back into `Fast test (arm_darwin)`. New Darwin failures get a line here. - [ ] `04666_run_query_in_background_tcp` - hangs until the test timeout in a `grep -o -m1 BAD_ARGUMENTS` pipeline. - [ ]...
`input` inside `RETURNING` gives `LOGICAL_ERROR` 'Input initializer is not set'
### Describe what's wrong - Using the `input` table function inside an `INSERT ... RETURNING` query is not rejected and breaks the server or the protocol. - With data sent separately (`async_insert = 0`, stdin, `clickhouse-local`) the server throws `LOGICAL_ERROR`; debug and...
`Build (amd_msan)` is about two weeks from the x86-64 2 GiB relocation limit
...`arm_msan` already builds, and #125529 (open) moves `Unit tests (msan)` and the MSan flaky check to it, but the stateless, stress and fuzzer MSan jobs stay on `amd_msan`. @Algunenano, which should I prepare: (A) `-mcmodel=large` for `amd_msan`, with size and test time measured...
`json.^a` throws `BAD_ARGUMENTS`: sub-object type inherits root `SKIP` rules
### Describe what's wrong - Reading a sub-object (`json.^p`) or combined (`json.@p`) subcolumn of a valid JSON column fails. - Trigger: a `JSON` column with `SKIP`/`SKIP REGEXP` whose rule matches a typed path once prefix is stripped. - Expected the subcolumn to read normally;...
RowBinary `JSON(SKIP p)` insert drops `p_1` and keeps `p.*`: no `.` boundary
### Describe what's wrong - Binary `JSON` input applies `SKIP` paths as bare string prefixes, so stored data differs from `JSONEachRow` inserts of the same document. - Trigger: `RowBinary` insert with default `input_format_binary_read_json_as_string=0` into `JSON(SKIP path, SKIP...
`KILL MUTATION` fails with `SYNTAX_ERROR` on commands mangled by masking rules
...so later matched mutations are not killed either, and the error does not point to the workaround. ### Does it reproduce on most recent release? Confirmed on `master`; not checked on a release. ### How to reproduce Needs a build containing #122717 (26.10.1.2357 or later) with a...
`timeSeries*ToGrid` 14-24x slower on series with a mid-range gap
### Describe what's wrong - Aggregating a time series with a gap in the middle of its range is 3-24x slower, though results stay correct. - Trigger: a 7-day 60s grid over 200 series, each with 6200 populated buckets and a gap mid-range. - Expected the same ~0.06s as a contiguous...
Bad quality of documentation search
### Company or project name _No response_ ### Describe what's wrong The search in the clickhouse documentation, since the move from algolia to inkeep, often give bad quality response and even often not related. ### Does it reproduce on the most recent release? Yes ### How to...
ORDER BY f DESC LIMIT n with minmax index drops top rows when granule max is nan
### Describe what's wrong - `ORDER BY f DESC LIMIT n` over a float column with a `minmax` index silently skips the true top rows. - Trigger: an index granule whose stored max is `nan` because one of its data granules is all-`nan` while another holds the largest finite values. -...
Matcher in aliased `USING` key keeps inner `USING` supertype: `LOGICAL_ERROR`
### Describe what's wrong - An unqualified matcher in an alias-resolved outermost `JOIN USING` key throws `LOGICAL_ERROR` when the left side is an inner `USING` JOIN. - Trigger: `analyzer_compatibility_join_using_top_level_identifier = 1`, key `tuple(COLUMNS('^a#x27;)) AS k`, inner...
`ORDER BY` on a subcolumn bypasses the `Distributed` declared-type order check
### Describe what's wrong - `ORDER BY t.a` on a `Distributed` table silently returns shard-order rows instead of being refused. - Trigger: shard has `t Tuple(a String)`, Distributed declares `t Tuple(a Int8)`, query sorts or selects DISTINCT on `t.a`. - Expected: fails with...
Stack-overflow SIGSEGV on SELECT of deeply nested constant `Dynamic` value
### Describe what's wrong - A plain `SELECT` of a deeply nested constant `Dynamic` value crashes the server with a stack-overflow SIGSEGV at default settings. - Trigger: `finalizeAggregation` of a binary `AggregateFunction(any, Dynamic)` state with 4000 levels of...
Avro header parsing stack-overflows on deep chain of named record types
### Describe what's wrong - Reading a valid Avro file whose schema chains about 100000 named record types through direct fields crashes with a stack-overflow SIGSEGV. - Trigger is any SELECT via `file`/`url`/`s3` (or the Iceberg manifest reader), for any codec and regardless of...
`GROUPING SETS` constant key dropped: empty-input `()` row lost or doubled
### Describe what's wrong - With an aggregate and a grouping set made only of constant keys, empty input gives the wrong row count. - Trigger: `GROUP BY GROUPING SETS (('a'), ())` over `numbers(0)` with `count()`. - Expected one `()` row with count 0, but it returns no row at...
Segmentation fault (STID: 4085-568b)
...Failing test history: [cidb](https://play.clickhouse.com/play?user=play&run=1#V0lUSAogICAgOTAgQVMgaW50ZXJ2YWxfZGF5cwpTRUxFQ1QKICAgIHRvU3RhcnRPZkRheShjaGVja19zdGFydF90aW1lKSBBUyBkYXksCiAgICBjb3VudCgpIEFTIGZhaWx1cmVzLAogICAgZ3JvdXBVbmlxQXJyYXkocHVsbF9yZXF1ZXN0X251bWJlcikgQVMgcHJzLA...
LIMIT BY keys_to_keep set compares aliases, so an aliased GROUP BY key is missed
### Describe what's wrong - A valid aggregate query is rejected with error code 10 on a stock server with no settings changed - Trigger is a positional `LIMIT 1 BY 1` over `GROUP BY toString(c0)` with `WITH ROLLUP`, `WITH CUBE` or `WITH TOTALS` - Expected the grouped rows, but...
Companies and products named
About this problem
Evidence
19 posts from 8 people in 2 places, about 3 a week over 41 days. Mostly on ClickHouse/ClickHouse, dbt-labs/dbt. Tools named alongside: GitHub, dbt.
Frustration Frustration 0 of 3· Seen on GitHub issues
Summary, model-written
ClickHouse users face documentation search inaccuracies, row policy parameter value losses, test failures, and incorrect row count results due to step overflow in FillingRow.
How it was grouped
Posts about ClickHouse that state a pain but match no known issue yet. First post Sep 21, 2026, latest Oct 31, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other ClickHouse problems
ClickHouse upgrades break working setups
31 posts from 20 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.
ClickHouse rate limits and usage caps block work
3 posts from 3 people on GitHub issues.
History