25.8.4 breakes existing RocksDB tables #87331
Description
Company or project name
No response
Describe the unexpected behaviour
Problem description
After updating ClickHouse to 25.8.4, we encountered a problem with EmbeddedRocksDB tables.
The issue seems related to PR #87109
We had a RocksDB table created like this:
CREATE TABLE externals.vt
(
`sha256` FixedString(64),
`amount` Nullable(Int8)
)
ENGINE = EmbeddedRocksDB
PRIMARY KEY sha256Previously, everything worked well up to 25.8.3.
After upgrading to 25.8.4, the async loader cannot finish successfully.
Error message
DB::Exception: Waited job failed: Code: 696. DB::Exception: Load job 'startup table externals.vt' -> Code: 695. DB::Exception: Load job 'load table externals.vt' failed: Code: 555. DB::Exception: Failed to open rocksdb path at: /var/lib/clickhouse/user_files/store/133/133f73c8-c43a-4eb0-a7e3-82da2cc73a74/: IO error: No such file or directory: While mkdir if missing: /var/lib/clickhouse/user_files/store/133/133f73c8-c43a-4eb0-a7e3-82da2cc73a74/: No such file or directory: Cannot attach table `externals`.`vt` from metadata file store/e4b/e4b1397c-5c50-473f-a925-eb12ffcf9b78/vt.sql from query ATTACH TABLE externals.vt UUID '133f73c8-c43a-4eb0-a7e3-82da2cc73a74' (`sha256` FixedString(64), `amount` Nullable(Int8)) ENGINE = EmbeddedRocksDB PRIMARY KEY sha256. (ROCKSDB_ERROR),. (ASYNC_LOAD_WAIT_FAILED) (version 25.8.4.13 (official build))Which ClickHouse versions are affected?
25.8.4
How to reproduce
Create a RocksDB table with EmbeddedRocksDB engine.
Upgrade from 25.8.3 → 25.8.4.
Observe async loader failure.
Error message and/or stacktrace
No response
Additional context
No response