2023.10.20 11:00:00.764584 [ 5806 ] {73f441d2-6a30-4dc0-bb3b-db2673d34eac} <Debug> executeQuery: (from [::ffff:127.0.0.1]:54654, initial_query_id: b4a2c158-c3f3-4469-9372-7837ba549e13) (comment: 01290_max_execution_speed_distributed.sql) SELECT count() FROM numbers(1000000) (stage: WithMergeableState)
2023.10.20 11:00:00.764928 [ 5806 ] {73f441d2-6a30-4dc0-bb3b-db2673d34eac} <Trace> InterpreterSelectQuery: FetchColumns -> WithMergeableState
2023.10.20 11:00:00.765169 [ 50749 ] {73f441d2-6a30-4dc0-bb3b-db2673d34eac} <Trace> AggregatingTransform: Aggregating
2023.10.20 11:00:00.765192 [ 50749 ] {73f441d2-6a30-4dc0-bb3b-db2673d34eac} <Trace> Aggregator: An entry for key=1965726198748367308 found in cache: sum_of_sizes=1, median_size=1
2023.10.20 11:00:00.765199 [ 50749 ] {73f441d2-6a30-4dc0-bb3b-db2673d34eac} <Trace> Aggregator: Aggregation method: without_key
2023.10.20 11:00:01.571225 [ 5806 ] {73f441d2-6a30-4dc0-bb3b-db2673d34eac} <Error> executeQuery: Code: 49. DB::Exception: Bad cast from type DB::ColumnVector<unsigned long> to DB::ColumnAggregateFunction. (LOGICAL_ERROR) (version 23.9.2.56 (official build)) (from [::ffff:127.0.0.1]:54654) (comment: 01290_max_execution_speed_distributed.sql) (in query: SELECT count() FROM numbers(1000000)), Stack trace (when copying this message, always include the lines below):
2023.10.20 11:00:01.572914 [ 5806 ] {73f441d2-6a30-4dc0-bb3b-db2673d34eac} <Error> TCPHandler: Code: 49. DB::Exception: Bad cast from type DB::ColumnVector<unsigned long> to DB::ColumnAggregateFunction. (LOGICAL_ERROR), Stack trace (when copying this message, always include the lines below):

2023.10.20 11:00:00.699311 [ 5057 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Debug> executeQuery: (from [::1]:56026) (comment: 01290_max_execution_speed_distributed.sql) SELECT count('special query for 01290_max_execution_speed_distributed') FROM remote('127.0.0.{2,3}', numbers(1000000)); (stage: Complete)
2023.10.20 11:00:00.699588 [ 5057 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Trace> ContextAccess (default): Access granted: CREATE TEMPORARY TABLE, REMOTE ON *.*
2023.10.20 11:00:00.699696 [ 5057 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Trace> Connection (127.0.0.2:9000): Connecting. Database: (not specified). User: default
2023.10.20 11:00:00.760549 [ 5057 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Trace> Connection (127.0.0.2:9000): Connected to ClickHouse server version 23.9.2.
2023.10.20 11:00:00.761184 [ 5682 ] {be6d282e-fe46-4f0d-81e0-9c24d172c95f} <Debug> executeQuery: (from [::ffff:127.0.0.1]:54668, initial_query_id: b4a2c158-c3f3-4469-9372-7837ba549e13) (comment: 01290_max_execution_speed_distributed.sql) DESC TABLE numbers(1000000) (stage: Complete)
2023.10.20 11:00:00.762203 [ 5057 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Trace> InterpreterSelectQuery: WithMergeableState -> Complete
2023.10.20 11:00:00.763893 [ 154098 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Trace> Connection (127.0.0.3:9000): Connecting. Database: (not specified). User: default
2023.10.20 11:00:00.764106 [ 50395 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Debug> Connection (127.0.0.2:9000): Sent data for 2 scalars, total 2 rows in 3.337e-05 sec., 58447 rows/sec., 68.00 B (1.89 MiB/sec.), compressed 0.4594594594594595 times to 148.00 B (4.10 MiB/sec.)
2023.10.20 11:00:00.764234 [ 50395 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Debug> Connection (127.0.0.2:9000): Sent data for 1 external tables, total 1 rows in 6.4094e-05 sec., 15481 rows/sec., 36.00 B (542.17 KiB/sec.), compressed 0.3673469387755102 times to 98.00 B (1.44 MiB/sec.)
2023.10.20 11:00:00.764584 [ 5806 ] {73f441d2-6a30-4dc0-bb3b-db2673d34eac} <Debug> executeQuery: (from [::ffff:127.0.0.1]:54654, initial_query_id: b4a2c158-c3f3-4469-9372-7837ba549e13) (comment: 01290_max_execution_speed_distributed.sql) SELECT count() FROM numbers(1000000) (stage: WithMergeableState)
2023.10.20 11:00:00.829208 [ 154098 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Trace> Connection (127.0.0.3:9000): Connected to ClickHouse server version 23.9.2.
2023.10.20 11:00:00.829412 [ 154098 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Debug> Connection (127.0.0.3:9000): Sent data for 2 scalars, total 2 rows in 3.5724e-05 sec., 55276 rows/sec., 68.00 B (1.79 MiB/sec.), compressed 0.4594594594594595 times to 148.00 B (3.88 MiB/sec.)
2023.10.20 11:00:00.829544 [ 154098 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Debug> Connection (127.0.0.3:9000): Sent data for 1 external tables, total 1 rows in 7.3551e-05 sec., 13468 rows/sec., 36.00 B (472.54 KiB/sec.), compressed 0.3673469387755102 times to 98.00 B (1.25 MiB/sec.)
2023.10.20 11:00:00.829798 [ 5675 ] {af251524-3437-446b-bf8f-f927cf35bd84} <Debug> executeQuery: (from [::ffff:127.0.0.1]:33922, initial_query_id: b4a2c158-c3f3-4469-9372-7837ba549e13) (comment: 01290_max_execution_speed_distributed.sql) SELECT count() FROM numbers(1000000) (stage: WithMergeableState)
2023.10.20 11:00:01.672817 [ 154098 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Trace> StorageDistributed (remote): (127.0.0.2:9000) Cancelling query
2023.10.20 11:00:01.865918 [ 5057 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Error> executeQuery: Code: 49. DB::Exception: Received from 127.0.0.3:9000. DB::Exception: Bad cast from type DB::ColumnVector<unsigned long> to DB::ColumnAggregateFunction. Stack trace:
2023.10.20 11:00:01.869475 [ 5057 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Error> TCPHandler: Code: 49. DB::Exception: Received from 127.0.0.3:9000. DB::Exception: Bad cast from type DB::ColumnVector<unsigned long> to DB::ColumnAggregateFunction. Stack trace:
2023.10.20 11:00:01.870487 [ 5057 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Debug> TCPHandler: Processed in 1.181866328 sec.
2023.10.20 11:00:01.870552 [ 5057 ] {b4a2c158-c3f3-4469-9372-7837ba549e13} <Debug> MemoryTracker: Peak memory usage (for query): 7.03 MiB.