TIFLASH出现other error for mpp stream from mpp，日志报错Sync schemas failed by DB::Exception: Wrong precision

🪐 TiDB 技术问题
,
1

【 TiDB 使用环境】环境 /测试/ Poc
【 TiDB 版本】
【复现路径】打开使用了tiflash_replica的表就会出现other error for mpp stream from mpp错误
【遇到的问题：问题现象及影响】使用了tiflash_replica的表打开会出现other error for mpp stream from mpp错误，在tiflash节点下查看日志有error级别的错误：[ERROR] [SchemaSyncService.cpp:91] [“Sync schemas failed by DB::Exception: Wrong precision:0 \n stack : \n 0x1bff13e\tDB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int) [tiflash+29356350]\n \tdbms/src/Common/Exception.h:46\n 0x1da336a\tDB::createDecimal(unsigned long, unsigned long) [tiflash+31077226]\n \tdbms/src/DataTypes/DataTypeDecimal.h:196\n 0x804b106\tstd::__1::__function::__func<DB::TypeMapping::TypeMapping()::$_18, std::__1::allocatorDB::TypeMapping::TypeMapping()::$_18, std::__1::shared_ptr<DB::IDataType const> (TiDB::ColumnInfo const&)>::operator()(TiDB::ColumnInfo const&) [tiflash+134525190]\n \t/usr/local/bin/…/include/c++/v1/__functional/function.h:345\n 0x8046e47\tDB::getDataTypeByColumnInfo(TiDB::ColumnInfo const&) [tiflash+134508103]\n \tdbms/src/Storages/Transaction/TypeMapping.cpp:172\n 0x807529f\tDB::createTableStmt(TiDB::DBInfo const&, TiDB::TableInfo const&, DB::SchemaNameMapper const&, std::__1::shared_ptrDB::Logger const&) [tiflash+134697631]\n \tdbms/src/TiDB/Schema/SchemaBuilder.cpp:1018\n 0x8073d69\tDB::SchemaBuilder<DB::SchemaGetter, DB::SchemaNameMapper>::applyCreatePhysicalTable(std::__1::shared_ptrTiDB::DBInfo const&, std::__1::shared_ptrTiDB::TableInfo const&) [tiflash+134692201]\n \tdbms/src/TiDB/Schema/SchemaBuilder.cpp:1101\n 0x806d35b\tDB::SchemaBuilder<DB::SchemaGetter, DB::SchemaNameMapper>::syncAllSchema() [tiflash+134665051]\n \tdbms/src/TiDB/Schema/SchemaBuilder.cpp:1320\n 0x7ff80c3\tDB::TiDBSchemaSyncer<false, false>::syncSchemas(DB::Context&, unsigned int) [tiflash+134185155]\n \tdbms/src/TiDB/Schema/TiDBSchemaSyncer.h:163\n 0x80ae1d1\tstd::__1::__function::__func<DB::SchemaSyncService::addKeyspaceGCTasks()::$_2, std::__1::allocatorDB::SchemaSyncService::addKeyspaceGCTasks()::$_2, bool ()>::operator()() [tiflash+134930897]\n \t/usr/local/bin/…/include/c++/v1/__functional/function.h:345\n 0x7e241db\tvoid* std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_deletestd::__1::__thread_struct >, DB::BackgroundProcessingPool::BackgroundProcessingPool(int, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator >)::$_1> >(void*) [tiflash+132268507]\n \t/usr/local/bin/…/include/c++/v1/thread:291\n 0x7fd17fcdbea5\tstart_thread [libpthread.so.0+32421]\n 0x7fd17f5eab0d\tclone [libc.so.6+1043213]”] [source=“keyspace=4294967295”] [thread_id=172]
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件：截图/日志/监控】

image
image1567×225 19 KB

2

最近有做过 跨 6.5 版本升级么？tiflash 是否重新启动过。

如果有，可能是一个已知 bug，可以将 tiflash 缩容再扩容解决。(重建 tiflash，副本要也删掉重建)

3

感谢，缩容、扩容可以解决！