Skip to content

GROUP BY Date32 column crashes the node #8981

Closed as not planned
Closed as not planned
@abyss7

Description

@abyss7

Table scheme: column.tpch1000.lineitem - don't know how get exact CREATE TABLE statement. This table is generated by workload init command.

Query:

PRAGMA ydb.EnableSpillingNodes='None';

SELECT * FROM `column/tpch1000/lineitem` GROUP BY l_shipdate;

Error in logs:

======= terminate() call stack ========
0. /home/ilezhankin/g/ydb/ydb/core/driver_lib/run/main.cpp:181: KikimrTerminateHandler() @ 0x2546815A
1. /home/ilezhankin/g/ydb/contrib/libs/cxxsupp/libcxxrt/exception.cc:1649: std::terminate() @ 0x1B24919E
2. /home/ilezhankin/g/ydb/contrib/libs/cxxsupp/libcxxrt/exception.cc:813: report_failure(_Unwind_Reason_Code, __cxxabiv1::__cxa_exception*) @ 0x1B24919E
3. /home/ilezhankin/g/ydb/ydb/public/sdk/cpp/client/ydb_types/fatal_error_handlers/handlers.cpp:7: NYdb::ThrowFatalError(TBasicString<char, std::__y1::>
4. /home/ilezhankin/g/ydb/ydb/public/sdk/cpp/client/ydb_value/value.cpp:1631: NYdb::TValueParser::TImpl::FatalError(TBasicString<char, std::__y1::char_>
5. /home/ilezhankin/g/ydb/ydb/public/sdk/cpp/client/ydb_value/value.cpp:1544: NYdb::TValueParser::TImpl::CheckPrimitive(NYdb::EPrimitiveType) const @ 0>
6. /home/ilezhankin/g/ydb/ydb/public/sdk/cpp/client/ydb_value/value.cpp:1148: NYdb::TValueParser::TImpl::GetInt32() const @ 0x1EC2F455
7. /home/ilezhankin/g/ydb/ydb/public/sdk/cpp/client/ydb_value/value.cpp:1686: NYdb::TValueParser::GetInt32() const @ 0x1EC2F455
8. /home/ilezhankin/g/ydb/ydb/core/viewer/viewer_query.h:0: NKikimr::NViewer::TJsonQuery::ColumnPrimitiveValueToJsonValue(NYdb::TValueParser&) @ 0x2832>
9. /home/ilezhankin/g/ydb/ydb/core/viewer/viewer_query.h:0: NKikimr::NViewer::TJsonQuery::ColumnValueToJsonValue(NYdb::TValueParser&) @ 0x283261C4
10. /home/ilezhankin/g/ydb/ydb/core/viewer/viewer_query.h:640: NKikimr::NViewer::TJsonQuery::MakeOkReply(NJson::TJsonValue&, NKikimrKqp::TEvQueryRespon>
11. /home/ilezhankin/g/ydb/ydb/core/viewer/viewer_query.h:440: NKikimr::NViewer::TJsonQuery::HandleReply(TAutoPtr<NActors::TEventHandle<NKikimr::NKqp::>
12. /home/ilezhankin/g/ydb/ydb/library/actors/core/executor_thread.cpp:251: NActors::TGenericExecutorThread::TProcessingResult NActors::TGenericExecuto>
13. /home/ilezhankin/g/ydb/ydb/library/actors/core/executor_thread.cpp:440: NActors::TGenericExecutorThread::ProcessExecutorPool(NActors::IExecutorPool>
14. /home/ilezhankin/g/ydb/ydb/library/actors/core/executor_thread.cpp:493: NActors::TGenericExecutorThread::ProcessExecutorPool(NActors::IExecutorPool>
15. /home/ilezhankin/g/ydb/ydb/library/actors/core/executor_thread.cpp:524: NActors::TExecutorThread::ThreadProc() @ 0x1C0EE766
16. /home/ilezhankin/g/ydb/util/system/thread.cpp:244: (anonymous namespace)::TPosixThread::ThreadProxy(void*) @ 0x1B341259
17. ??:0: ?? @ 0x7F9D5EF67608
18. ??:0: ?? @ 0x7F9D5EE87352
=======================================
uncaught exception:
    address -> 0x470d2e6fe710
    what() -> "TValueParser: Type mismatch, requested: Int32, actual: Date32"
    type -> NYdb::TContractViolation

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions