-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Functional tests with S3 are broken (CANNOT_READ_ALL_DATA) #38180
Copy link
Copy link
Closed
Labels
testingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI
Description
01184_long_insert_values_huge_strings
2022-06-16 17:20:50 [bbcc2487a53f] 2022.06.16 17:20:49.591615 [ 54674 ] {9f51ee83-2c6b-4e81-9317-7b70d64d4902} executeQuery: Code: 33. DB::Exception: Cannot read all data. Bytes read: 7971504. Bytes expected: 8000000.: (while reading column s): (while reading from part /var/lib/clickhouse/disks/s3/store/1ff/1ff51ba8-1552-4174-b43e-8f763f7109fb/all_12_12_0/ from mark 0 with max_rows_to_read = 1): While executing MergeTreeInOrder. (CANNOT_READ_ALL_DATA) (version 22.7.1.65) (from [::1]:43282) (comment: '01184_long_insert_values_huge_strings.sh') (in query: select sum(l = length(s)) from huge_strings), Stack trace (when copying this message, always include the lines below):
2022-06-16 17:20:50
2022-06-16 17:20:50 0. DB::Exception::Exception(std::__1::basic_string, std::__1::allocator > const&, int, bool) @ 0xb8aad3a in /usr/bin/clickhouse
2022-06-16 17:20:50 1. DB::ReadBuffer::readStrict(char*, unsigned long) @ 0xb908052 in /usr/bin/clickhouse
2022-06-16 17:20:50 2. ? @ 0x1587af51 in /usr/bin/clickhouse
2022-06-16 17:20:50 3. DB::ISerialization::deserializeBinaryBulkWithMultipleStreams(COW::immutable_ptr&, unsigned long, DB::ISerialization::DeserializeBinaryBulkSettings&, std::__1::shared_ptr&, std::__1::unordered_map, std::__1::allocator >, COW::immutable_ptr, std::__1::hash, std::__1::allocator > >, std::__1::equal_to, std::__1::allocator > >, std::__1::allocator, std::__1::allocator > const, COW::immutable_ptr > > >*) const @ 0x15837f55 in /usr/bin/clickhouse
2022-06-16 17:20:50 4. DB::MergeTreeReaderWide::readData(DB::NameAndTypePair const&, COW::immutable_ptr&, unsigned long, bool, unsigned long, unsigned long, std::__1::unordered_map, std::__1::allocator >, COW::immutable_ptr, std::__1::hash, std::__1::allocator > >, std::__1::equal_to, std::__1::allocator > >, std::__1::allocator, std::__1::allocator > const, COW::immutable_ptr > > >&, bool) @ 0x16cb540f in /usr/bin/clickhouse
2022-06-16 17:20:50 5. DB::MergeTreeReaderWide::readRows(unsigned long, unsigned long, bool, unsigned long, std::__1::vector::immutable_ptr, std::__1::allocator::immutable_ptr > >&) @ 0x16cb435e in /usr/bin/clickhouse
2022-06-16 17:20:50 6. DB::MergeTreeRangeReader::DelayedStream::finalize(std::__1::vector::immutable_ptr, std::__1::allocator::immutable_ptr > >&) @ 0x174c3aca in /usr/bin/clickhouse
2022-06-16 17:20:50 7. DB::MergeTreeRangeReader::startReadingChain(unsigned long, std::__1::deque >&) @ 0x174c986b in /usr/bin/clickhouse
2022-06-16 17:20:50 8. DB::MergeTreeRangeReader::read(unsigned long, std::__1::deque >&) @ 0x174c75a5 in /usr/bin/clickhouse
2022-06-16 17:20:50 9. DB::MergeTreeBaseSelectProcessor::readFromPartImpl() @ 0x174bc920 in /usr/bin/clickhouse
2022-06-16 17:20:50 10. DB::MergeTreeBaseSelectProcessor::readFromPart() @ 0x174bd44d in /usr/bin/clickhouse
2022-06-16 17:20:50 11. DB::MergeTreeBaseSelectProcessor::generate() @ 0x174bba1f in /usr/bin/clickhouse
2022-06-16 17:20:50 12. DB::ISource::tryGenerate() @ 0x1718b4f5 in /usr/bin/clickhouse
2022-06-16 17:20:50 13. DB::ISource::work() @ 0x1718b086 in /usr/bin/clickhouse
2022-06-16 17:20:50 14. DB::ExecutionThreadContext::executeTask() @ 0x171a741a in /usr/bin/clickhouse
2022-06-16 17:20:50 15. DB::PipelineExecutor::executeStepImpl(unsigned long, std::__1::atomic*) @ 0x1719c33e in /usr/bin/clickhouse
2022-06-16 17:20:50 16. DB::PipelineExecutor::executeImpl(unsigned long) @ 0x1719b341 in /usr/bin/clickhouse
2022-06-16 17:20:50 17. DB::PipelineExecutor::execute(unsigned long) @ 0x1719b0d8 in /usr/bin/clickhouse
2022-06-16 17:20:50 18. ? @ 0x171ab28e in /usr/bin/clickhouse
2022-06-16 17:20:50 19. ThreadPoolImpl::worker(std::__1::__list_iterator) @ 0xb956937 in /usr/bin/clickhouse
2022-06-16 17:20:50 20. ? @ 0xb959d5d in /usr/bin/clickhouse
2022-06-16 17:20:50 21. ? @ 0x7f20d9c71609 in ?
2022-06-16 17:20:50 22. __clone @ 0x7f20d9b96133 in ?
2022-06-16 17:20:50
2022-06-16 17:20:50 Received exception from server (version 22.7.1):
2022-06-16 17:20:50 Code: 33. DB::Exception: Received from localhost:9000. DB::Exception: Cannot read all data. Bytes read: 7971504. Bytes expected: 8000000.: (while reading column s): (while reading from part /var/lib/clickhouse/disks/s3/store/1ff/1ff51ba8-1552-4174-b43e-8f763f7109fb/all_12_12_0/ from mark 0 with max_rows_to_read = 1): While executing MergeTreeInOrder. (CANNOT_READ_ALL_DATA)
2022-06-16 17:20:50 (query: select sum(l = length(s)) from huge_strings)
2022-06-16 17:20:50
2022-06-16 17:20:50 stdout:
2022-06-16 17:20:50 1000100
2022-06-16 17:20:50 1000100
2022-06-16 17:20:50
2022-06-16 17:20:50
2022-06-16 17:20:50 Settings used in the test: --max_insert_threads=2 --group_by_two_level_threshold=100000 --group_by_two_level_threshold_bytes=50000000 --distributed_aggregation_memory_efficient=0 --fsync_metadata=0 --output_format_parallel_formatting=0 --input_format_parallel_parsing=1 --min_chunk_bytes_for_parallel_parsing=12070086 --max_read_buffer_size=953911 --prefer_localhost_replica=1 --max_block_size=23072 --max_threads=1 --optimize_or_like_chain=1
2022-06-16 17:20:50
2022-06-16 17:20:50 Database: test_gydqo8
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
testingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI