Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: tiflash v5.3.1添加副本报错Detected overflow when decoding data
[TiDB Usage Environment] Production Environment
[TiDB Version] 5.3.1
[Reproduction Path] alter table x.y set tiflash replica 1;
[Encountered Issue: Problem Phenomenon and Impact]
Issue: Adding TiFlash replica causes TiFlash node error
Phenomenon: Unable to add TiFlash replica, error: Detected overflow when decoding data 18446744073709551615 of column ipnum with type Nullable(UInt32)
The table is partitioned by day range, and the corresponding field definition in the error log is: ipnum
int(10) unsigned DEFAULT NULL
[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]
[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]