tiflash v5.3.1添加副本报错Detected overflow when decoding data

【 TiDB 使用环境】生产环境
【 TiDB 版本】5.3.1
【复现路径】 alter table x.y set tiflash replica 1;
【遇到的问题:问题现象及影响】
问题:添加tiflash副本导致tiflash节点报错
现象:无法添加tiflash副本,报错: Detected overflow when decoding data 18446744073709551615 of column ipnum with type Nullable(UInt32)
该表为按天range的分区表,报错日志中的对应字段的定义:ipnum int(10) unsigned DEFAULT NULL

【资源配置】
【附件:截图/日志/监控】


[2022/12/01 16:23:46.443 +08:00] [ERROR] [] [“DB::RawCppPtr DB::PreHandleSnapshot(DB::EngineStoreServerWrap*, DB::BaseBuffView, uint64_t, DB::SSTViewVec, uint64_t, uint64_t): Code: 49, e.displayText() = DB::Exception: Detected overflow when decoding data 18446744073709551615 of column ipnum with type Nullable(UInt32), e.what() = DB::Exception, Stack trace:\n\n0. bin/tiflash/tiflash(StackTrace::StackTrace()+0x16) [0x370f6a6]\n1. bin/tiflash/tiflash(DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, int)+0x26) [0x37034a6]\n2. bin/tiflash/tiflash(bool DB::setColumnValues<(DB::TMTPKType)2>(DB::ColumnVector&, DB::ColumnVector&, std::vector<long, std::allocator >&, std::vector<std::pair<long, unsigned long>, std::allocator<std::pair<long, unsigned long> > > const&, google::dense_hash_map<long, unsigned long, std::hash, std::equal_to, google::libc_allocator_with_realloc<std::pair<long const, unsigned long> > >&, DB::ColumnDataInfoMap&, std::vector<std::tuple<DB::RawTiDBPK, unsigned char, unsigned long, std::shared_ptr<DB::StringObject const> >, std::allocator<std::tuple<DB::RawTiDBPK, unsigned char, unsigned long, std::shared_ptr<DB::StringObject const> > > > const&, unsigned long, bool, TiDB::TableInfo const&, bool, std::shared_ptrDB::RegionScanFilter)+0xed2) [0x77827d2]\n3. bin/tiflash/tiflash(DB::RegionBlockReader::read(std::vector<std::__cxx11::basic_string<char, std::char_traits, std::allocator >, std::allocator<std::__cxx11::basic_string<char, std::char_traits, std::allocator > > > const&, std::vector<std::tuple<DB::RawTiDBPK, unsigned char, unsigned long, std::shared_ptr<DB::StringObject const> >, std::allocator<std::tuple<DB::RawTiDBPK, unsigned char, unsigned long, std::shared_ptr<DB::StringObject const> > > >&, bool)+0x1074) [0x777c304]\n4. bin/tiflash/tiflash(DB::GenRegionBlockDataWithSchema(std::shared_ptrDB::Region const&, DB::DecodingStorageSchemaSnapshot const&, unsigned long, bool, DB::TMTContext&)+0x27b) [0x7763a7b]\n5. bin/tiflash/tiflash(DB::DM::SSTFilesToBlockInputStream::readCommitedBlock()+0xa3) [0x7ca0b43]\n6. bin/tiflash/tiflash(DB::DM::SSTFilesToBlockInputStream::read()+0x318) [0x7ca2068]\n7. bin/tiflash/tiflash(DB::DM::PKSquashingBlockInputStream::read()+0xe0) [0x7ca4be0]\n8. bin/tiflash/tiflash(DB::DM::DMVersionFilterBlockInputStream<1>::initNextBlock()+0x2f) [0x7aff5af]\n9. bin/tiflash/tiflash(DB::DM::DMVersionFilterBlockInputStream<1>::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>*&, bool)+0x1e99) [0x7b025e9]\n10. bin/tiflash/tiflash(DB::DM::BoundedSSTFilesToBlockInputStream::read()+0x29) [0x7ca0d29]\n11. bin/tiflash/tiflash(DB::DM::SSTFilesToDTFilesOutputStream::write()+0x4a) [0x7ca8e2a]\n12. bin/tiflash/tiflash(DB::KVStore::preHandleSSTsToDTFiles(std::shared_ptrDB::Region, DB::SSTViewVec, unsigned long, unsigned long, DB::DM::FileConvertJobType, DB::TMTContext&)+0x315) [0x7b337e5]\n13. bin/tiflash/tiflash(DB::KVStore::preHandleSnapshotToFiles(std::shared_ptrDB::Region, DB::SSTViewVec, unsigned long, unsigned long, DB::TMTContext&)+0x46) [0x7b34526]\n14. bin/tiflash/tiflash(PreHandleSnapshot+0xf4) [0x776e8f4]\n15. /ssd1/tiflash/deploy/bin/tiflash/libtiflash_proxy.so(+0xa26ee4) [0x7f48af37eee4]\n16. /ssd1/tiflash/deploy/bin/tiflash/libtiflash_proxy.so(+0xa0dc30) [0x7f48af365c30]\n17. /ssd1/tiflash/deploy/bin/tiflash/libtiflash_proxy.so(+0x11c5343) [0x7f48afb1d343]\n18. /ssd1/tiflash/deploy/bin/tiflash/libtiflash_proxy.so(+0x1d384e6) [0x7f48b06904e6]\n19. /ssd1/tiflash/deploy/bin/tiflash/libtiflash_proxy.so(+0x1d2eb78) [0x7f48b0686b78]\n20. /ssd1/tiflash/deploy/bin/tiflash/libtiflash_proxy.so(+0x1d3053b) [0x7f48b068853b]\n21. /ssd1/tiflash/deploy/bin/tiflash/libtiflash_proxy.so(+0x14f757b) [0x7f48afe4f57b]\n22. /lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3) [0x7f48ae70dfa3]\n23. /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f48ae4ba06f]\n”] [thread_id=32]
[2022/12/01 16:24:22.798 +08:00] [ERROR] [] [“pingcap.tikv: Get Failed4: Deadline Exceeded”] [thread_id=1]


这个数据插入不进去的吧,不会是 lighting local 模式直接强塞里面的?

不是,没有用过 lighting 导数据

你去数据库查一查 这个数据是否真实存在呢

你先看看这条数据是否真实存在?
另外把表结构也发下,看看能不能重现

最后是新建表重导数据跳过了这个问题

此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。