Skip to content

Functional tests with S3 are broken (CANNOT_READ_ALL_DATA)  #38180

@qoega

Description

@qoega

01184_long_insert_values_huge_strings

Master
https://s3.amazonaws.com/clickhouse-test-reports/0/299f102ccf92e1ea001ad9483171f75f33cb75bc/stateless_tests__release__s3_storage__actions_.html

PR
https://s3.amazonaws.com/clickhouse-test-reports/38157/6fdcac1c9d109b3f9bddffc9b5e652d5fcd3bde8/stateless_tests__release__s3_storage__actions_.html

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    testingSpecial issue with list of bugs found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions