Lightweight updates (beta) can cause undesired effects
Nov 18, 23:33 UTCNov 19, 18:31 UTC
Duration
18h 58m
Impact
Minor
Root cause
Not disclosed
ClickHouse, 90 days
15 incidents
Affected
Not listed by the vendor.
Final update
We are developing a fix to avoid the problem and will be rolling it out soon. We will manually reach out to potentially affected customers (< 0.1% of the fleet).
Timeline
- Resolved · Nov 19, 18:31 UTC
We are developing a fix to avoid the problem and will be rolling it out soon. We will manually reach out to potentially affected customers (< 0.1% of the fleet).
- Investigating · Nov 18, 23:33 UTC
We’ve discovered an issue where enabling lightweight updates on an **existing table** via setting `enable_block_number_column = 1` could cause incorrect results. To achieve desired results, create a new table and set `enable_block_offset_column = 1` on the table first before inserting any data into it.
More from ClickHouse
Full historyProvisioning may be degradedlasted 48mProvisioning and scaling operations may take longer in AWS ap-northeast-1 Tokyolasted 7h 38mSQL Console database connection outagelasted 50mDegraded support ticket submission and responselasted 2h 48mGoogle Cloud Outagelasted 6h 44mSupport case creation unavailablelasted 31m