fengcharles opened a new issue #6777: URL: https://github.com/apache/incubator-doris/issues/6777
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version 0.14 ### What's Wrong? 使用java 调用 kettle转换 每天导入一次数据，执行一段时间后会报错。 查看了上下文错误日志没有写清楚具体的问题。 比如今天需要插入1000条数据，一般插入到 3-4百条的时候就会报这个错。导致后面的插入终止。 2021-09-29 06:00:01,263 WARN (doris-mysql-nio-pool-159|16786) [ConnectProcessor.dispatch():348] Unsupported command(COM_STMT_PREPARE) 2021-09-29 06:00:01,264 WARN (doris-mysql-nio-pool-159|16786) [ConnectProcessor.dispatch():348] Unsupported command(COM_STMT_PREPARE) 2021-09-29 06:00:01,265 WARN (doris-mysql-nio-pool-159|16786) [ConnectProcessor.dispatch():348] Unsupported command(COM_STMT_PREPARE) 2021-09-29 06:00:35,038 WARN (thrift-server-pool-3|2189) [Coordinator.updateFragmentExecStatus():1369] one instance report fail, query_id=9ea4034edca042ca-a5a14742cee0f3fd instance_id=9ea4034edca042ca-a5a14742cee0f3fe 2021-09-29 06:00:35,038 WARN (thrift-server-pool-3|2189) [Coordinator.updateStatus():670] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: 9ea4034edca042ca-a5a14742cee0f3fd, instance id: 9ea4034edca042ca-a5a14742cee0f3fe 2021-09-29 06:00:35,038 WARN (doris-mysql-nio-pool-159|16786) [StmtExecutor.handleInsertStmt():846] insert failed: already stopped, skip waiting for close. cancelled/!eos: : 1/0 2021-09-29 06:00:35,038 WARN (doris-mysql-nio-pool-159|16786) [StmtExecutor.handleInsertStmt():894] handle insert stmt fail: insert_9ea4034edca042ca-a5a14742cee0f3fd org.apache.doris.common.DdlException: errCode = 2, detailMessage = already stopped, skip waiting for close. cancelled/!eos: : 1/0 at org.apache.doris.common.ErrorReport.reportDdlException(ErrorReport.java:67) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.StmtExecutor.handleInsertStmt(StmtExecutor.java:847) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:326) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:243) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:199) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:337) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:535) ~[palo-fe.jar:3.4.0] at org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50) ~[palo-fe.jar:3.4.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:829) [?:?] 2021-09-29 06:00:35,040 WARN (doris-mysql-nio-pool-159|16786) [StmtExecutor.execute():380] errors when abort txn org.apache.doris.transaction.TransactionNotFoundException: errCode = 2, detailMessage = transaction not found at org.apache.doris.transaction.DatabaseTransactionMgr.abortTransaction(DatabaseTransactionMgr.java:949) ~[palo-fe.jar:3.4.0] at org.apache.doris.transaction.GlobalTransactionMgr.abortTransaction(GlobalTransactionMgr.java:210) ~[palo-fe.jar:3.4.0] at org.apache.doris.transaction.GlobalTransactionMgr.abortTransaction(GlobalTransactionMgr.java:205) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:376) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:243) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:199) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:337) ~[palo-fe.jar:3.4.0] at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:535) ~[palo-fe.jar:3.4.0] at org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50) ~[palo-fe.jar:3.4.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:829) [?:?] 2021-09-29 10:19:29,576 WARN (doris-mysql-nio-pool-162|17050) [ConnectProcessor.dispatch():348] Unsupported command(COM_STMT_PREPARE) 2021-09-29 10:19:29,601 WARN (doris-mysql-nio-pool-162|17050) [ConnectProcessor.dispatch():348] Unsupported command(COM_STMT_PREPARE) 2021-09-29 10:19:29,619 WARN (doris-mysql-nio-pool-162|17050) [ConnectProcessor.dispatch():348] Unsupported command(COM_STMT_PREPARE) 2021-09-29 10:20:09,964 WARN (doris-mysql-nio-pool-162|17050) [NMysqlChannel.readAll():71] Read channel exception, ignore. Exception: java.io.IOException: Connection reset by peer 2021-09-29 10:20:09,964 WARN (doris-mysql-nio-pool-162|17050) [ConnectProcessor.processOnce():525] Null packet received from network. remote: 172.16.80.80:60416 2021-09-29 10:20:09,964 WARN (doris-mysql-nio-pool-162|17050) [ReadListener.lambda$handleEvent$0():58] Exception happened in one session(org.apache.doris.mysql.nio.NConnectContext@1f7af005). java.io.IOException: Error happened when receiving packet. at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:526) ~[palo-fe.jar:3.4.0] at org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50) ~[palo-fe.jar:3.4.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:829) [?:?] ### What You Expected? 期望是导入数据正常进行。 ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
