问题1 :
fe.warn.log出现大量日志如下:
2021-12-24 00:16:27,233 WARN (starrocks-mysql-nio-pool-754|872) [ReadListener.lambda$handleEvent$485():62] Exception happ
ened in one session(com.starrocks.mysql.nio.NConnectContext@25865af8).
java.io.IOException: Error happened when receiving packet.
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:624) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$485(ReadListener.java:54) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151]
说明:3台测试机,每台测试机部署一个fe和be,组成一个集群(3fe,3be节点)
starrocks版本: v1.19.x
问题二:
starrocks数据写入es,建议采用什么方案?
说明:测试发现,starrocks es外部表,写入starrocks数据报错,如下:
mysql> insert into sr2es_test1 values(‘2021-12-23’,12,1,‘abc’,‘2021-12-23 14:00:00’);
ERROR 1064 (HY000): New planner only support insert into olap table