TIflash部署失败

🪐 TiDB 技术问题
1

【TiDB 使用环境】测试/
【TiDB 版本】8.1.2
【操作系统】linux
【部署方式】docker compose部署
【问题复现路径】docker compose直接部署tiflash后，创建表尝试同步tiflash失败
【遇到的问题：问题现象及影响】
[2025/10/21 08:24:15.067 +00:00] [ERROR] [Server.cpp:905] ["Bootstrap failed because sync schema error: DB::Exception: Unknown engine type : 1: \n 0x7888719\tDB::TiFlashException::TiFlashException(DB::TiFlashError const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int&&) [tiflash+126387993]\n \tdbms/src/Common/TiFlashException.h:269\n 0x85cc753\tDB::createTableStmt(unsigned int, long, TiDB::TableInfo const&, DB::SchemaNameMapper const&, unsigned long, std::__1::shared_ptrDB::Logger const&) [tiflash+140298067]\n \tdbms/src/TiDB/Schema/SchemaBuilder.cpp:1117\n 0x85c8f49\tDB::SchemaBuilder<DB::SchemaGetter, DB::SchemaNameMapper>::applyCreateStorageInstance(long, std::__1::shared_ptrTiDB::TableInfo const&, bool, std::__1::basic_string_view<char, std::__1::char_traits >) [tiflash+140283721]\n \tdbms/src/TiDB/Schema/SchemaBuilder.cpp:1168\n 0x85f3f20\tstd::__1::__function::__func<DB::SchemaBuilder<DB::SchemaGetter, DB::SchemaNameMapper>::syncAllSchema()::‘lambda’(), std::__1::allocator<DB::SchemaBuilder<DB::SchemaGetter, DB::SchemaNameMapper>::syncAllSchema()::‘lambda’()>, void ()>::operator()() [tiflash+140459808]\n \t/usr/local/bin/…/include/c++/v1/__functional/function.h:345\n 0x1f74fa5\tstd::__1::packaged_task<void ()>::operator()() [tiflash+32984997]\n \t/usr/local/bin/…/include/c++/v1/future:2089\n 0x1f738b7\tDB::ThreadPoolImpl<D.
【建表语句】
CREATE TABLE user_tags (
id int(11) NOT NULL AUTO_INCREMENT,
user_ids LONGBLOB,
log_unique char(100) NOT NULL DEFAULT ‘’ COMMENT ‘唯一hash’
)
ALTER TABLE ExceptionTrack_DB.user_tags SET TIFLASH REPLICA 1;
求救

2

LONGBLOB类型不被tiflash支持。
https://docs.pingcap.com/zh/tidb/stable/tiflash-compatibility/#tiflash-兼容性说明

1 个赞
3

LONGBLOB换成VARCHAR 也还是没法建立tiflash :sob:

4

报错还是一样的 没有任何变化 :sob:

5

varchar应该可以的吧

6

换成VARCHAR报什么错

7 
CREATE TABLE user_tags (
id int(11) NOT NULL AUTO_INCREMENT,
user_ids LONGBLOB,
log_unique char(100) NOT NULL DEFAULT '' COMMENT '唯一hash'
);


ALTER TABLE user_tags SET TIFLASH REPLICA 1;



INSERT INTO user_tags (user_ids, log_unique)
VALUES (
  '["1","2","3","4","5","6","7","8","9","10",
    "11","12","13","14","15","16","17","18","19","20",
    "21","22","23","24","25","26","27","28","29","30",
    "31","32","33","34","35","36","37","38","39","40",
    "41","42","43","44","45","46","47","48","49","50",
    "51","52","53","54","55","56","57","58","59","60",
    "61","62","63","64","65","66","67","68","69","70",
    "71","72","73","74","75","76","77","78","79","80",
    "81","82","83","84","85","86","87","88","89","90",
    "91","92","93","94","95","96","97","98","99","100",
    ... up to "10000" ...
  ]',
  'hash_10000_users'
);


explain analyze select /*+ read_from_storage(tiflash[user_tags]) */ * from user_tags;

是不是有别的问题，我在v7.5上测试，看执行计划都是走了mpp的。

8

清空重新来.

9

不识别引擎类型吗

10

那就换成VARCHAR吧