-
Notifications
You must be signed in to change notification settings - Fork 8.3k
03352_concurrent_rename_alter is broken #83821
Copy link
Copy link
Closed
Labels
red CIVERY flaky testVERY flaky test
Description
2025-07-15 18:39:54 Reason: return code: 53
2025-07-15 18:39:54 [b167f5430a73] 2025.07.15 17:39:50.265361 [ 108753 ] {16ec3505-e7d2-46d7-bfc1-52add145164b} <Error> executeQuery: Code: 53. DB::Exception: CAST AS Tuple can only be performed between tuple types with the same number of elements or from String.
2025-07-15 18:39:54 Left type: Tuple(DateTime, UInt64, String, String), right type: Tuple(DateTime, UInt64, String, String, String): While processing _CAST(arr, 'Array(Tuple(DateTime, UInt64, String, String, String))') AS arr: (while reading from part /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/store/d0f/d0f0597c-6ca1-4622-986f-532197157e88/all_18_18_0_21/ located on disk default of type local): While executing MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder). (TYPE_MISMATCH) (version 25.7.1.1) (from [::1]:35210) (comment: 03352_concurrent_rename_alter.sh) (query 1, line 2) (in query: SELECT count() > 0 FROM t_rename_alter WHERE NOT ignore(*);), Stack trace (when copying this message, always include the lines below):
2025-07-15 18:39:54
2025-07-15 18:39:54 0. ./ci/tmp/build/./base/poco/Foundation/src/Exception.cpp:28: Poco::Exception::Exception(String const&, int) @ 0x00000000320d3998
2025-07-15 18:39:54 1. ./ci/tmp/build/./src/Common/Exception.cpp:115: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001f449988
2025-07-15 18:39:54 2. ./src/Common/Exception.h:119: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000001638d6cc
2025-07-15 18:39:54 3. ./src/Common/Exception.h:137: DB::Exception::Exception<String, String>(int, FormatStringHelperImpl<std::type_identity<String>::type, std::type_identity<String>::type>, String&&, String&&) @ 0x000000001638cefc
2025-07-15 18:39:54 4. ./src/Functions/FunctionsConversion.h:4725: DB::detail::FunctionCast::createTupleWrapper(std::shared_ptr<DB::IDataType const> const&, DB::DataTypeTuple const*) const @ 0x0000000024f4e62c
2025-07-15 18:39:54 5. ./src/Functions/FunctionsConversion.h:6418: DB::detail::FunctionCast::prepareImpl(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&, bool) const @ 0x0000000024f4ce90
2025-07-15 18:39:54 6. ./src/Functions/FunctionsConversion.h:6137: DB::detail::FunctionCast::prepareRemoveNullable(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&, bool) const @ 0x0000000024f33818
2025-07-15 18:39:54 7. ./src/Functions/FunctionsConversion.h:6064: DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const @ 0x0000000024f31d34
2025-07-15 18:39:54 8. ./src/Functions/FunctionsConversion.h:4618: DB::detail::FunctionCast::createArrayWrapper(std::shared_ptr<DB::IDataType const> const&, DB::DataTypeArray const&) const @ 0x0000000024f4dd14
2025-07-15 18:39:54 9. ./src/Functions/FunctionsConversion.h:6416: DB::detail::FunctionCast::prepareImpl(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&, bool) const @ 0x0000000024f4c050
2025-07-15 18:39:54 10. ./src/Functions/FunctionsConversion.h:6137: DB::detail::FunctionCast::prepareRemoveNullable(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&, bool) const @ 0x0000000024f33818
2025-07-15 18:39:54 11. ./src/Functions/FunctionsConversion.h:6064: DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const @ 0x0000000024f31d34
2025-07-15 18:39:54 12. ./src/Functions/FunctionsConversion.h:4157: DB::detail::FunctionCast::prepare(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&) const @ 0x0000000024f313bc
2025-07-15 18:39:54 13. ./ci/tmp/build/./src/Interpreters/ActionsDAG.cpp:403: DB::ActionsDAG::addFunctionImpl(std::shared_ptr<DB::IFunctionBase const> const&, std::vector<DB::ActionsDAG::Node const*, std::allocator<DB::ActionsDAG::Node const*>>, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>, String, std::shared_ptr<DB::IDataType const>, bool) @ 0x000000002695d07c
2025-07-15 18:39:54 14. ./ci/tmp/build/./src/Interpreters/ActionsDAG.cpp:330: DB::ActionsDAG::addFunction(std::shared_ptr<DB::IFunctionOverloadResolver> const&, std::vector<DB::ActionsDAG::Node const*, std::allocator<DB::ActionsDAG::Node const*>>, String) @ 0x000000002695c4d8
2025-07-15 18:39:54 15. ./ci/tmp/build/./src/Interpreters/ActionsVisitor.cpp:697: DB::ScopeStack::addFunction(std::shared_ptr<DB::IFunctionOverloadResolver> const&, std::vector<String, std::allocator<String>> const&, String) @ 0x00000000277e4b1c
2025-07-15 18:39:54 16. ./src/Interpreters/ActionsMatcher.h:178: DB::ActionsMatcher::Data::addFunction(std::shared_ptr<DB::IFunctionOverloadResolver> const&, std::vector<String, std::allocator<String>> const&, String) @ 0x00000000277f103c
2025-07-15 18:39:54 17. ./ci/tmp/build/./src/Interpreters/ActionsVisitor.cpp:1366: DB::ActionsMatcher::visit(DB::ASTFunction const&, std::shared_ptr<DB::IAST> const&, DB::ActionsMatcher::Data&) @ 0x00000000277ea5e0
2025-07-15 18:39:54 18. ./src/Interpreters/InDepthNodeVisitor.h:71: DB::InDepthNodeVisitor<DB::ActionsMatcher, true, false, std::shared_ptr<DB::IAST> const>::doVisit(std::shared_ptr<DB::IAST> const&) @ 0x00000000277daa70
2025-07-15 18:39:54 19. ./src/Interpreters/InDepthNodeVisitor.h:61: DB::ExpressionAnalyzer::getRootActions(std::shared_ptr<DB::IAST> const&, bool, DB::ActionsDAG&, bool) @ 0x00000000277b8bcc
2025-07-15 18:39:54 20. ./ci/tmp/build/./src/Interpreters/ExpressionAnalyzer.cpp:1870: DB::ExpressionAnalyzer::getActionsDAG(bool, bool) @ 0x00000000277cfabc
2025-07-15 18:39:54 21. ./ci/tmp/build/./src/Interpreters/inplaceBlockConversions.cpp:172: DB::(anonymous namespace)::createExpressions(DB::Block const&, std::shared_ptr<DB::IAST>, bool, std::shared_ptr<DB::Context const>) @ 0x0000000027de8e30
2025-07-15 18:39:54 22. ./ci/tmp/build/./src/Interpreters/inplaceBlockConversions.cpp:184: DB::performRequiredConversions(DB::Block&, DB::NamesAndTypesList const&, std::shared_ptr<DB::Context const>) @ 0x0000000027de8614
2025-07-15 18:39:54 23. ./ci/tmp/build/./src/Storages/MergeTree/IMergeTreeReader.cpp:336: DB::IMergeTreeReader::performRequiredConversions(std::vector<COW<DB::IColumn>::immutable_ptr<DB::IColumn>, std::allocator<COW<DB::IColumn>::immutable_ptr<DB::IColumn>>>&) const @ 0x000000002bccecf8
2025-07-15 18:39:54 24. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeReadersChain.cpp:165: DB::MergeTreeReadersChain::executeActionsBeforePrewhere(DB::MergeTreeRangeReader::ReadResult&, std::vector<COW<DB::IColumn>::immutable_ptr<DB::IColumn>, std::allocator<COW<DB::IColumn>::immutable_ptr<DB::IColumn>>>&, DB::MergeTreeRangeReader&, DB::Block const&, unsigned long) const @ 0x000000002c0a9e8c
2025-07-15 18:39:54 25. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeReadersChain.cpp:84: DB::MergeTreeReadersChain::read(unsigned long, DB::MarkRanges&, std::vector<DB::MarkRanges, std::allocator<DB::MarkRanges>>&) @ 0x000000002c0a8a9c
2025-07-15 18:39:54 26. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeReadTask.cpp:221: DB::MergeTreeReadTask::read() @ 0x000000002c0a6014
2025-07-15 18:39:54 27. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeSelectProcessor.cpp:228: DB::MergeTreeSelectProcessor::read() @ 0x000000002c0b9734
2025-07-15 18:39:54 28. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeSource.cpp:229: DB::MergeTreeSource::tryGenerate() @ 0x000000002cfad538
2025-07-15 18:39:54 29. ./ci/tmp/build/./src/Processors/ISource.cpp:110: DB::ISource::work() @ 0x000000002c882a88
2025-07-15 18:39:54 30. ./ci/tmp/build/./src/Processors/Executors/ExecutionThreadContext.cpp:53: DB::ExecutionThreadContext::executeTask() @ 0x000000002c8a6fd8
2025-07-15 18:39:54 31. ./ci/tmp/build/./src/Processors/Executors/PipelineExecutor.cpp:306: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic<bool>*) @ 0x000000002c897584
2025-07-15 18:39:54
2025-07-15 18:39:54 Received exception from server (version 25.7.1):
2025-07-15 18:39:54 Code: 53. DB::Exception: Received from localhost:9000. DB::Exception: CAST AS Tuple can only be performed between tuple types with the same number of elements or from String.
2025-07-15 18:39:54 Left type: Tuple(DateTime, UInt64, String, String), right type: Tuple(DateTime, UInt64, String, String, String): While processing _CAST(arr, 'Array(Tuple(DateTime, UInt64, String, String, String))') AS arr: (while reading from part /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/store/d0f/d0f0597c-6ca1-4622-986f-532197157e88/all_18_18_0_21/ located on disk default of type local): While executing MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder). (TYPE_MISMATCH)
2025-07-15 18:39:54 (query: SELECT count() > 0 FROM t_rename_alter WHERE NOT ignore(*);)
2025-07-15 18:39:54
2025-07-15 18:39:54 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_hz2ooo7i/03352_concurrent_rename_alter.sh.debuglog:
2025-07-15 18:39:54 + [2025-07-15 18:35:16] [:9] . /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/mergetree_mutations.lib
2025-07-15 18:39:54 + [2025-07-15 18:35:16] [:11] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_hz2ooo7i --log_comment 03352_concurrent_rename_alter.sh --max_insert_threads 3 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 18657170 --max_read_buffer_size 720085 --prefer_localhost_replica 0 --max_block_size 80858 --max_joined_block_size_rows 15237 --max_threads 3 --optimize_append_index 1 --use_hedged_requests 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 7 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 23075898 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --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 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 9 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1436067045 --min_compress_block_size 721991 --max_compress_block_size 1889200 --merge_tree_compact_parts_min_granules_to_multibuffer_read 9 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 6092366 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Europe/Amsterdam --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.94 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 0 --max_parsing_threads 1 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --enable_vertical_final 0 --optimize_extract_common_expressions 1 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 0 --use_skip_indexes_if_final 0 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.2 --max_bytes_ratio_before_external_group_by 0.0 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 6099140 --merge_max_block_size 15005 --index_granularity 59283 --min_bytes_for_wide_part 0 --marks_compress_block_size 36905 --primary_key_compress_block_size 90540 --replace_long_file_name_to_hash 0 --max_file_name_length 0 --min_bytes_for_full_part_storage 207485278 --compact_parts_max_bytes_to_buffer 505702332 --compact_parts_max_granules_to_buffer 46 --compact_parts_merge_max_bytes_to_prefetch_part 29302401 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 100 --old_parts_lifetime 344 --prewarm_mark_cache 1 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03352_concurrent_rename_alter.stderr-fatal --query '
2025-07-15 18:39:54 DROP TABLE IF EXISTS t_rename_alter SYNC;
2025-07-15 18:39:54
2025-07-15 18:39:54 CREATE TABLE t_rename_alter
2025-07-15 18:39:54 (
2025-07-15 18:39:54 id UInt64,
2025-07-15 18:39:54 dt DateTime DEFAULT now(),
2025-07-15 18:39:54 arr Array(Tuple(DateTime, UInt64, String, String)) TTL dt + INTERVAL 3 MONTHS
2025-07-15 18:39:54 )
2025-07-15 18:39:54 ENGINE = ReplicatedMergeTree('\''/clickhouse/tables/{database}/t_rename_alter'\'', '\''1'\'') ORDER BY id;
2025-07-15 18:39:54
2025-07-15 18:39:54 INSERT INTO t_rename_alter (id) VALUES (1);
2025-07-15 18:39:54 '
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:49] export -f insert1
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:50] export -f insert2
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:51] export -f select1
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:53] TIMEOUT=8
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:55] for _ in {0..4}
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:56] timeout 8 bash -c insert1
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:57] timeout 8 bash -c insert2
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:55] for _ in {0..4}
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:58] timeout 8 bash -c select1
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:56] timeout 8 bash -c insert1
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:57] timeout 8 bash -c insert2
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:55] for _ in {0..4}
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:58] timeout 8 bash -c select1
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:56] timeout 8 bash -c insert1
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:57] timeout 8 bash -c insert2
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:55] for _ in {0..4}
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:58] timeout 8 bash -c select1
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:55] for _ in {0..4}
2025-07-15 18:39:54 + [2025-07-15 18:35:17] [:61] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_hz2ooo7i --log_comment 03352_concurrent_rename_alter.sh --max_insert_threads 3 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 18657170 --max_read_buffer_size 720085 --prefer_localhost_replica 0 --max_block_size 80858 --max_joined_block_size_rows 15237 --max_threads 3 --optimize_append_index 1 --use_hedged_requests 0 --optimize_if_chain_to_multiif 0 --optimiz
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
red CIVERY flaky testVERY flaky test