Clickhouse MergeFromLogEntryTask: Code: 74. DB::ErrnoException: Cannot read from file

245 views
Skip to first unread message

Rishabh Shah

unread,
Mar 15, 2022, 5:57:41 AM3/15/22
to ClickHouse
Hello Everyone

We have upgraded Clickhouse version form 20.8.12.2 ⇾ 21.12.4.1

After upgrading, we are getting this error on some node only (instance):

MergeFromLogEntryTask: virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): Code: 74. DB::ErrnoException: Cannot read from file /mnt/local/clickhouse/data/default/Metrics/e4ff46e55238867b9ad76fa7f690df39_0_6410_8_7603/appId.bin, errno: 22, strerror: Invalid argument: (while reading column appId): (while reading from part /mnt/local/clickhouse/data/default/Metrics/e4ff46e55238867b9ad76fa7f690df39_0_6410_8_7603/ from mark 49842 with max_rows_to_read = 8192): While executing MergeTreeSequentialSource. (CANNOT_READ_FROM_FILE_DESCRIPTOR), Stack trace (when copying this message, always include the lines below): 0. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ 0xa21a61a in /usr/bin/clickhouse


****************************************

our assumption:
 - while merging the larger amount of data into new version generates the above error

can anyone please confirm this issue?
thus our assumption is correct?
what are the ways to resolve the issue?
if issue is caused while merging the larger data then how we could increasing the data merging speed and resolved the issue?
Will this stop on its own after a while?


any help would be appreciated.    

Reply all
Reply to author
Forward
0 new messages