Gary Dotzler

Random thought: If firmware-selector.openwrt.org could accept additional Installed Packages as a URL query parameter, folks could go ahead create their own remixes and image variants and share them as URLs...

We're also seeing this issue with several of our tables raising the `Index granularity total rows ... does not match rows_count` error when attempting to switch from 24.6 to 24.7...

The most recent part in our database that raises the index granularity issue is dated 2021-09. This could narrow the format change down to the [Clickhouse 21 series](https://clickhouse.com/docs/en/whats-new/changelog/2021). Release notes...

After downgrading back to 24.6, the parts flagged by 24.7 remain detached. Logs indicate around half a gigabyte of data lost (detached during the upgrade attempt) across 50 parts in...

@SaltTan With some manual effort I was able to attach one of the parts and that data is back: ```sql prod :) show create table domains.alexa FORMAT Raw CREATE TABLE...

Possibly related to #59173 now validating and disabling parts stored prior to Clickhouse 21 which could have marks bigger than the fixed granularity size (#19123). cc. @alesapin. So either the...

@den-crane: Currently on vacation and haven't had a chance to create a full repro using old releases, but it seems prudent to revert #59173 as it introduces an obvious validation...

@alesapin Sure thing. metadata and store files for table ``domains.alexa`` attached: [clickhouse-issue-68198-repro.tar.gz](https://github.com/user-attachments/files/16751327/clickhouse-issue-68198-repro.tar.gz)

@alesapin It's hiding in there: ``` $ cat clickhouse-issue-68198-repro/store/f57/f571fe37-dd1e-4d79-a072-2978b57d62b6/alexa.sql ATTACH TABLE _ UUID '6faf094a-9b34-4940-8b7c-75433206beef' ( `rank` UInt32, `domain` String ) ENGINE = MergeTree ORDER BY rank SETTINGS index_granularity = 8192...

This is cool. Small suggestion: the name `chcache` gives the impression of a database cache layer rather than a build tool, maybe a clearer name will be `chccache` following the...