`Logical error: 'Block structure mismatch in deserialization of query plan Aggregating step stream: different types`

### Describe the bug

https://s3.amazonaws.com/clickhouse-test-reports/json.html?PR=81237&sha=3923526a88f9dd4bbbaaf9e3b961a33ccba22597&name_0=PR&name_1=Stateless%20tests%20%28asan%2C%20distributed%20plan%2C%201%2F2%29

### How to reproduce

```sql
SELECT
    __table1.metric_id AS metric_id,
    timeSeriesInstantRateToGrid(_CAST('2024-12-12 12:00:10.000', 'DateTime64(3, \'UTC\')'), _CAST('2024-12-12 12:01:00.000', 'DateTime64(3, \'UTC\')'), 10, 50)(__table1.samples.1, __table1.samples.2) AS irate_values,
    timeSeriesInstantDeltaToGrid(_CAST('2024-12-12 12:00:10.000', 'DateTime64(3, \'UTC\')'), _CAST('2024-12-12 12:01:00.000', 'DateTime64(3, \'UTC\')'), 10, 50)(__table1.samples.1, __table1.samples.2) AS idelta_values,
    timeSeriesRateToGrid(_CAST('2024-12-12 12:00:10.000', 'DateTime64(3, \'UTC\')'), _CAST('2024-12-12 12:01:00.000', 'DateTime64(3, \'UTC\')'), 10, 50)(__table1.samples.1, __table1.samples.2) AS rate_values,
    timeSeriesDeltaToGrid(_CAST('2024-12-12 12:00:10.000', 'DateTime64(3, \'UTC\')'), _CAST('2024-12-12 12:01:00.000', 'DateTime64(3, \'UTC\')'), 10, 50)(__table1.samples.1, __table1.samples.2) AS delta_values
FROM test_5rcjvequ.t_resampled_timeseries_64 AS __table1
GROUP BY __table1.metric_id;
```

### Error message and/or stacktrace

```
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.803447 [ 3463 ] {8c6eec20-12a6-43aa-abec-cf62e95620c6} <Fatal> : Logical error: 'Block structure mismatch in deserialization of query plan Aggregating step stream: different types:
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.861305 [ 3463 ] {8c6eec20-12a6-43aa-abec-cf62e95620c6} <Fatal> : Stack trace (when copying this message, always include the lines below):
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.862408 [ 100676 ] {} <Fatal> BaseDaemon: ########## Short fault info ############
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.862911 [ 100676 ] {} <Fatal> BaseDaemon: (version 25.6.1.1, build id: 6007618AA825FCBE309926BBBC899578D0891029, git hash: 69817099ba18543abcf3f4657e8efb27ccb70809, architecture: x86_64) (from thread 3463) Received signal 6
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.863070 [ 100676 ] {} <Fatal> BaseDaemon: Signal description: Aborted
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.863171 [ 100676 ] {} <Fatal> BaseDaemon: 
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.863281 [ 100676 ] {} <Fatal> BaseDaemon: Stack trace: 0x00007fef6758e9fd 0x00007fef6753a476 0x00007fef675207f3 0x000055ae3b89d47f 0x000055ae3b89f646 0x000055ae2b0c2b6b 0x000055ae4742aa52 0x000055ae4743ac1e 0x000055ae50eb7c06 0x000055ae50eb59b7 0x000055ae4fefdb48 0x000055ae4fef94d6 0x000055ae4ff0f5bb 0x000055ae49fc514c 0x000055ae4abb7e66 0x000055ae4abb41a6 0x000055ae4fecc8ce 0x000055ae4ff0e7fa 0x000055ae5862acef 0x000055ae5862b9b7 0x000055ae585300ef 0x000055ae58529d08 0x000055ae2b075e77 0x00007fef6758cac3 0x00007fef6761e850
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.863446 [ 100676 ] {} <Fatal> BaseDaemon: ########################################
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.863836 [ 100676 ] {} <Fatal> BaseDaemon: (version 25.6.1.1, build id: 6007618AA825FCBE309926BBBC899578D0891029, git hash: 69817099ba18543abcf3f4657e8efb27ccb70809) (from thread 3463) (query_id: 8c6eec20-12a6-43aa-abec-cf62e95620c6) (query: SELECT `__table1`.`metric_id` AS `metric_id`, timeSeriesInstantRateToGrid(_CAST('2024-12-12 12:00:10.000', 'DateTime64(3, \'UTC\')'), _CAST('2024-12-12 12:01:00.000', 'DateTime64(3, \'UTC\')'), 10, 50)(`__table1`.`samples`.1, `__table1`.`samples`.2) AS `irate_values`, timeSeriesInstantDeltaToGrid(_CAST('2024-12-12 12:00:10.000', 'DateTime64(3, \'UTC\')'), _CAST('2024-12-12 12:01:00.000', 'DateTime64(3, \'UTC\')'), 10, 50)(`__table1`.`samples`.1, `__table1`.`samples`.2) AS `idelta_values`, timeSeriesRateToGrid(_CAST('2024-12-12 12:00:10.000', 'DateTime64(3, \'UTC\')'), _CAST('2024-12-12 12:01:00.000', 'DateTime64(3, \'UTC\')'), 10, 50)(`__table1`.`samples`.1, `__table1`.`samples`.2) AS `rate_values`, timeSeriesDeltaToGrid(_CAST('2024-12-12 12:00:10.000', 'DateTime64(3, \'UTC\')'), _CAST('2024-12-12 12:01:00.000', 'DateTime64(3, \'UTC\')'), 10, 50)(`__table1`.`samples`.1, `__table1`.`samples`.2) AS `delta_values` FROM `test_5rcjvequ`.`t_resampled_timeseries_64` AS `__table1` GROUP BY `__table1`.`metric_id`) Received signal Aborted (6)
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.864159 [ 100676 ] {} <Fatal> BaseDaemon: 
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.864351 [ 100676 ] {} <Fatal> BaseDaemon: Stack trace: 0x00007fef6758e9fd 0x00007fef6753a476 0x00007fef675207f3 0x000055ae3b89d47f 0x000055ae3b89f646 0x000055ae2b0c2b6b 0x000055ae4742aa52 0x000055ae4743ac1e 0x000055ae50eb7c06 0x000055ae50eb59b7 0x000055ae4fefdb48 0x000055ae4fef94d6 0x000055ae4ff0f5bb 0x000055ae49fc514c 0x000055ae4abb7e66 0x000055ae4abb41a6 0x000055ae4fecc8ce 0x000055ae4ff0e7fa 0x000055ae5862acef 0x000055ae5862b9b7 0x000055ae585300ef 0x000055ae58529d08 0x000055ae2b075e77 0x00007fef6758cac3 0x00007fef6761e850
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.864660 [ 100676 ] {} <Fatal> BaseDaemon: 3. ? @ 0x00000000000969fd
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.864940 [ 100676 ] {} <Fatal> BaseDaemon: 4. ? @ 0x0000000000042476
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.865055 [ 100676 ] {} <Fatal> BaseDaemon: 5. ? @ 0x00000000000287f3
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:53.940326 [ 100676 ] {} <Fatal> BaseDaemon: 6. ./ci/tmp/build/./src/Common/Exception.cpp:50: DB::abortOnFailedAssertion(String const&, void* const*, unsigned long, unsigned long) @ 0x000000001cc7047f
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:54.062899 [ 100676 ] {} <Fatal> BaseDaemon: 7.0. inlined from ./ci/tmp/build/./src/Common/Exception.cpp:72: DB::handle_error_code(String const&, int, bool, std::vector<void*, std::allocator<void*>> const&)
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:54.063624 [ 100676 ] {} <Fatal> BaseDaemon: 7. ./ci/tmp/build/./src/Common/Exception.cpp:116: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cc72646
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:54.181629 [ 100676 ] {} <Fatal> BaseDaemon: 8. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000c495b6b
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:54.408276 [ 100676 ] {} <Fatal> BaseDaemon: 9.0. inlined from ./src/Common/Exception.h:137: Exception<std::basic_string_view<char, std::char_traits<char> > &, std::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::basic_string<char, std::char_traits<char>, std::allocator<char> > >
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:54.408394 [ 100676 ] {} <Fatal> BaseDaemon: 9.1. inlined from ./ci/tmp/build/./src/Core/Block.cpp:41: void DB::onError<void, std::basic_string_view<char, std::char_traits<char>>&, String, String>(int, FormatStringHelperImpl<std::type_identity<std::basic_string_view<char, std::char_traits<char>>&>::type, std::type_identity<String>::type, std::type_identity<String>::type>, std::basic_string_view<char, std::char_traits<char>>&, String&&, String&&)
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:54.408456 [ 100676 ] {} <Fatal> BaseDaemon: 9. ./ci/tmp/build/./src/Core/Block.cpp:57: void DB::checkColumnStructure<void>(DB::ColumnWithTypeAndName const&, DB::ColumnWithTypeAndName const&, std::basic_string_view<char, std::char_traits<char>>, bool, int) @ 0x00000000287fda52
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:54.590696 [ 100676 ] {} <Fatal> BaseDaemon: 10. ./ci/tmp/build/./src/Core/Block.cpp:142: void DB::checkBlockStructure<void>(DB::Block const&, DB::Block const&, std::basic_string_view<char, std::char_traits<char>>, bool) @ 0x000000002880dc1e
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:54.654989 [ 100676 ] {} <Fatal> BaseDaemon: 11. ./ci/tmp/build/./src/Processors/QueryPlan/Serialization.cpp:203: DB::QueryPlan::deserialize(DB::ReadBuffer&, std::shared_ptr<DB::Context const> const&, DB::QueryPlan::SerializationFlags const&) @ 0x000000003228ac06
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:54.729197 [ 100676 ] {} <Fatal> BaseDaemon: 12. ./ci/tmp/build/./src/Processors/QueryPlan/Serialization.cpp:144: DB::QueryPlan::deserialize(DB::ReadBuffer&, std::shared_ptr<DB::Context const> const&) @ 0x00000000322889b7
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:55.077944 [ 100676 ] {} <Fatal> BaseDaemon: 13. ./ci/tmp/build/./src/Server/TCPHandler.cpp:2264: DB::TCPHandler::receiveQueryPlan(DB::QueryState&) @ 0x00000000312d0b48
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:55.344914 [ 100676 ] {} <Fatal> BaseDaemon: 14. ./ci/tmp/build/./src/Server/TCPHandler.cpp:1015: DB::TCPHandler::receivePacketsExpectData(DB::QueryState&) @ 0x00000000312cc4d6
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:55.715216 [ 100676 ] {} <Fatal> BaseDaemon: 15.0. inlined from ./ci/tmp/build/./src/Server/TCPHandler.cpp:1044: DB::TCPHandler::readTemporaryTables(DB::QueryState&)
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:55.715313 [ 100676 ] {} <Fatal> BaseDaemon: 15.1. inlined from ./ci/tmp/build/./src/Server/TCPHandler.cpp:578: operator()
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:55.715402 [ 100676 ] {} <Fatal> BaseDaemon: 15.2. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:149: decltype(std::declval<DB::TCPHandler::runImpl()::$_5&>()(std::declval<std::shared_ptr<DB::Context const>>())) std::__invoke[abi:ne190107]<DB::TCPHandler::runImpl()::$_5&, std::shared_ptr<DB::Context const>>(DB::TCPHandler::runImpl()::$_5&, std::shared_ptr<DB::Context const>&&)
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:55.715463 [ 100676 ] {} <Fatal> BaseDaemon: 15.3. inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:224: void std::__invoke_void_return_wrapper<void, true>::__call[abi:ne190107]<DB::TCPHandler::runImpl()::$_5&, std::shared_ptr<DB::Context const>>(DB::TCPHandler::runImpl()::$_5&, std::shared_ptr<DB::Context const>&&)
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:55.715506 [ 100676 ] {} <Fatal> BaseDaemon: 15.4. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:210: ?
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:55.715547 [ 100676 ] {} <Fatal> BaseDaemon: 15. ./contrib/llvm-project/libcxx/include/__functional/function.h:610: ? @ 0x00000000312e25bb
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:56.484728 [ 100676 ] {} <Fatal> BaseDaemon: 16.0. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ?
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:56.484828 [ 100676 ] {} <Fatal> BaseDaemon: 16.1. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:989: ?
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:56.484908 [ 100676 ] {} <Fatal> BaseDaemon: 16. ./ci/tmp/build/./src/Interpreters/Context.cpp:5624: DB::Context::initializeExternalTablesIfSet() @ 0x000000002b39814c
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:56.716691 [ 100676 ] {} <Fatal> BaseDaemon: 17. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1246: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr<DB::IAST>&) @ 0x000000002bf8ae66
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:57.001041 [ 100676 ] {} <Fatal> BaseDaemon: 18. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1717: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002bf871a6
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:57.169765 [ 100676 ] {} <Fatal> BaseDaemon: 19. ./ci/tmp/build/./src/Server/TCPHandler.cpp:687: DB::TCPHandler::runImpl() @ 0x000000003129f8ce
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:57.610186 [ 100676 ] {} <Fatal> BaseDaemon: 20. ./ci/tmp/build/./src/Server/TCPHandler.cpp:2677: DB::TCPHandler::run() @ 0x00000000312e17fa
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:57.616653 [ 100676 ] {} <Fatal> BaseDaemon: 21. ./ci/tmp/build/./base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x00000000399fdcef
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:57.631751 [ 100676 ] {} <Fatal> BaseDaemon: 22. ./ci/tmp/build/./base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x00000000399fe9b7
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:57.647037 [ 100676 ] {} <Fatal> BaseDaemon: 23. ./ci/tmp/build/./base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x00000000399030ef
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:57.660781 [ 100676 ] {} <Fatal> BaseDaemon: 24. ./base/poco/Foundation/src/Thread_POSIX.cpp:335: Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000398fcd08
/var/log/clickhouse-server/clickhouse-server.err.log:2025.06.05 13:54:57.726310 [ 100676 ] {} <Fatal> BaseDaemon: 25. asan_thread_start(void*) @ 0x000000000c448e77
```

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

`Logical error: 'Block structure mismatch in deserialization of query plan Aggregating step stream: different types` #81399

Describe the bug

How to reproduce

Error message and/or stacktrace

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Logical error: 'Block structure mismatch in deserialization of query plan Aggregating step stream: different types #81399

Description

Describe the bug

How to reproduce

Error message and/or stacktrace

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions

`Logical error: 'Block structure mismatch in deserialization of query plan Aggregating step stream: different types` #81399