2024-09-13 09:04:58 Reason: return code:  158
2024-09-13 09:04:58 Expected server error code: 160 but got: 158 (query: SELECT count() FROM system.numbers; -- { serverError TOO_SLOW }).
2024-09-13 09:04:58 Received exception from server (version 24.9.1):
2024-09-13 09:04:58 Code: 158. DB::Exception: Received from localhost:9000. DB::Exception: Limit for rows or bytes to read exceeded, max rows: 20.00 million, current rows: 20.07 million: While executing NumbersRange. (TOO_MANY_ROWS)
2024-09-13 09:04:58 (query: SELECT count() FROM system.numbers; -- { serverError TOO_SLOW })
2024-09-13 09:04:58 , result:
2024-09-13 09:04:58 
2024-09-13 09:04:58 
2024-09-13 09:04:58 
2024-09-13 09:04:58 stdout:
2024-09-13 09:04:58 
2024-09-13 09:04:58 
2024-09-13 09:04:58 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 289985 --group_by_two_level_threshold_bytes 27714040 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 11413974 --max_read_buffer_size 563609 --prefer_localhost_replica 0 --max_block_size 68019 --max_joined_block_size_rows 97172 --max_threads 3 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 32 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 35498743 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 7088145485 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method io_uring --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 7 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 736252525 --min_compress_block_size 2832507 --max_compress_block_size 2433365 --merge_tree_compact_parts_min_granules_to_multibuffer_read 11 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 7641961 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Atlantic/Bermuda --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.2 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1
2024-09-13 09:04:58 
2024-09-13 09:04:58 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 7950932953 --vertical_merge_algorithm_min_rows_to_activate 109599 --vertical_merge_algorithm_min_columns_to_activate 66 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 4746153014 --index_granularity_bytes 20478828 --merge_max_block_size 5054 --index_granularity 32653 --min_bytes_for_wide_part 0 --marks_compress_block_size 83556 --primary_key_compress_block_size 86721 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 200183159 --compact_parts_max_bytes_to_buffer 255729305 --compact_parts_max_granules_to_buffer 164 --compact_parts_merge_max_bytes_to_prefetch_part 21120690 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 0 --old_parts_lifetime 10
2024-09-13 09:04:58 
2024-09-13 09:04:58 Database: test_l90qmel4