insert into errCode =2
简简单单XTlife 发布于2021-07 浏览:3394 回复:3
0
收藏
快速回复
最后编辑于2021-07

insert INTO dw_dws.dws_log_user_demo_report_record SELECT
user_id,
DATE_FORMAT( report_time, '%Y-%m-%d' ) AS query_day,
DATE_FORMAT( report_time, '%Y-%m' ) AS eval_month,
1 AS query_count,
_create_time
FROM
rds_mylog.dingjia__log_user_demo_report_record t
WHERE
UNIX_TIMESTAMP( _create_time ) > 1626103684
AND UNIX_TIMESTAMP( _create_time ) <= 1626311829
AND report_time IS NOT NULL
ORDER BY
_create_time,
report_id,
_dt
LIMIT 0,
10000

我的insert 语句直接报错,现在已经无法insert into了,这种情况怎么解决?

2021-07-15 09:23:34,287 WARN (doris-mysql-nio-pool-1566|136946) [StmtExecutor.handleInsertStmt():1307] handle insert stmt fail: insert_adb7c11b95e64d5e-8c5318aa7b9fef0b
org.apache.doris.common.DdlException: errCode = 2, detailMessage = wait close failed. NodeChannel[1589738-1405923] add batch req success but status isn't ok, load_id=adb7c11b95e64d5e-8c5318aa7b9fef0b, txn_id=1810954, backend id=1405923:8169, errmsg=tablet writer write failed, tablet_id=1598276, txn_id=1810954, err=-235

2021-07-15 09:23:34,292 INFO (doris-mysql-nio-pool-1566|136946) [DatabaseTransactionMgr.abortTransaction():1029] abort transaction: TransactionState. transaction id: 1810954, label: insert_adb7c11b95e64d5e-8c5318aa7b9fef0b, db id: 255083, table id list: 1589737, callback id: -1, coordinator: FE: 172.16.2.6, transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1626312212859, commit time: -1, finish time: 1626312214287, reason: errCode = 2, detailMessage = wait close failed. NodeChannel[1589738-1405923] add batch req success but status isn't ok, load_id=adb7c11b95e64d5e-8c5318aa7b9fef0b, txn_id=1810954, backend id=1405923:8169, errmsg=tablet writer write failed, tablet_id=1598276, txn_id=1810954, err=-235 successfully

收藏
点赞
0
个赞
共3条回复 最后由简简单单XTlife回复于2021-07
#4简简单单XTlife回复于2021-07
#2 IamStrangers回复
-235说明导入太频繁了,需要降低导入频率

我用sparkstreaming 消费kafka 现在已经把时间设置为5min一次了,然后我把buckets 也调小了,原来是20,现在调成了3。

0
#3简简单单XTlife回复于2021-07
#2 IamStrangers回复
-235说明导入太频繁了,需要降低导入频率

我现在降低了,但是一条数据也导入不进去了,只要一导入就报错,这种情况咋处理啊?这个我问题我遇到好多次了,之前都是把数据丢到另一张表里面,然后truncate 一下原表再导回去,但是一致这么搞也不是个事啊

0
#2IamStrangers回复于2021-07

-235说明导入太频繁了,需要降低导入频率

0
快速回复
TOP
切换版块