StarRocks be crash求助

💬 StarRocks 用户问答
#1

存算一体，版本3.2.0

*** Aborted at 1732181851 (unix time) try “date -d @1732181851” if you are using GNU date ***
PC: @ 0x3f71a8d starrocks::ExprContext::prepare()
*** SIGSEGV (@0x0) received by PID 12043 (TID 0x7f186bcf1640) from PID 0; stack trace: ***
@ 0x5b98dd2 (unknown)
@ 0x7f18f7ce4bad os::Linux::chained_handler()
@ 0x7f18f7cecc45 JVM_handle_linux_signal
@ 0x7f18f7cdb867 signalHandler()
@ 0x7f18f6f6c0b0 (unknown)
@ 0x3f71a8d starrocks::ExprContext::prepare()
@ 0x3f73191 starrocks::Expr::prepare()
@ 0x546ec12 starrocks::JDBCScanner::_init_column_class_name()
@ 0x546f0f2 starrocks::JDBCScanner::open()
@ 0x54043e6 starrocks::connector::JDBCDataSource::_create_scanner()
@ 0x540484f starrocks::connector::JDBCDataSource::open()
@ 0x32761d1 starrocks::pipeline::ConnectorChunkSource::_open_data_source()
@ 0x3277231 starrocks::pipeline::ConnectorChunkSource::_read_chunk()
@ 0x35889c7 starrocks::pipeline::ChunkSource::buffer_next_batch_chunks_blocking()
@ 0x326a157 (unknown)
@ 0x3374581 starrocks::workgroup::ScanExecutor::worker_thread()
@ 0x2939fca starrocks::ThreadPool::dispatch_thread()
@ 0x2934a3a starrocks::thread::supervise_thread()
@ 0x7f18f6fb681a (unknown)
@ 0x7f18f7039140 (unknown)
@ 0x0 (unknown)有问题的SQL.txt (8.9 KB)

#2

有人可以帮忙看看吗？be.WARNING里面报错
W1121 17:37:31.090407 12511 cast_expr.cpp:1555] vectorized engine not support from type: VARBINARY, to type: VARCHAR
W1121 17:37:31.106928 12511 cast_expr.cpp:1719] Don’t support to cast type: VARBINARY(-1) to type: VARCHAR(1048576)
不知道是不是这个导致的

#3

这个看起来很早就修过了，升级到3.2最新的release吧

#4

有相关的PR吗？我们内部没办法升级。。

#6

You can check this: https://github.com/StarRocks/starrocks/pull/37223/files

#7

但是我看堆栈那块，相关的代码修改主要是[Enhancement] support binary type for jdbc scanner (#47319)以及[BugFix]copy no_cast_column to reuse _result_chunk of jdbcScanner (#48021)

#8

SELECT
A.refParentNE AS neId,
A.id AS resId,
B.id AS boardResId,
C.frameId AS frameId,
A.slotId AS slotId,
B.cardCategory AS cardCategory,
B.resourceFulfillmentState AS registerState,
B.operateState AS operateState,
B.protectionRole AS protectionState
FROM
(
SELECT
Twin_Slot.refParentFrame AS refParentFrame,
Twin_Slot.slotId AS slotId,
Twin_Slot.refParentNE AS refParentNE,
Twin_Slot.id AS id
FROM
dte_jdbc_catalog_dte_twin_default_connector._default.DTE_SLOT AS Twin_Slot
) AS A
LEFT JOIN (
SELECT
Twin_FixedNetworkCard.refHolderSlot AS refHolderSlot,
Twin_FixedNetworkCard.protectionRole AS protectionRole,
Twin_FixedNetworkCard.resourceFulfillmentState AS resourceFulfillmentState,
Twin_FixedNetworkCard.cardCategory AS cardCategory,
Twin_FixedNetworkCard.operateState AS operateState,
Twin_FixedNetworkCard.id AS id
FROM
dte_jdbc_catalog_dte_twin_default_connector._default.DTE_FIXEDNETWORKCARD AS Twin_FixedNetworkCard
) AS B ON A.id = B.refHolderSlot
LEFT JOIN (
SELECT
Twin_FixedNetworkFrame.frameId AS frameId,
Twin_FixedNetworkFrame.id AS id
FROM
dte_jdbc_catalog_dte_twin_default_connector._default.DTE_FIXEDNETWORKFRAME AS Twin_FixedNetworkFrame
) AS C ON A.refParentFrame = C.id
WHERE
B.cardCategory = ‘MPU’
AND A.refParentNE = ‘68c1a270-ef1a-41f4-9a15-f0375cc21574’
LIMIT
10 这是查询的SQL简化版。

字段类型如下：
SELECT
A.refParentNE AS neId, VARCHAR(1048576)
A.id AS resId, VARCHAR(1048576)
B.id AS boardResId, VARCHAR(1048576)
C.frameId AS frameId, VARCHAR(96)
A.slotId AS slotId, VARCHAR(96)
B.cardCategory AS cardCategory, VARCHAR(96)
B.resourceFulfillmentState AS registerState, VARCHAR(48)
B.operateState AS operateState, VARCHAR(96)
B.protectionRole AS protectionState VARCHAR(48)

#9

已经解决

京ICP备2022026421号-1