Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: TIFLASH出现other error for mpp stream from mpp，日志报错Sync schemas failed by DB::Exception: Wrong precision
|
username: TiDBer_aEWxlwQR
[TiDB Usage Environment] Environment / Test / Poc
[TiDB Version]
[Reproduction Path] Opening a table that uses tiflash_replica results in an “other error for mpp stream from mpp” error.
[Encountered Issue: Problem Phenomenon and Impact] Opening a table that uses tiflash_replica results in an “other error for mpp stream from mpp” error. Checking the logs under the tiflash node shows an error level log: [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]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]
