-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Connection left in a broken state (was: flaky test 03259_grouping_sets_aliases) #93018
Copy link
Copy link
Closed
Labels
flaky testflaky test found by CIflaky test found by CItestingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI
Description
Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.
Test name: 03259_grouping_sets_aliases
Failure reason: Unexpected packet from server
CI report: Stateless tests (arm_binary, parallel)
CIDB statistics: cidb
Test output:
2025-12-24 05:24:14 Reason: return code: 102
2025-12-24 05:24:14 [3af033d4abf6] 2025.12.24 08:24:14.377481 [ 58357 ] {7c51108c-64ab-4764-92d2-1d1f8d2c53f3} <Error> executeQuery: Code: 102. DB::Exception: Unexpected packet from server 127.0.0.2:9000 (expected TablesStatusResponse, got ProfileInfo): While executing Remote. (UNEXPECTED_PACKET_FROM_SERVER) (version 26.1.1.134) (from [::1]:36062) (comment: 03259_grouping_sets_aliases.sql-test_5zs17zfe) (query 4, line 6) (in query: SELECT user_level as level_alias, uniq(name) as name_alias, grouping(level_alias) as _totals FROM remote('127.0.0.{1,2}', currentDatabase(), users) GROUP BY GROUPING SETS ((level_alias)) ORDER BY name_alias DESC;), Stack trace (when copying this message, always include the lines below):
2025-12-24 05:24:14
2025-12-24 05:24:14 0. ./ci/tmp/build/./base/poco/Foundation/src/Exception.cpp:28: Poco::Exception::Exception(String const&, int) @ 0x000000001e708fb8
2025-12-24 05:24:14 1. ./ci/tmp/build/./src/Common/Exception.cpp:136: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000010e9c88c
2025-12-24 05:24:14 2. DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000ab9b258
2025-12-24 05:24:14 3. ./src/Common/NetException.h:26: DB::NetException::NetException<String const&, char const*&, String>(int, FormatStringHelperImpl<std::type_identity<String const&>::type, std::type_identity<char const*&>::type, std::type_identity<String>::type>, String const&, char const*&, String&&) @ 0x0000000019942034
2025-12-24 05:24:14 4. ./ci/tmp/build/./src/Client/Connection.cpp:1598: DB::Connection::throwUnexpectedPacket(DB::TimeoutSetter&, unsigned long, char const*) @ 0x00000000199382b4
2025-12-24 05:24:14 5. ./ci/tmp/build/./src/Client/Connection.cpp:793: DB::Connection::getTablesStatus(DB::ConnectionTimeouts const&, DB::TablesStatusRequest const&) @ 0x0000000019939c80
2025-12-24 05:24:14 6. ./ci/tmp/build/./src/Client/ConnectionEstablisher.cpp:76: DB::ConnectionEstablisher::run(PoolWithFailoverBase<DB::IConnectionPool>::TryResult&, String&, bool) @ 0x000000001994c89c
2025-12-24 05:24:14 7. ./ci/tmp/build/./src/Client/ConnectionEstablisher.cpp:159: DB::ConnectionEstablisherAsync::Task::run(std::function<void (int, Poco::Timespan, DB::AsyncEventTimeoutType, String const&, unsigned int)>, std::function<void ()>) @ 0x000000001994e154
2025-12-24 05:24:14 8. ./ci/tmp/build/./src/Common/AsyncTaskExecutor.cpp:89: DB::AsyncTaskExecutor::Routine::operator()(std::function<void ()>) @ 0x0000000015970e10
2025-12-24 05:24:14 9. ./src/Common/Fiber.h:76: void boost::context::detail::fiber_entry<boost::context::detail::fiber_record<boost::context::fiber, FiberStack&, Fiber::RoutineImpl<DB::AsyncTaskExecutor::Routine>>>(boost::context::detail::transfer_t) @ 0x0000000015970c0c
2025-12-24 05:24:14
2025-12-24 05:24:14 Received exception from server (version 26.1.1):
2025-12-24 05:24:14 Code: 102. DB::Exception: Received from localhost:9000. DB::Exception: Unexpected packet from server 127.0.0.2:9000 (expected TablesStatusResponse, got ProfileInfo): While executing Remote. (UNEXPECTED_PACKET_FROM_SERVER)
2025-12-24 05:24:14 (query: SELECT user_level as level_alias, uniq(name) as name_alias, grouping(level_alias) as _totals
2025-12-24 05:24:14 FROM remote('127.0.0.{1,2}', currentDatabase(), users)
2025-12-24 05:24:14 GROUP BY GROUPING SETS ((level_alias))
2025-12-24 05:24:14 ORDER BY name_alias DESC;)
2025-12-24 05:24:14 , result:
2025-12-24 05:24:14
2025-12-24 05:24:14
2025-12-24 05:24:14
2025-12-24 05:24:14 stdout:
2025-12-24 05:24:14
2025-12-24 05:24:14
2025-12-24 05:24:14 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 23043867 --max_read_buffer_size 909019 --prefer_localhost_replica 1 --max_block_size 88226 --max_joined_block_size_rows 36739 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 24 --max_threads 1 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 26 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 30937127 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 4315135769 --local_filesystem_read_method mmap --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 50 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 22 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 837592590 --min_compress_block_size 1496443 --max_compress_block_size 2442935 --merge_tree_compact_parts_min_granules_to_multibuffer_read 107 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 8075956 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --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.16 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 1 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --enable_vertical_final 0 --optimize_extract_common_expressions 0 --use_async_executor_for_materialized_views 1 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 0 --use_skip_indexes_if_final 1 --use_skip_indexes_on_data_read 0 --optimize_rewrite_like_perfect_affix 1 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 0 --allow_special_serialization_kinds_in_output_formats 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0 --use_skip_indexes_if_final_exact_mode 1
2025-12-24 05:24:14
2025-12-24 05:24:14 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 9535101611 --index_granularity_bytes 13136014 --merge_max_block_size 3695 --index_granularity 35901 --min_bytes_for_wide_part 541125029 --marks_compress_block_size 88801 --primary_key_compress_block_size 99881 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 432404040 --compact_parts_max_granules_to_buffer 72 --compact_parts_merge_max_bytes_to_prefetch_part 32517984 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 10 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 0 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 --object_serialization_version v3 --object_shared_data_serialization_version map --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 6 --object_shared_data_buckets_for_wide_part 4 --dynamic_serialization_version v2 --serialization_info_version with_types --string_serialization_version single_stream --nullable_serialization_version allow_sparse --enable_shared_storage_snapshot_in_query 1
2025-12-24 05:24:14
2025-12-24 05:24:14 Database: test_5zs17zfe
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
flaky testflaky test found by CIflaky test found by CItestingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI