Table not exists when binding with dictionary #12614
Description
Describe the bug
Version: 20.3.8.53.
dn592 :) show create table default.kv;
SHOW CREATE TABLE default.kv
┌─statement────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ CREATE TABLE default.kv (`id` UInt64 DEFAULT cityHash64(key), `key` String, `value` String, `updateTime` DateTime) ENGINE = ReplacingMergeTree ORDER BY id SETTINGS index_granularity = 8192 │
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
1 rows in set. Elapsed: 0.001 sec.
dn592 :) desc `default`.`kv`;
DESCRIBE TABLE default.kv
Received exception from server (version 20.3.8):
Code: 60. DB::Exception: Received from 127.0.0.1:9000. DB::Exception: Table default.kv doesn't exist..
0 rows in set. Elapsed: 0.001 sec.
I don't know how to reproduce it, I tried many times but fail to reproduce it.
- Create default.kv
CREATE TABLE default.kv (`id` UInt64 DEFAULT cityHash64(key), `key` String, `value` String, `updateTime` DateTime) ENGINE = ReplacingMergeTree ORDER BY id SETTINGS index_granularity = 8192
- Create default.dict_kv
CREATE DICTIONARY default.dict_kv (`id` UInt64, `value` String) PRIMARY KEY id SOURCE(CLICKHOUSE(HOST 'dn592' PORT 9000 USER 'default' TABLE 'kv' PASSWORD 'xxx' DB 'default')) LIFETIME(MIN 300 MAX 600) LAYOUT(HASHED())
-
dn592 is ok now.
-
Create another defaut.dict_kv in remote ClickHouse dn597 like step 2 and reload dictionaries
dn597:
dn597 :) system reload dictionaries
SYSTEM RELOAD DICTIONARIES
Received exception from server (version 20.3.8):
Code: 60. DB::Exception: Received from 127.0.0.1:9000. DB::Exception: Code: 60, e.displayText() = DB::Exception: Received from Node1:9000. DB::Exception: Table default.kv doesn't exist.. (version 20.3.8.53).
- dn592 table also lost.