Skip to content

crash on left join #6792

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
vitstn opened this issue Jul 17, 2024 · 0 comments
Open

crash on left join #6792

vitstn opened this issue Jul 17, 2024 · 0 comments

Comments

@vitstn
Copy link
Collaborator

vitstn commented Jul 17, 2024 •
edited
Loading

local=> SELECT
d.oid, d.typname as name, pg_catalog.pg_get_userbyid(d.typowner) as owner,
bn.nspname as basensp, des.description
FROM
pg_catalog.pg_type d
JOIN
pg_catalog.pg_type b ON b.oid = d.typbasetype
JOIN
pg_catalog.pg_namespace bn ON bn.oid=d.typnamespace
LEFT OUTER JOIN
pg_catalog.pg_description des ON (des.objoid=d.oid AND des.classoid='pg_type'::regclass)
WHERE
d.typnamespace = 11::oid
ORDER BY
d.typname;
server closed the connection unexpectedly

backtrace
VERIFY failed (2024-07-17T14:24:42.591571Z):
ydb/library/yql/minikql/comp_nodes/llvm14/mkql_join_dict.cpp:149
JoinDicts(): requirement !HasNullInKey(key1) failed
0. /-S/util/system/yassert.cpp:83: NPrivate::InternalPanicImpl(int, char const*, char const*, int, int, int, TBasicStringBuf<char, std::__y1::char_traits>, char const*, unsigned long) @ 0xA91539C

  1. /-S/util/system/yassert.cpp:55: NPrivate::Panic(NPrivate::TStaticBuf const&, int, char const*, char const*, char const*, ...) @ 0xA90F0C6
  2. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_join_dict.cpp:149: NKikimr::NMiniKQL::(anonymous namespace)::TJoinDictWrapper::JoinDicts(NKikimr::NMiniKQL::TComputationContext&, NYql::NUdf::TUnboxedValuePod, NYql::NUdf::TUnboxedValuePod) const @ 0x13DEA2AF
  3. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_join_dict.cpp:39: NKikimr::NMiniKQL::(anonymous namespace)::TJoinDictWrapper::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13DE633D
  4. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:224: NKikimr::NMiniKQL::TMutableComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TJoinDictWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13DE5827
  5. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_map.cpp:302: NKikimr::NMiniKQL::(anonymous namespace)::TListMapWrapper::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1E4DD
  6. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:224: NKikimr::NMiniKQL::TMutableComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TListMapWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1E347
  7. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/ydb/library/yql/minikql/computation/mkql_computation_node_codegen.h:606: NKikimr::NMiniKQL::TCodegeneratorRootNode<NKikimr::NMiniKQL::TMutableCodegeneratorNode<NKikimr::NMiniKQL::(anonymous namespace)::TListMapWrapper>, true>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1C701
  8. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_flatmap.cpp:550: NKikimr::NMiniKQL::(anonymous namespace)::TFlowFlatMapWrapper<true, false>::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C1B23F
  9. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_flatmap.cpp:571: NKikimr::NMiniKQL::(anonymous namespace)::TFlowFlatMapWrapper<true, false>::DoCalculate(NYql::NUdf::TUnboxedValue&, NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C1B23F
  10. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:506: NKikimr::NMiniKQL::TStatefulFlowComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TFlowFlatMapWrapper<true, false>, false>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C1B23F
  11. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_flatmap.cpp:32: NKikimr::NMiniKQL::(anonymous namespace)::TFlowFlatMapFlowWrapper::DoCalculate(NYql::NUdf::TUnboxedValue&, NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C16EB9
  12. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:506: NKikimr::NMiniKQL::TStatefulFlowComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TFlowFlatMapFlowWrapper, false>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C16EB9
  13. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_collect.cpp:19: NKikimr::NMiniKQL::(anonymous namespace)::TCollectFlowWrapper::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13890CE6
  14. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:224: NKikimr::NMiniKQL::TMutableComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TCollectFlowWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13890AF7
  15. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/ydb/library/yql/minikql/computation/mkql_computation_node_codegen.h:606: NKikimr::NMiniKQL::TCodegeneratorRootNode<NKikimr::NMiniKQL::TMutableCodegeneratorNode<NKikimr::NMiniKQL::(anonymous namespace)::TCollectFlowWrapper>, true>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x1388FAC1
  16. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_flow.cpp:21: NKikimr::NMiniKQL::(anonymous namespace)::TToFlowWrapper::DoCalculate(NYql::NUdf::TUnboxedValue&, NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C4274C
  17. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:293: NKikimr::NMiniKQL::TFlowSourceComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TToFlowWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C4274C
  18. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_map.cpp:22: NKikimr::NMiniKQL::(anonymous namespace)::TFlowMapWrapper::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1A50F
  19. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:462: NKikimr::NMiniKQL::TStatelessFlowComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TFlowMapWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1A50F
  20. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_todict.cpp:1440: NKikimr::NMiniKQL::(anonymous namespace)::TSqueezeMapFlowWrapper<NKikimr::NMiniKQL::(anonymous namespace)::THashedCompactMapAccumulator>::DoCalculate(NYql::NUdf::TUnboxedValue&, NKikimr::NMiniKQL::TComputationContext&) const @ 0x14292F87
  21. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:506: NKikimr::NMiniKQL::TStatefulFlowComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TSqueezeMapFlowWrapper<NKikimr::NMiniKQL::(anonymous namespace)::THashedCompactMapAccumulator>, false>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x14292F87
  22. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_flatmap.cpp:23: NKikimr::NMiniKQL::(anonymous namespace)::TFlowFlatMapFlowWrapper::DoCalculate(NYql::NUdf::TUnboxedValue&, NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C16DA1
  23. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:506: NKikimr::NMiniKQL::TStatefulFlowComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TFlowFlatMapFlowWrapper, false>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C16DA1
  24. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_collect.cpp:19: NKikimr::NMiniKQL::(anonymous namespace)::TCollectFlowWrapper::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13890CE6
  25. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:224: NKikimr::NMiniKQL::TMutableComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TCollectFlowWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13890AF7
  26. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/ydb/library/yql/minikql/computation/mkql_computation_node_codegen.h:606: NKikimr::NMiniKQL::TCodegeneratorRootNode<NKikimr::NMiniKQL::TMutableCodegeneratorNode<NKikimr::NMiniKQL::(anonymous namespace)::TCollectFlowWrapper>, true>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x1388FAC1
  27. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_flow.cpp:21: NKikimr::NMiniKQL::(anonymous namespace)::TToFlowWrapper::DoCalculate(NYql::NUdf::TUnboxedValue&, NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C4274C
  28. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:293: NKikimr::NMiniKQL::TFlowSourceComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TToFlowWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C4274C
  29. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_map.cpp:22: NKikimr::NMiniKQL::(anonymous namespace)::TFlowMapWrapper::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1A50F
  30. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:462: NKikimr::NMiniKQL::TStatelessFlowComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TFlowMapWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1A50F
  31. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_todict.cpp:1440: NKikimr::NMiniKQL::(anonymous namespace)::TSqueezeMapFlowWrapper<NKikimr::NMiniKQL::(anonymous namespace)::THashedCompactMapAccumulator>::DoCalculate(NYql::NUdf::TUnboxedValue&, NKikimr::NMiniKQL::TComputationContext&) const @ 0x14292F87
  32. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:506: NKikimr::NMiniKQL::TStatefulFlowComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TSqueezeMapFlowWrapper<NKikimr::NMiniKQL::(anonymous namespace)::THashedCompactMapAccumulator>, false>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x14292F87
  33. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_flatmap.cpp:23: NKikimr::NMiniKQL::(anonymous namespace)::TFlowFlatMapFlowWrapper::DoCalculate(NYql::NUdf::TUnboxedValue&, NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C16DA1
  34. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:506: NKikimr::NMiniKQL::TStatefulFlowComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TFlowFlatMapFlowWrapper, false>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C16DA1
  35. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_collect.cpp:19: NKikimr::NMiniKQL::(anonymous namespace)::TCollectFlowWrapper::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13890CE6
  36. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:224: NKikimr::NMiniKQL::TMutableComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TCollectFlowWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13890AF7
  37. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/ydb/library/yql/minikql/computation/mkql_computation_node_codegen.h:606: NKikimr::NMiniKQL::TCodegeneratorRootNode<NKikimr::NMiniKQL::TMutableCodegeneratorNode<NKikimr::NMiniKQL::(anonymous namespace)::TCollectFlowWrapper>, true>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x1388FAC1
  38. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_map.cpp:302: NKikimr::NMiniKQL::(anonymous namespace)::TListMapWrapper::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1E4DD
  39. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:224: NKikimr::NMiniKQL::TMutableComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TListMapWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1E347
  40. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/ydb/library/yql/minikql/computation/mkql_computation_node_codegen.h:606: NKikimr::NMiniKQL::TCodegeneratorRootNode<NKikimr::NMiniKQL::TMutableCodegeneratorNode<NKikimr::NMiniKQL::(anonymous namespace)::TListMapWrapper>, true>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13E1C701
  41. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_sort.cpp:340: NKikimr::NMiniKQL::(anonymous namespace)::TAlgoBaseWrapper<NKikimr::NMiniKQL::(anonymous namespace)::TAlgoWrapper, true>::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13EF9B80
  42. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:221: NKikimr::NMiniKQL::TMutableComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TAlgoBaseWrapper<NKikimr::NMiniKQL::(anonymous namespace)::TAlgoWrapper, true>>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13EF9012
  43. /-B/ydb/library/yql/minikql/comp_nodes/llvm14/mkql_iterator.cpp:21: NKikimr::NMiniKQL::(anonymous namespace)::TIteratorWrapper::DoCalculate(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C9F8AD
  44. /-S/ydb/library/yql/minikql/computation/mkql_computation_node_impl.h:221: NKikimr::NMiniKQL::TMutableComputationNode<NKikimr::NMiniKQL::(anonymous namespace)::TIteratorWrapper>::GetValue(NKikimr::NMiniKQL::TComputationContext&) const @ 0x13C9EE33
  45. /-B/ydb/library/yql/minikql/computation/llvm14/mkql_computation_node_graph.cpp:621: NKikimr::NMiniKQL::(anonymous namespace)::TComputationGraph::GetValue() @ 0xE87541A
  46. /-S/ydb/library/yql/dq/runtime/dq_tasks_runner.cpp:707: NYql::NDq::TDqTaskRunner::Run() @ 0x1539AA21
  47. /-S/ydb/library/yql/dq/actors/compute/dq_sync_compute_actor_base.h:32: NYql::NDq::TDqSyncComputeActorBaseNKikimr::NKqp::TKqpComputeActor::DoExecuteImpl() @ 0x19D6B66C
  48. /-S/ydb/library/yql/dq/actors/compute/dq_compute_actor_impl.h:292: NYql::NDq::TDqComputeActorBase<NKikimr::NKqp::TKqpComputeActor, NYql::NDq::TComputeActorAsyncInputHelperSync>::DoExecute() @ 0x19D6AF00
  49. /-S/ydb/library/yql/dq/actors/compute/dq_compute_actor_impl.h:1023: NYql::NDq::TDqComputeActorBase<NKikimr::NKqp::TKqpComputeActor, NYql::NDq::TComputeActorAsyncInputHelperSync>::HandleExecuteBase(TAutoPtr<NActors::TEventHandleNYql::NDq::TEvDqCompute::TEvChannelsInfo, TDelete>&) @ 0x19D7C1E4
  50. /-S/ydb/core/kqp/compute_actor/kqp_pure_compute_actor.cpp:133: NKikimr::NKqp::TKqpComputeActor::StateFunc(TAutoPtr<NActors::IEventHandle, TDelete>&) @ 0x19D66FC3
  51. /-S/ydb/library/actors/core/executor_thread.cpp:251: NActors::TGenericExecutorThread::TProcessingResult NActors::TGenericExecutorThread::ExecuteNActors::TMailboxTable::THTSwapMailbox(NActors::TMailboxTable::THTSwapMailbox*, unsigned int, bool) @ 0xB7973B7
  52. /-S/ydb/library/actors/core/executor_thread.cpp:439: NActors::TGenericExecutorThread::ProcessExecutorPool(NActors::IExecutorPool*)::$_0::operator()(unsigned int, bool) const @ 0xB78ECC1
  53. /-S/ydb/library/actors/core/executor_thread.cpp:492: NActors::TGenericExecutorThread::ProcessExecutorPool(NActors::IExecutorPool*) @ 0xB78E6B9
  54. /-S/ydb/library/actors/core/executor_thread.cpp:523: NActors::TExecutorThread::ThreadProc() @ 0xB78F55F
@vitstn vitstn mentioned this issue Jul 17, 2024
Open
8 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@vitstn