doris 突然出现大量报错 Null packet received from network

Viewed 40

在调用方式及调用频率没有变化的情况下, doris日志出现大量报错日志

2025-05-26 16:22:28,147 WARN (mysql-nio-pool-89239|2925558) [ResultReceiver.cancel():231] ResultReceiver of query 1712dba2e7db4194-960f59ab8ee8087a cancel failed, typically means the future is finished
2025-05-26 16:22:28,147 WARN (mysql-nio-pool-89239|2925558) [MysqlConnectProcessor.processOnce():468] Null packet received from network. remote: 192.168.193.23:53504
2025-05-26 16:22:28,147 WARN (mysql-nio-pool-89239|2925558) [ReadListener.lambda$handleEvent$0():60] Exception happened in one session(org.apache.doris.qe.ConnectContext@5889a1c7).
java.io.IOException: Error happened when receiving packet.
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:469) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352]
2025-05-26 16:22:43,151 WARN (mysql-nio-pool-89236|2925279) [ResultReceiver.cancel():231] ResultReceiver of query b8207e4d9e04abf-a6ca755c284c9430 cancel failed, typically means the future is finished
2025-05-26 16:22:43,152 WARN (mysql-nio-pool-89236|2925279) [MysqlConnectProcessor.processOnce():468] Null packet received from network. remote: 192.168.193.23:53506
2025-05-26 16:22:43,152 WARN (mysql-nio-pool-89236|2925279) [ReadListener.lambda$handleEvent$0():60] Exception happened in one session(org.apache.doris.qe.ConnectContext@79791afb).
java.io.IOException: Error happened when receiving packet.
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:469) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352]
2025-05-26 16:22:58,161 WARN (mysql-nio-pool-89239|2925558) [ResultReceiver.cancel():231] ResultReceiver of query 74b830e7201946d8-9e1be587846de126 cancel failed, typically means the future is finished
2025-05-26 16:22:58,161 WARN (mysql-nio-pool-89239|2925558) [MysqlConnectProcessor.processOnce():468] Null packet received from network. remote: 192.168.193.23:53508
2025-05-26 16:22:58,161 WARN (mysql-nio-pool-89239|2925558) [ReadListener.lambda$handleEvent$0():60] Exception happened in one session(org.apache.doris.qe.ConnectContext@1a817699).
java.io.IOException: Error happened when receiving packet.
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:469) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352]
2025-05-26 16:23:13,167 WARN (mysql-nio-pool-89239|2925558) [ResultReceiver.cancel():231] ResultReceiver of query 5f81871cdf7b4269-9e9aa02eb462c8bf cancel failed, typically means the future is finished
2025-05-26 16:23:13,167 WARN (mysql-nio-pool-89239|2925558) [MysqlConnectProcessor.processOnce():468] Null packet received from network. remote: 192.168.193.23:53510
2025-05-26 16:23:13,167 WARN (mysql-nio-pool-89239|2925558) [ReadListener.lambda$handleEvent$0():60] Exception happened in one session(org.apache.doris.qe.ConnectContext@2a83a494).
java.io.IOException: Error happened when receiving packet.
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:469) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352]
2025-05-26 16:23:28,171 WARN (mysql-nio-pool-89239|2925558) [ResultReceiver.cancel():231] ResultReceiver of query 6d1e65b98be14694-9b32c1349a6af4c0 cancel failed, typically means the future is finished
2025-05-26 16:23:28,172 WARN (mysql-nio-pool-89239|2925558) [MysqlConnectProcessor.processOnce():468] Null packet received from network. remote: 192.168.193.23:53512
2025-05-26 16:23:28,172 WARN (mysql-nio-pool-89239|2925558) [ReadListener.lambda$handleEvent$0():60] Exception happened in one session(org.apache.doris.qe.ConnectContext@1157df0).
java.io.IOException: Error happened when receiving packet.
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:469) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352]
2025-05-26 16:23:43,172 WARN (mysql-nio-pool-89239|2925558) [ResultReceiver.cancel():231] ResultReceiver of query 4ebacced3484abb-840e9b6373285642 cancel failed, typically means the future is finished
2025-05-26 16:23:43,173 WARN (mysql-nio-pool-89239|2925558) [MysqlConnectProcessor.processOnce():468] Null packet received from network. remote: 192.168.193.23:53514
2025-05-26 16:23:43,173 WARN (mysql-nio-pool-89239|2925558) [ReadListener.lambda$handleEvent$0():60] Exception happened in one session(org.apache.doris.qe.ConnectContext@42a6a8cc).
java.io.IOException: Error happened when receiving packet.
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:469) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352]
2025-05-26 16:23:58,177 WARN (mysql-nio-pool-89239|2925558) [ResultReceiver.cancel():231] ResultReceiver of query e4dba0b7af1543d0-bc6fceebc8c5bd95 cancel failed, typically means the future is finished
2025-05-26 16:23:58,178 WARN (mysql-nio-pool-89239|2925558) [MysqlConnectProcessor.processOnce():468] Null packet received from network. remote: 192.168.193.23:53516
2025-05-26 16:23:58,178 WARN (mysql-nio-pool-89239|2925558) [ReadListener.lambda$handleEvent$0():60] Exception happened in one session(org.apache.doris.qe.ConnectContext@24b950c6).
java.io.IOException: Error happened when receiving packet.
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:469) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352]
2025-05-26 16:24:13,171 WARN (mysql-nio-pool-89239|2925558) [ResultReceiver.cancel():231] ResultReceiver of query 771947bdddfb4568-aca3713c1faff66f cancel failed, typically means the future is finished
2025-05-26 16:24:13,171 WARN (mysql-nio-pool-89239|2925558) [MysqlConnectProcessor.processOnce():468] Null packet received from network. remote: 192.168.193.23:53518
2025-05-26 16:24:13,171 WARN (mysql-nio-pool-89239|2925558) [ReadListener.lambda$handleEvent$0():60] Exception happened in one session(org.apache.doris.qe.ConnectContext@6ea05763).
java.io.IOException: Error happened when receiving packet.
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:469) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352]
2025-05-26 16:24:28,171 WARN (mysql-nio-pool-89239|2925558) [ResultReceiver.cancel():231] ResultReceiver of query 89257fe068e04bd2-aadcd54a1230d671 cancel failed, typically means the future is finished
2025-05-26 16:24:28,172 WARN (mysql-nio-pool-89239|2925558) [MysqlConnectProcessor.processOnce():468] Null packet received from network. remote: 192.168.193.23:53520
2025-05-26 16:24:28,172 WARN (mysql-nio-pool-89239|2925558) [ReadListener.lambda$handleEvent$0():60] Exception happened in one session(org.apache.doris.qe.ConnectContext@18287caf).

同时导入的效率明显变低

1 Answers

这是warning 日志,首先不建议用高频jdbc insert的方式导入数据。建议走streamliad 的方式。

参考例子改造下:https://github.com/apache/doris/tree/master/samples/stream_load