2025-07-06 11:12:18 Reason: having stderror:  
2025-07-06 11:12:18 [e977223cbd5f] 2025.07.05 20:12:11.663553 [ 23129 ] {5a9e4213-ebe2-4b84-a910-a61732f0f6a1} <Error> void DB::MetadataOperationsHolder::commitImpl(SharedMutex &): Code: 521. DB::ErrnoException: Cannot rename /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/disks/s3/store/bd9/bd99f456-f1c2-4836-9e4a-8bbba677fa32/detached/all_48_48_0 to /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/disks/s3/store/bd9/bd99f456-f1c2-4836-9e4a-8bbba677fa32/detached/attaching_all_48_48_0 because the second path already exists: , errno: 17, strerror: File exists. (ATOMIC_RENAME_FAIL), Stack trace (when copying this message, always include the lines below):
2025-07-06 11:12:18 
2025-07-06 11:12:18 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x0000000028120ca0
2025-07-06 11:12:18 1. ./ci/tmp/build/./src/Common/Exception.cpp:115: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000128dd0d4
2025-07-06 11:12:18 2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x0000000008de8520
2025-07-06 11:12:18 3. ./src/Common/Exception.h:235: DB::ErrnoException::ErrnoException<String const&, String const&>(int, FormatStringHelperImpl<std::type_identity<String const&>::type, std::type_identity<String const&>::type>, String const&, String const&) @ 0x000000001986f9a8
2025-07-06 11:12:18 4. ./ci/tmp/build/./src/Common/atomicRename.cpp:94: DB::renameat2(String const&, String const&, int) @ 0x000000001986f6ec
2025-07-06 11:12:18 5. ./ci/tmp/build/./src/Common/atomicRename.cpp:227: DB::renameNoReplace(String const&, String const&) @ 0x000000001986f0f0
2025-07-06 11:12:18 6. ./ci/tmp/build/./src/Disks/DiskLocal.cpp:318: DB::DiskLocal::moveFile(String const&, String const&) @ 0x0000000019aff7ac
2025-07-06 11:12:18 7. ./ci/tmp/build/./src/Disks/ObjectStorages/MetadataStorageFromDiskTransactionOperations.cpp:214: DB::MoveFileOperation::execute(std::unique_lock<DB::SharedMutex>&) @ 0x0000000019bb2b25
2025-07-06 11:12:18 8. ./ci/tmp/build/./src/Disks/ObjectStorages/MetadataOperationsHolder.cpp:65: DB::MetadataOperationsHolder::commitImpl(DB::SharedMutex&) @ 0x0000000019bb7ee1
2025-07-06 11:12:18 9. ./ci/tmp/build/./src/Disks/ObjectStorages/MetadataStorageFromDisk.cpp:165: DB::MetadataStorageFromDiskTransaction::commit() @ 0x0000000019baa5f0
2025-07-06 11:12:18 10. ./ci/tmp/build/./src/Disks/ObjectStorages/DiskObjectStorageTransaction.cpp:988: DB::DiskObjectStorageTransaction::commit() @ 0x0000000019b739de
2025-07-06 11:12:18 11. ./ci/tmp/build/./src/Disks/ObjectStorages/DiskObjectStorage.cpp:227: DB::DiskObjectStorage::moveFile(String const&, String const&) @ 0x0000000019b597f8
2025-07-06 11:12:18 12. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeData.cpp:4338: DB::MergeTreeData::PartsTemporaryRename::tryRenameAll() @ 0x000000001eae1c19
2025-07-06 11:12:18 13. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeData.cpp:7057: DB::MergeTreeData::tryLoadPartsToAttach(std::shared_ptr<DB::IAST> const&, bool, std::shared_ptr<DB::Context const>, DB::MergeTreeData::PartsTemporaryRename&) @ 0x000000001eb18b28
2025-07-06 11:12:18 14. ./ci/tmp/build/./src/Storages/StorageReplicatedMergeTree.cpp:7051: DB::StorageReplicatedMergeTree::attachPartition(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, bool, std::shared_ptr<DB::Context const>) @ 0x000000001e4779b5
2025-07-06 11:12:18 15. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeData.cpp:5967: DB::MergeTreeData::alterPartition(std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::vector<DB::PartitionCommand, std::allocator<DB::PartitionCommand>> const&, std::shared_ptr<DB::Context const>) @ 0x000000001eb0488e
2025-07-06 11:12:18 16. ./ci/tmp/build/./src/Interpreters/InterpreterAlterQuery.cpp:243: DB::InterpreterAlterQuery::executeToTable(DB::ASTAlterQuery const&) @ 0x000000001aeb534c
2025-07-06 11:12:18 17. ./ci/tmp/build/./src/Interpreters/InterpreterAlterQuery.cpp:78: DB::InterpreterAlterQuery::execute() @ 0x000000001aeb21e3
2025-07-06 11:12:18 18. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1561: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>) @ 0x000000001b3f606e
2025-07-06 11:12:18 19. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1769: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001b3f099b
2025-07-06 11:12:18 20. ./ci/tmp/build/./src/Server/TCPHandler.cpp:723: DB::TCPHandler::runImpl() @ 0x000000001f3d1e64
2025-07-06 11:12:18 21. ./ci/tmp/build/./src/Server/TCPHandler.cpp:2757: DB::TCPHandler::run() @ 0x000000001f3f9808
2025-07-06 11:12:18 22. ./ci/tmp/build/./base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x0000000028230ee3
2025-07-06 11:12:18 23. ./ci/tmp/build/./base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x0000000028231752
2025-07-06 11:12:18 24. ./ci/tmp/build/./base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x00000000281a6d63
2025-07-06 11:12:18 25. ./ci/tmp/build/./base/poco/Foundation/src/Thread.cpp:45: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x00000000281a5130
2025-07-06 11:12:18 26. ./base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000281a34ea
2025-07-06 11:12:18 27. __tsan_thread_start_func @ 0x0000000008d5b428
2025-07-06 11:12:18 28. ? @ 0x0000000000094ac3
2025-07-06 11:12:18 29. ? @ 0x0000000000126850
2025-07-06 11:12:18  (version 25.7.1.2493 (official build))
2025-07-06 11:12:18 [e977223cbd5f] 2025.07.05 20:12:11.668188 [ 23129 ] {5a9e4213-ebe2-4b84-a910-a61732f0f6a1} <Warning> test_493rvzud.alter_table1 (bd99f456-f1c2-4836-9e4a-8bbba677fa32): Cannot rename parts to perform operation on them: Code: 521. DB::ErrnoException: Cannot rename /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/disks/s3/store/bd9/bd99f456-f1c2-4836-9e4a-8bbba677fa32/detached/attaching_all_48_48_0 to /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/disks/s3/store/bd9/bd99f456-f1c2-4836-9e4a-8bbba677fa32/detached/all_48_48_0 because the second path already exists: , errno: 17, strerror: File exists: While rolling back operation #0. (ATOMIC_RENAME_FAIL) (version 25.7.1.2493 (official build))
2025-07-06 11:12:18 [e977223cbd5f] 2025.07.05 20:12:11.670191 [ 23129 ] {5a9e4213-ebe2-4b84-a910-a61732f0f6a1} <Error> executeQuery: Code: 521. DB::ErrnoException: Cannot rename /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/disks/s3/store/bd9/bd99f456-f1c2-4836-9e4a-8bbba677fa32/detached/attaching_all_48_48_0 to /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/disks/s3/store/bd9/bd99f456-f1c2-4836-9e4a-8bbba677fa32/detached/all_48_48_0 because the second path already exists: , errno: 17, strerror: File exists: While rolling back operation #0. (ATOMIC_RENAME_FAIL) (version 25.7.1.2493 (official build)) (from [::1]:36050) (comment: 02443_detach_attach_partition.sh) (query 1, line 1) (in query: ALTER TABLE alter_table1 ATTACH PARTITION ID 'all'), Stack trace (when copying this message, always include the lines below):
2025-07-06 11:12:18 
2025-07-06 11:12:18 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x0000000028120ca0
2025-07-06 11:12:18 1. ./ci/tmp/build/./src/Common/Exception.cpp:115: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000128dd0d4
2025-07-06 11:12:18 2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x0000000008de8520
2025-07-06 11:12:18 3. ./src/Common/Exception.h:235: DB::ErrnoException::ErrnoException<String const&, String const&>(int, FormatStringHelperImpl<std::type_identity<String const&>::type, std::type_identity<String const&>::type>, String const&, String const&) @ 0x000000001986f9a8
2025-07-06 11:12:18 4. ./ci/tmp/build/./src/Common/atomicRename.cpp:94: DB::renameat2(String const&, String const&, int) @ 0x000000001986f6ec
2025-07-06 11:12:18 5. ./ci/tmp/build/./src/Common/atomicRename.cpp:227: DB::renameNoReplace(String const&, String const&) @ 0x000000001986f0f0
2025-07-06 11:12:18 6. ./ci/tmp/build/./src/Disks/DiskLocal.cpp:318: DB::DiskLocal::moveFile(String const&, String const&) @ 0x0000000019aff7ac
2025-07-06 11:12:18 7. ./ci/tmp/build/./src/Disks/ObjectStorages/MetadataStorageFromDiskTransactionOperations.cpp:219: DB::MoveFileOperation::undo(std::unique_lock<DB::SharedMutex>&) @ 0x0000000019bb2ba5
2025-07-06 11:12:18 8. ./ci/tmp/build/./src/Disks/ObjectStorages/MetadataOperationsHolder.cpp:22: DB::MetadataOperationsHolder::rollback(std::unique_lock<DB::SharedMutex>&, unsigned long) @ 0x0000000019bb79ff
2025-07-06 11:12:18 9. ./ci/tmp/build/./src/Disks/ObjectStorages/MetadataOperationsHolder.cpp:72: DB::MetadataOperationsHolder::commitImpl(DB::SharedMutex&) @ 0x0000000019bb82bb
2025-07-06 11:12:18 10. ./ci/tmp/build/./src/Disks/ObjectStorages/MetadataStorageFromDisk.cpp:165: DB::MetadataStorageFromDiskTransaction::commit() @ 0x0000000019baa5f0
2025-07-06 11:12:18 11. ./ci/tmp/build/./src/Disks/ObjectStorages/DiskObjectStorageTransaction.cpp:988: DB::DiskObjectStorageTransaction::commit() @ 0x0000000019b739de
2025-07-06 11:12:18 12. ./ci/tmp/build/./src/Disks/ObjectStorages/DiskObjectStorage.cpp:227: DB::DiskObjectStorage::moveFile(String const&, String const&) @ 0x0000000019b597f8
2025-07-06 11:12:18 13. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeData.cpp:4338: DB::MergeTreeData::PartsTemporaryRename::tryRenameAll() @ 0x000000001eae1c19
2025-07-06 11:12:18 14. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeData.cpp:7057: DB::MergeTreeData::tryLoadPartsToAttach(std::shared_ptr<DB::IAST> const&, bool, std::shared_ptr<DB::Context const>, DB::MergeTreeData::PartsTemporaryRename&) @ 0x000000001eb18b28
2025-07-06 11:12:18 15. ./ci/tmp/build/./src/Storages/StorageReplicatedMergeTree.cpp:7051: DB::StorageReplicatedMergeTree::attachPartition(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, bool, std::shared_ptr<DB::Context const>) @ 0x000000001e4779b5
2025-07-06 11:12:18 16. ./ci/tmp/build/./src/Storages/MergeTree/MergeTreeData.cpp:5967: DB::MergeTreeData::alterPartition(std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::vector<DB::PartitionCommand, std::allocator<DB::PartitionCommand>> const&, std::shared_ptr<DB::Context const>) @ 0x000000001eb0488e
2025-07-06 11:12:18 17. ./ci/tmp/build/./src/Interpreters/InterpreterAlterQuery.cpp:243: DB::InterpreterAlterQuery::executeToTable(DB::ASTAlterQuery const&) @ 0x000000001aeb534c
2025-07-06 11:12:18 18. ./ci/tmp/build/./src/Interpreters/InterpreterAlterQuery.cpp:78: DB::InterpreterAlterQuery::execute() @ 0x000000001aeb21e3
2025-07-06 11:12:18 19. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1561: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>) @ 0x000000001b3f606e
2025-07-06 11:12:18 20. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1769: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001b3f099b
2025-07-06 11:12:18 21. ./ci/tmp/build/./src/Server/TCPHandler.cpp:723: DB::TCPHandler::runImpl() @ 0x000000001f3d1e64
2025-07-06 11:12:18 22. ./ci/tmp/build/./src/Server/TCPHandler.cpp:2757: DB::TCPHandler::run() @ 0x000000001f3f9808
2025-07-06 11:12:18 23. ./ci/tmp/build/./base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x0000000028230ee3
2025-07-06 11:12:18 24. ./ci/tmp/build/./base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x0000000028231752
2025-07-06 11:12:18 25. ./ci/tmp/build/./base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x00000000281a6d63
2025-07-06 11:12:18 26. ./ci/tmp/build/./base/poco/Foundation/src/Thread.cpp:45: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x00000000281a5130
2025-07-06 11:12:18 27. ./base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000281a34ea
2025-07-06 11:12:18 28. __tsan_thread_start_func @ 0x0000000008d5b428
2025-07-06 11:12:18 29. ? @ 0x0000000000094ac3
2025-07-06 11:12:18 30. ? @ 0x0000000000126850
2025-07-06 11:12:18 
2025-07-06 11:12:18 Received exception from server (version 25.7.1):
2025-07-06 11:12:18 Code: 521. DB::Exception: Received from localhost:9000. DB::ErrnoException. DB::ErrnoException: Cannot rename /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/disks/s3/store/bd9/bd99f456-f1c2-4836-9e4a-8bbba677fa32/detached/attaching_all_48_48_0 to /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/run_r0/disks/s3/store/bd9/bd99f456-f1c2-4836-9e4a-8bbba677fa32/detached/all_48_48_0 because the second path already exists: , errno: 17, strerror: File exists: While rolling back operation #0. (ATOMIC_RENAME_FAIL)
2025-07-06 11:12:18 (query: ALTER TABLE alter_table1 ATTACH PARTITION ID 'all')
2025-07-06 11:12:18 
2025-07-06 11:12:18 stdout:
2025-07-06 11:12:18 default	begin inserts
2025-07-06 11:12:18 default	end inserts
2025-07-06 11:12:18 default	threads finished
2025-07-06 11:12:18 30	465
2025-07-06 11:12:18 30	465
2025-07-06 11:12:18 
2025-07-06 11:12:18 + [2025-07-06 11:11:59] [:44] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_493rvzud --log_comment 02443_detach_attach_partition.sh --max_insert_threads 2 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 40999950 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 13334537 --max_read_buffer_size 764380 --prefer_localhost_replica 0 --max_block_size 46244 --max_joined_block_size_rows 40680 --max_threads 3 --optimize_append_index 0 --use_hedged_requests 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 71 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 35683446 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 1 --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 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --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 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --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 14 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 1607701064 --min_compress_block_size 3035132 --max_compress_block_size 3015648 --merge_tree_compact_parts_min_granules_to_multibuffer_read 117 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 6458833 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 0 --session_timezone Mexico/BajaSur --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.97 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 1 --cr

2025-07-01 11:51:50 Reason: result differs with reference:  
2025-07-01 11:51:50 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02443_detach_attach_partition.reference	2025-07-01 11:31:39.975847029 -0400
2025-07-01 11:51:50 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02443_detach_attach_partition.stdout	2025-07-01 11:51:50.838214821 -0400
2025-07-01 11:51:50 @@ -1,5 +1,5 @@
2025-07-01 11:51:50  default	begin inserts
2025-07-01 11:51:50  default	end inserts
2025-07-01 11:51:50  default	threads finished
2025-07-01 11:51:50 -30	465
2025-07-01 11:51:50 -30	465
2025-07-01 11:51:50 +29	454
2025-07-01 11:51:50 +29	454
2025-07-01 11:51:50 
2025-07-01 11:51:50 
2025-07-01 11:51:50 + [2025-07-01 11:51:32] [:22] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_5cdstca8 --log_comment 02443_detach_attach_partition.sh --max_insert_threads 1 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 9288020 --max_read_buffer_size 755469 --prefer_localhost_replica 1 --max_block_size 52864 --max_joined_block_size_rows 24302 --max_threads 3 --optimize_append_index 0 --use_hedged_requests 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 87 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 28688289 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 350555145 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 1 --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 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 7 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 2095794833 --min_compress_block_size 407259 --max_compress_block_size 2950670 --merge_tree_compact_parts_min_granules_to_multibuffer_read 43 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 5580945 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.26 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 1 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table true --enable_vertical_final 0 --optimize_extract_common_expressions 1 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 1 --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 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 90 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 6739944 --merge_max_block_size 12101 --index_granularity 21538 --min_bytes_for_wide_part 0 --marks_compress_block_size 39964 --primary_key_compress_block_size 87702 --replace_long_file_name_to_hash 0 --max_file_name_length 80 --min_bytes_for_full_part_storage 36183546 --compact_parts_max_bytes_to_buffer 110486567 --compact_parts_max_granules_to_buffer 1 --compact_parts_merge_max_bytes_to_prefetch_part 1111981 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 59 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02443_detach_attach_partition.stderr-fatal -mn -q 'ALTER TABLE alter_table1 DETACH PARTITION ID '\''all'\''; SELECT sleep(21728 / 32000) format Null;'
2025-07-01 11:51:50 + [2025-07-01 11:51:33] [:21] true
2025-07-01 11:51:50 + [2025-07-01 11:51:33] [:22] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_5cdstca8 --log_comment 02443_detach_attach_partition.sh --max_insert_threads 1 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 9288020 --max_read_buffer_size 755469 --prefer_localhost_replica 1 --max_block_size 52864 --max_joined_block_size_rows 24302 --max_threads 3 --optimize_append_index 0 --use_hedged_requests 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 87 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 28688289 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 350555145 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 1 --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 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 7 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 2095794833 --min_compress_block_size 407259 --max_compress_block_size 2950670 --merge_tree_compact_parts_min_granules_to_multibuffer_read 43 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 5580945 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.26 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 1 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table true --enable_vertical_final 0 --optimize_extract_common_expressions 1 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 1 --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 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 90 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 6739944 --merge_max_block_size 12101 --index_granularity 21538 --min_bytes_for_wide_part 0 --marks_compress_block_size 39964 --primary_key_compress_block_size 87702 --replace_long_file_name_to_hash 0 --max_file_name_length 80 --min_bytes_for_full_part_storage 36183546 --compact_parts_max_bytes_to_buffer 110486567 --compact_parts_max_granules_to_buffer 1 --compact_parts_merge_max_bytes_to_prefetch_part 1111981 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 59 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02443_detach_attach_partition.stderr-fatal -mn -q 'ALTER TABLE alter_table1 DETACH PARTITION ID '\''all'\''; SELECT sleep(27166 / 32000) format Null;'
2025-07-01 11:51:50 + [2025-07-01 11:51:33] [:27] true
2025-07-01 11:51:50 + [2025-07-01 11:51:33] [:28] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_5cdstca8 --log_comment 02443_detach_attach_partition.sh --max_insert_threads 1 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 9288020 --max_read_buffer_size 755469 --prefer_localhost_replica 1 --max_block_size 52864 --max_joined_block_size_rows 24302 --max_threads 3 --optimize_append_index 0 --use_hedged_requests 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 87 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 28688289 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 350555145 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 1 --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 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 7 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 2095794833 --min_compress_block_size 407259 --max_compress_block_size 2950670 --merge_tree_compact_parts_min_granules_to_multibuffer_read 43 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 5580945 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.26 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 1 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table true --enable_vertical_final 0 --optimize_extract_common_expressions 1 --use_query_condition_cache 0 --secondary_indices_enable_bulk_filtering 1 --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 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 90 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 6739944 --merge_max_block_size 12101 --index_granularity 21538 --min_bytes_for_wide_part 0 --marks_compress_block_size 39964 --primary_key_compress_block_size 87702 --replace_long_file_name_to_hash 0 --max_file_name_length 80 --min_bytes_for_full_part_storage 36183546 --compact_parts_max_bytes_to_buffer 110486567 --compact_parts_max_granules_to_buffer 1 --compact_parts_merge_max_bytes_to_prefetch_part 1111981 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 59 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02443_detach_attach_partition.stderr-fatal -mn -q 'ALTER TABLE alter_table0 ATTACH PARTITION ID '\''all'\''; SELECT sleep(18220 / 32000) format Null;'
2025-07-01 11:51:50 + [2025-07-01 11:51:33] [:63] for i in {1..30}
2025-07-01 11:51:50 + [2025-07-01 11:51:33] [:64] insert 24
2025-07-01 11:51:50 + [2025-07-01 11:51:33] [:43] [[ 0 -eq 0 ]]
2025-07-01 11:51:50 + [2025-07-01 11:51:33] [:44] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_5cdstca8 --log_comment 02443_detach_attach_partition.sh --max_insert_threads 1 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 9288020 --max_read_buffer_size 755469 --prefer_localhost_replica 1 --max_block_size 52864 --max_joined_block_size_rows 24302 --max_threads 3 --optimize_append_index 0 --use_hedged_requests 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 87 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 28688289 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 350555145 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 1 --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 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 1 --compile_aggregate