Altinity Stable for ClickHouse™ 21.8
(October 11, 2021)
Most recent releases organized by major release and release date:
Based on upstream/v21.8.15.7-lts.
ClickHouse release v21.8.15.7-altinitystable as compared to community ClickHouse v21.8.15.7:
altinity/clickhouse-server:21.8.15.15.altinitystable
clickhouse@21.8-altinity-stable-21.8.15.15
Return to the top.
ClickHouse release v21.8.13.1-altinitystable as compared to v21.8.12.29-altinitystable:
Fixed Apache Avro Union type index out of boundary issue in Apache Avro binary format. #33022 (Harry Lee).
Quota limit was not reached, but the limit was exceeded. This PR fixes #31174. #31656 (sunny).
NO CL ENTRY: ‘fix json error after downgrade’. #33166 (bullet1337).
Integer overflow to resize the arrays causes heap corrupt. #33024 (varadarajkumar).
fix crash when used fuzzBits with multiply same FixedString, Close #32737. #32755 (SuperDJY).
Fix possible exception at RabbitMQ storage startup by delaying channel creation. #32584 (Kseniia Sumarokova).
Fixed crash with SIGFPE in aggregate function avgWeighted
with Decimal
argument. Fixes #32053. #32303 (tavplubix).
Some replication queue entries might hang for temporary_directories_lifetime
(1 day by default) with Directory tmp_merge_<part_name>
or Part ... (state Deleting) already exists, but it will be deleted soon
or similar error. It’s fixed. Fixes #29616. #32201 (tavplubix).
XML dictionaries identifiers, used in table create query, can be qualified to default_database
during upgrade to newer version. Closes #31963. #32187 (Maksim Kita).
Number of active replicas might be determined incorrectly when inserting with quorum if setting replicated_can_become_leader
is disabled on some replicas. It’s fixed. #32157 (tavplubix).
Fixed Directory ... already exists and is not empty
error when detaching part. #32063 (tavplubix).
Some GET_PART
entry might hang in replication queue if part is lost on all replicas and there are no other parts in the same partition. It’s fixed in cases when partition key contains only columns of integer types or Date[Time]
. Fixes #31485. #31887 (tavplubix).
Change configuration path from keeper_server.session_timeout_ms
to keeper_server.coordination_settings.session_timeout_ms
when constructing a KeeperTCPHandler
- Same with operation_timeout
. #31859 (JackyWoo).
Fix a bug about function transform with decimal args. #31839 (李帅).
Fix crash when function dictGet
with type is used for dictionary attribute when type is Nullable
. Fixes #30980. #31800 (Maksim Kita).
Fix crash with empty result on odbc query. Closes #31465. #31766 (Kseniia Sumarokova).
Fix possible crash (or incorrect result) in case of LowCardinality
arguments of window function. Fixes #31114. #31888 (Nikolai Kochetov).
Test Report for Altinity Stable Build v21.8.13.1.
Return to the top.
replicated_can_become_leader
is disabled on some replicas. It’s fixed. #32157 (tavplubix).../src/IO/ReadBuffer.h:58: bool DB::ReadBuffer::next(): Assertion '!hasPendingData()' failed.
in TSKV format. #31804 (Kruglov Pavel).dictGet
with type is used for dictionary attribute when type is Nullable
. Fixes #30980. #31800 (Maksim Kita).Buffer
table engine with type Map
. Fixes #30546. #31742 (Anton Popov).input_format_allow_errors_num
and input_format_allow_errors_ratio
did not work for parsing of domain types, such as IPv4
, it’s fixed. Fixes #31686. #31697 (tavplubix).formatRow
function with not row formats led to segfault. Don’t allow to use this function with such formats (because it doesn’t make sense). #31001 (Kruglov Pavel).positionCaseInsensitiveUTF8
and countSubstringsCaseInsensitiveUTF8
might find substrings that actually does not match, it’s fixed. #30663 (tavplubix).[I]LIKE
function. Closes #28661. #30244 (Nikolay Degterinsky).initializeAggregation
. #30177 (Anton Popov).tuple()
, closes #30004. #30016 (flynn).LowCardinality
during GROUP BY
(leads to SIGSEGV). #29782 (Azat Khuzhin).GROUP BY WITH TOTALS HAVING
(when the column from HAVING
wasn’t selected). #29553 (Azat Khuzhin).send_timeout
/receive_timeout
). #29282 (Azat Khuzhin).Table columns structure in ZooKeeper is different from local table structure
exception while recreating or creating new replicas of ReplicatedMergeTree
, when one of table columns have default expressions with case-insensitive functions. #29266 (Anton Popov).GLOBAL IN
subquery (it was executed in single threads since #19414 bugfix). #28997 (Nikolai Kochetov).ORDER BY ... WITH FILL
with set TO
and FROM
and no rows in result set. #30888 (Anton Popov).AccessControlManager
. Now there can’t be reloading of the configuration after AccessControlManager has been destroyed. This PR fixes the flaky test test_user_directories/test.py::test_relative_path. #29951 (Vitaly Baranov).clickhouse-bridge
group and user for bridge processes. Set oom_score_adj so the bridges will be first subjects for OOM killer. Set set maximum RSS to 1 GiB. Closes #23861. #25280 (Kseniia Sumarokova).Return to the top.
This is a security update to 21.1.10.3 release. It backports fixes for several CVEs into 21.1 version:
As we discussed in a recent Altinity Blog article, JFrog discovered these CVEs and reported them to the Yandex team in 2021. The CVEs have been already included in 21.3.19 and 21.8.11 and Altinity.Stable and ClickHouse builds and all ClickHouse builds after 21.10.
We have now backported the fixes to 21.1 as part of our long-term maintenance policy for Altinity Stable builds. We recommend all users running ClickHouse 21.1 upgrade to this new release.
altinity/clickhouse-server:21.1.11.3.altinitystable
Return to the top.
background_fetches_pool_size
is set to 8. This is better for production usage with frequent small insertions or slow ZooKeeper clusters.Cannot find column in ActionsDAG result'
, which may happen if subquery uses untuple
. https://github.com/ClickHouse/ClickHouse/issues/22290quantile(s)TDigest
that could produce non-accurate results in some edge cases: https://github.com/ClickHouse/ClickHouse/issues/22408+
’ sign: https://github.com/clickHouse/clickHouse/pull/23822The complete diff between Altinity and community versions can also be viewed at github:
Fixed a bug with distributed queries that could sometimes fail with ‘Unknown packet n from server
’ error message: https://github.com/ClickHouse/ClickHouse/issues/21588
Fixed several issues with mutations handling (e.g. https://github.com/ClickHouse/ClickHouse/issues/22013)
Fix a rare bug when quorum insert with iinsert_quorum_parallel=1
is not really a “quorum” because of deduplication
Fixed a possible buffer overflow in token bloom filter index: https://github.com/ClickHouse/ClickHouse/issues/19233
Fixed a bug when nullable types sometimes could not be retrieved: https://github.com/ClickHouse/ClickHouse/issues/21116
Fixed a bug with replicated tables metadata not properly cleaned from the non-primary ZooKeeper instance: https://github.com/ClickHouse/ClickHouse/issues/21054
Added parseDateTimeBestEffortOrZero
to allow for empty values, while parseDateTimeBestEffort
will not work with empty values. For example:
SELECT parseDateTimeBestEffort('')
Query id: 1c60717e-116b-445f-b675-7b9cac35c262
0 rows in set. Elapsed: 0.003 sec.
Received exception from server (version 21.11.1):
Code: 41. DB::Exception: Received from localhost:9000. DB::Exception: Cannot read DateTime: neither Date nor Time was parsed successfully: While processing parseDateTimeBestEffort(''). (CANNOT_PARSE_DATETIME)
SELECT parseDateTimeBestEffortOrZero('')
Query id: 484baec9-6d00-4c66-a792-85a270d6f2f2
┌─parseDateTimeBestEffortOrZero('')─┐
│ 1970-01-01 03:00:00 │
└───────────────────────────────────┘
ClickHouse Altinity Stable packages for this release can be found at:
Return to the top.
Bug fixes.
Return to the top.
The release includes several dozen bug fixes from the previous release.
if
function with NULLs.WITH
clause.SIGSEGV
in Kafka engine when broker is unavailable.block structure mismatch
error for queries with UNION
and JOIN
.ALTER TABLE UPDATE
could produce incorrect results when updating Nullable columns.Updated RPM packages for Altinity Stable Release can be found in the Altinity Stable Repository. The ClickHouse repository can be used for DEB packages but check version numbers carefully.
Return to the top.
(October 11, 2021)
(June 24, 2021)
(March 24, 2021)
(December 2, 2020)
(June 24, 2020)
(January 20, 2020)
(November 28, 2019)
(September 3, 2019)
(December 31, 2018)