25.8.28.10001 Altinity Stable
25.8.28.10001 Altinity Stable (568824f) as compared to v25.8.28.1-lts (cfec8e085bab84e94140bb82eb5c18d64f4ff61a)
Improvements
- Add a dedicated cleanup thread for MergeTree to prevent cleanup delays under heavy merge load. This resolves ClickHouse#86181. The MergeTree cleanup logic was tightly coupled with the merge scheduler, which caused cleanup tasks to be delayed or completely blocked when the table was under heavy merge load. ReplicatedMergeTree already had a separate cleanup thread, so this change aligns MergeTree with that design. (ClickHouse#91574 via #1589)
Bug Fixes (user-visible misbehavior in an official stable release)
- Fix aggregation of sparse columns when
group_by_overflow_modeis set toany(ClickHouse#88440 by @korowa, ClickHouse#95301 by @mkmkme via #1396) - Fix regression in (experimental) zero‑copy replication introduced by ClickHouse#94262 where shared parts could be deleted before other replicas finished fetching them (ClickHouse#95597 by @filimonov via #1738)
- Allow positional arguments in distributed queries (ClickHouse#94359 by @simonmichal via #1820)
- Fix columns_substreams.txt corruption during column rename in some cases. (ClickHouse#102689 by @Avogar via #1821)
- Fix logical error in a rare case when empty tuple is used with Map column. (ClickHouse#93814 by @nihalzp via #1994)
- Backport upstream fixes for LOGICAL_ERROR in queries with parallel replicas and multiple JOINs (LEFT/INNER...RIGHT, RIGHT...RIGHT, n-way with GLOBAL/FULL) (ClickHouse#86895, ClickHouse#87178, ClickHouse#97316 by @devcrafter via #2019)
- Fixes a bug where
OPTIMIZE FINALon row-combining engines could crash the server (#2020 by @mkmkme) - Fix a regression with the Gorilla codec when an explicitly specified size does not correspond to the data type size, and the buffer size is too small. In previous versions, it threw an exception on decompression. (ClickHouse#96118 by @alexey-milovidov via #2021)
- Fix "TOO_MANY_MARKS" error which could have happened after some
ALTERqueries for compact parts (ClickHouse#91980 by @alesapin via #2043) - Fixed
use_client_time_zonebeing ignored forDateTime/DateTime64string literals interpreted on the server (asynchronousINSERT,SELECTliterals). The client now propagates its local time zone assession_timezonewhenuse_client_time_zoneis enabled, so server-side parsing matches the synchronousINSERTpath (ClickHouse#109051 by @groeneai via #2046) - Fixed parquet reader v3 incorrectly handling arrays that cross page boundaries. This happens e.g. for files written by Arrow without enabling page statistics or page index. Affects only columns of Array data type. Likely symptom is that one array every ~1 MB of data gets truncated. Before this fix, use this setting as workaround:
input_format_parquet_use_native_reader_v3 = 0(ClickHouse#94125 by @al13n321 via #2053) - Disable
additional_table_filterswith parallel replicas and analyzer and w/o query plan serialization (ClickHouse#104296 by @azat via #2065)
Build/Testing/Packaging Improvements
- Use openssl 3.5.6 (ClickHouse#102606 by @thevar1able via #1680)
- Upgrade Ubuntu Docker image packages to apply available security fixes. (#1968 by @CarlosFelipeOR)
CI Fixes or Improvements
- For MergeTree tables using object storage which do not support writing with append, it will not support transactions. (ClickHouse#88490 by @tuanpach via #2094)
- Check if encrypted disks support writing with append (ClickHouse#89999 by @tuanpach via #2094)
And ALL changes from (v25.8.16.10002.altinitystable)[https://github.com/Altinity/ClickHouse/releases/tag/v25.8.16.10002.altinitystable]
Packages
Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/#altinitystable as either .deb, .rpm, or .tgz
Docker images
Available for both AMD64 and Aarch64: altinity/clickhouse-server:25.8.28.10001.altinitystable
Full Changelog: cfec8e0...568824f