Insert into xxxx values (?,?,?,?) 执行返回 errCode = 2, detailMessage = Unexpected exception: -1

Viewed 84
2.1

FE由两个节点组成，一个是master，一个是observer
连接observer

jdbc:mysql:loadbalance://[observer host]:9030/db?useServerPrepStmts=true

执行

INSERT INTO profile_zy_oneid_pending(identity_code, identity_value, matched_req_id, req_id, tmp_oneid, biz_time,
                                     create_time, identity_map)
VALUES ('id_card', '729943242', 'id_card_729943242_1725989086642', 'id_card_729943242_1725989086642', 0, null, now(), '[{"identityCode":"id_card","identityValue":"729943242","bizTime":1713248404507,"isRequiredIdentity":false}]')

返回：

java.sql.SQLException: errCode = 2, detailMessage = Unexpected exception: -1

observer是不是不能接这样的insert。
如果想继续使用loadbalance，是不是只能把observer改成follower

guozukai7
3 Answers
张彬华7238

Doris版本：doris-2.1.5-rc02-d5a02e095d
mysql-connector-java: 5.1.49

guozukai7

话说我使用follower节点也是一样的错误？
2024-09-13 17:52:28,143 [query] |Client=10.73.11.98:64552|User=root|Ctl=internal|Db=swtest|State=ERR|ErrorCode=1105|ErrorMessage=errCode = 2, detailMessage = Unexpected exception: -1|Time(ms)=11|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=626302|QueryId=cad5d21d2a07497d-973cc18518ba72f1|IsQuery=false|isNereids=true|feIp=10.73.21.120|Stmt=EXECUTE 46099 USING 'x.x', 'x', 'x.x', 'x.1', 5828551680, 60, 97142528, 202409131751|CpuTimeMS=0|ShuffleSendBytes=-1|ShuffleSendRows=-1|SqlHash=e1b8882a266af42bd1453489c029cbb8|peakMemoryBytes=0|SqlDigest=|TraceId=|WorkloadGroup=normal|FuzzyVariables=

kuangye1