Skip to content

Logical error: 'Cannot find column in(status, _subquery8) in ActionsDAG result' #40336

Closed
Closed
Logical error: 'Cannot find column in(status, _subquery8) in ActionsDAG result'#40336
Labels
fuzzProblem found by one of the fuzzers
@kssenii

Description

@kssenii
kssenii
opened on Aug 18, 2022

https://s3.amazonaws.com/clickhouse-test-reports/36171/d63d34f7bb23c8f9c2392662a12e8fed45608ab0/stress_test__debug_.html

/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:05:39.493105 [ 1233 ] {c82e01e9-337e-4df0-91fa-888f562ac1f7} <Fatal> : Logical error: 'Cannot find column in(status, _subquery8) in ActionsDAG result'.
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:38.804275 [ 4425 ] {} <Fatal> BaseDaemon: ########################################
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:39.135352 [ 4425 ] {} <Fatal> BaseDaemon: (version 22.8.1.1, build id: BEADAD632270E3AF) (from thread 1233) (query_id: c82e01e9-337e-4df0-91fa-888f562ac1f7) (query: SELECT status, count() AS all FROM test ARRAY JOIN nested as nestedJoined WHERE (status IN ( SELECT status FROM test ARRAY JOIN nested as nestedJoined GROUP BY status ORDER BY count() DESC LIMIT 10)) AND (id IN ('1', '2')) GROUP BY CUBE(status) LIMIT 100;) Received signal Aborted (6)
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:39.206494 [ 4425 ] {} <Fatal> BaseDaemon: 
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:39.291249 [ 4425 ] {} <Fatal> BaseDaemon: Stack trace: 0x7f45059cf00b 0x7f45059ae859 0x17212fb6 0x17213075 0x17213125 0x1735f842 0x266de920 0x291c8672 0x291c2b5f 0x291089e9 0x29108597 0x274a3811 0x27914cf7 0x27911524 0x28a00fb8 0x28a11285 0x2d049979 0x2d04a1dc 0x2d297d14 0x2d2947da 0x2d29357e 0x7f4505b86609 0x7f4505aab133
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:39.322248 [ 4425 ] {} <Fatal> BaseDaemon: 4. raise in ?
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:39.328851 [ 4425 ] {} <Fatal> BaseDaemon: 5. abort in ?
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:39.636433 [ 4425 ] {} <Fatal> BaseDaemon: 6. /build/build_docker/../src/Common/Exception.cpp:40: DB::abortOnFailedAssertion(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:40.040643 [ 4425 ] {} <Fatal> BaseDaemon: 7. /build/build_docker/../src/Common/Exception.cpp:63: DB::handle_error_code(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool, std::__1::vector<void*, std::__1::allocator<void*> > const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:40.314910 [ 4425 ] {} <Fatal> BaseDaemon: 8. /build/build_docker/../src/Common/Exception.cpp:70: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:40.682987 [ 4425 ] {} <Fatal> BaseDaemon: 9. /build/build_docker/../src/Common/Exception.h:37: DB::Exception::Exception<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&>(int, fmt::v8::basic_format_string<char, fmt::v8::type_identity<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&>::type>, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:47.202091 [ 4425 ] {} <Fatal> BaseDaemon: 10. /build/build_docker/../src/Interpreters/ActionsDAG.cpp:1197: DB::ActionsDAG::merge(DB::ActionsDAG&&, DB::ActionsDAG&&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:47.786089 [ 4425 ] {} <Fatal> BaseDaemon: 11. /build/build_docker/../src/Processors/QueryPlan/Optimizations/mergeExpressions.cpp:34: DB::QueryPlanOptimizations::tryMergeExpressions(DB::QueryPlan::Node*, std::__1::list<DB::QueryPlan::Node, std::__1::allocator<DB::QueryPlan::Node> >&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:48.142229 [ 4425 ] {} <Fatal> BaseDaemon: 12. /build/build_docker/../src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:82: DB::QueryPlanOptimizations::optimizeTree(DB::QueryPlanOptimizationSettings const&, DB::QueryPlan::Node&, std::__1::list<DB::QueryPlan::Node, std::__1::allocator<DB::QueryPlan::Node> >&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:49.497944 [ 4425 ] {} <Fatal> BaseDaemon: 13. /build/build_docker/../src/Processors/QueryPlan/QueryPlan.cpp:450: DB::QueryPlan::optimize(DB::QueryPlanOptimizationSettings const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:50.634939 [ 4425 ] {} <Fatal> BaseDaemon: 14. /build/build_docker/../src/Processors/QueryPlan/QueryPlan.cpp:168: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:53.199254 [ 4425 ] {} <Fatal> BaseDaemon: 15. /build/build_docker/../src/Interpreters/InterpreterSelectWithUnionQuery.cpp:370: DB::InterpreterSelectWithUnionQuery::execute() in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:54.191752 [ 4425 ] {} <Fatal> BaseDaemon: 16. /build/build_docker/../src/Interpreters/executeQuery.cpp:694: DB::executeQueryImpl(char const*, char const*, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.err.log:2022.08.18 04:20:55.753888 [ 689 ] {} <Fatal> Application: Child process was terminated by signal 6.
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:05:39.493105 [ 1233 ] {c82e01e9-337e-4df0-91fa-888f562ac1f7} <Fatal> : Logical error: 'Cannot find column in(status, _subquery8) in ActionsDAG result'.
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:38.804275 [ 4425 ] {} <Fatal> BaseDaemon: ########################################
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:39.135352 [ 4425 ] {} <Fatal> BaseDaemon: (version 22.8.1.1, build id: BEADAD632270E3AF) (from thread 1233) (query_id: c82e01e9-337e-4df0-91fa-888f562ac1f7) (query: SELECT status, count() AS all FROM test ARRAY JOIN nested as nestedJoined WHERE (status IN ( SELECT status FROM test ARRAY JOIN nested as nestedJoined GROUP BY status ORDER BY count() DESC LIMIT 10)) AND (id IN ('1', '2')) GROUP BY CUBE(status) LIMIT 100;) Received signal Aborted (6)
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:39.206494 [ 4425 ] {} <Fatal> BaseDaemon: 
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:39.291249 [ 4425 ] {} <Fatal> BaseDaemon: Stack trace: 0x7f45059cf00b 0x7f45059ae859 0x17212fb6 0x17213075 0x17213125 0x1735f842 0x266de920 0x291c8672 0x291c2b5f 0x291089e9 0x29108597 0x274a3811 0x27914cf7 0x27911524 0x28a00fb8 0x28a11285 0x2d049979 0x2d04a1dc 0x2d297d14 0x2d2947da 0x2d29357e 0x7f4505b86609 0x7f4505aab133
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:39.322248 [ 4425 ] {} <Fatal> BaseDaemon: 4. raise in ?
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:39.328851 [ 4425 ] {} <Fatal> BaseDaemon: 5. abort in ?
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:39.636433 [ 4425 ] {} <Fatal> BaseDaemon: 6. /build/build_docker/../src/Common/Exception.cpp:40: DB::abortOnFailedAssertion(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:40.040643 [ 4425 ] {} <Fatal> BaseDaemon: 7. /build/build_docker/../src/Common/Exception.cpp:63: DB::handle_error_code(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool, std::__1::vector<void*, std::__1::allocator<void*> > const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:40.314910 [ 4425 ] {} <Fatal> BaseDaemon: 8. /build/build_docker/../src/Common/Exception.cpp:70: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:40.682987 [ 4425 ] {} <Fatal> BaseDaemon: 9. /build/build_docker/../src/Common/Exception.h:37: DB::Exception::Exception<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&>(int, fmt::v8::basic_format_string<char, fmt::v8::type_identity<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&>::type>, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:47.202091 [ 4425 ] {} <Fatal> BaseDaemon: 10. /build/build_docker/../src/Interpreters/ActionsDAG.cpp:1197: DB::ActionsDAG::merge(DB::ActionsDAG&&, DB::ActionsDAG&&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:47.786089 [ 4425 ] {} <Fatal> BaseDaemon: 11. /build/build_docker/../src/Processors/QueryPlan/Optimizations/mergeExpressions.cpp:34: DB::QueryPlanOptimizations::tryMergeExpressions(DB::QueryPlan::Node*, std::__1::list<DB::QueryPlan::Node, std::__1::allocator<DB::QueryPlan::Node> >&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:48.142229 [ 4425 ] {} <Fatal> BaseDaemon: 12. /build/build_docker/../src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:82: DB::QueryPlanOptimizations::optimizeTree(DB::QueryPlanOptimizationSettings const&, DB::QueryPlan::Node&, std::__1::list<DB::QueryPlan::Node, std::__1::allocator<DB::QueryPlan::Node> >&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:49.497944 [ 4425 ] {} <Fatal> BaseDaemon: 13. /build/build_docker/../src/Processors/QueryPlan/QueryPlan.cpp:450: DB::QueryPlan::optimize(DB::QueryPlanOptimizationSettings const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:50.634939 [ 4425 ] {} <Fatal> BaseDaemon: 14. /build/build_docker/../src/Processors/QueryPlan/QueryPlan.cpp:168: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:53.199254 [ 4425 ] {} <Fatal> BaseDaemon: 15. /build/build_docker/../src/Interpreters/InterpreterSelectWithUnionQuery.cpp:370: DB::InterpreterSelectWithUnionQuery::execute() in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:54.191752 [ 4425 ] {} <Fatal> BaseDaemon: 16. /build/build_docker/../src/Interpreters/executeQuery.cpp:694: DB::executeQueryImpl(char const*, char const*, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) in /usr/bin/clickhouse
/var/log/clickhouse-server/clickhouse-server.stress.log:2022.08.18 04:20:55.753888 [ 689 ] {} <Fatal> Application: Child process was terminated by signal 6.

Metadata

Metadata

Assignees

No one assigned

    Labels

    fuzzProblem found by one of the fuzzers

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions