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:
https://builds.altinity.cloud/
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.
ClickHouse release v21.8.12.29-altinitystable as compared to v21.8.11.1-altinitystable:
empty
and notEmpty
with the arguments of UUID
type. Fixes #31819. #31883 (Anton Popov).../src/IO/ReadBuffer.h:58: bool DB::ReadBuffer::next(): Assertion '!hasPendingData()' failed.
in TSKV format. #31804 (Kruglov Pavel).Buffer
table engine with type Map
. Fixes #30546. #31742 (Anton Popov).there are no such cluster here
error on execution of ON CLUSTER
query if specified cluster name is name of Replicated
database. #31723 (tavplubix).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).RENAME TABLE
query worked incorrectly on attempt to rename an DDL dictionary in Ordinary
database, it’s fixed. #31638 (tavplubix).nullptr
in STS credentials provider for S3. #31409 (Vladimir Chebotarev).DB::Exception: std::out_of_range: basic_string
error in release server in case of bad hdfs url by adding additional check of hdfs url structure. #31042 (Kruglov Pavel).Return to the top.
CompiledExpressionCache
limit elements size using compiled_expression_cache_elements_size
setting. #30667 (Maksim Kita).SHOW GRANTS
when partial revokes are used. This PR fixes #31138. #31249 (Vitaly Baranov).StorageMerge
with aliases and where (it did not work before at all). Closes #28802. #31044 (Kseniia Sumarokova).JSONValue
/Query
with quoted identifiers. This allows to have spaces in json path. Closes #30971. #31003 (Kseniia Sumarokova).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).max_partition_size_to_drop
check in case of ATTACH PARTITION ... FROM
and MOVE PARTITION ...
#30995 (Amr Alaa).AND/OR
expressions when there are more than two operands. This fixes #30416 . #30887 (Amos Bird).ReplicatedMergeTree
. Previously server might fail to start with Unknown auxiliary ZooKeeper name
if ZooKeeper path contains a colon. Fixes #29052. Also it was allowed to specify ZooKeeper path that does not start with slash, but now it’s deprecated and creation of new tables with such path is not allowed. Slashes and colons in auxiliary ZooKeeper names are not allowed too. #30822 (tavplubix).REPLACE/MOVE PARTITION
and background merge in non-replicated MergeTree
that might cause a part of moved/replaced data to remain in partition. Fixes #29327. #30717 (tavplubix).PREWHERE
with WHERE
in case of always true PREWHERE
. #30668 (Azat Khuzhin).positionCaseInsensitiveUTF8
and countSubstringsCaseInsensitiveUTF8
might find substrings that actually does not match is fixed. #30663 (tavplubix).Cannot find column
. Fixes #30438. #30562 (Nikolai Kochetov).parallel_view_processing
. This resolves issues / prevents crashes in some rare corner cases when that feature is enabled and exception (like Memory limit exceeded ...
) happened in the middle of materialized view processing. #30472 (filimonov).REPLACE PARTITION
. #30432 (tavplubix).ComplexKeyHashedDictionary
, ComplexKeySparseHashedDictionary
parsing preallocate
option from layout config. #30246 (Maksim Kita).[I]LIKE
function. Closes #28661. #30244 (Nikolay Degterinsky).initializeAggregation
. #30177 (Anton Popov).LogSink::writeMarks()
and LogSource
in StorageLog
. #29946 (Azat Khuzhin).ORDER BY
if it contains WITH FILL
. This closes #28908. This closes #26049. #28910 (alexey-milovidov).IN
( i.e. (k,v) IN ((1, 2))
) (but note that this has some backward incompatibility for the clickhouse-copier
since it uses alias for tuple element). #28888 (Azat Khuzhin).PREWHERE
(Fixes: #28461). #28502 (Azat Khuzhin).NOT-IN
index optimization when not all key columns are used. This fixes #28120. #28315 (Amos Bird).ORDER BY ... WITH FILL
with set TO
and FROM
and no rows in result set. #30888 (Anton Popov).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.
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)
Was this page helpful?
Glad to hear it!
Sorry to hear that. We'll track this issue and see how we can improve.