You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
insert into table1(siteid,citycode,username,pv) values(1,1,'jim',2);
insert into table1(siteid,citycode,username,pv) values(2,1,'grace',2);
insert into table1(siteid,citycode,username,pv) values(3,2,'tom',2);
insert into table1(siteid,citycode,username,pv) values(4,3,'bush',3);
insert into table1(siteid,citycode,username,pv) values(5,3,'helen',3);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-03',1,1,'jim',2);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-05',2,1,'grace',2);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-12',3,2,'tom',2);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-15',4,3,'bush',3);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-12',5,3,'helen',3);
后台有时候有奇怪的日志,不确定与上面现象是否有关,里面的IP非我部署的3台机器的任何一个,无17.20.x.x的服务器。
2021-10-21 14:37:47,006 WARN (doris-mysql-nio-pool-47|537) [StmtExecutor.execute():362] execute Exception
org.apache.doris.rpc.RpcException: Couldn't open transport for 172.20.0.1:9020 (open() timed out)
at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:705) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:766) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:298) ~[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:1149) [?:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
2021-10-21 14:37:48,887 WARN (doris-mysql-nio-pool-45|535) [Coordinator.getNext():688] get next fail, need cancel. query id: a6918ad7c5334e16-a220865bdf824b6c
2021-10-21 14:37:48,887 WARN (doris-mysql-nio-pool-45|535) [Coordinator.updateStatus():670] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: a6918ad7c5334e16-a220865bdf824b6c, instance id: NaN
2021-10-21 14:37:48,888 WARN (doris-mysql-nio-pool-45|535) [StmtExecutor.execute():362] execute Exception
org.apache.doris.rpc.RpcException: Couldn't open transport for 172.20.0.1:9020 (open() timed out)
at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:705) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:766) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:298) ~[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:1149) [?:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
2021-10-21 14:37:51,890 WARN (doris-mysql-nio-pool-46|536) [Coordinator.getNext():688] get next fail, need cancel. query id: d74ebcb1a0dc4fa0-8b4e1b8c2bf6793e
2021-10-21 14:37:51,890 WARN (doris-mysql-nio-pool-46|536) [Coordinator.updateStatus():670] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: d74ebcb1a0dc4fa0-8b4e1b8c2bf6793e, instance id: NaN
2021-10-21 14:37:51,891 WARN (doris-mysql-nio-pool-46|536) [StmtExecutor.execute():362] execute Exception
org.apache.doris.rpc.RpcException: Couldn't open transport for 172.20.0.1:9020 (open() timed out)
at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:705) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:766) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:298) ~[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:1149) [?:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
2021-10-21 14:37:51,914 WARN (doris-mysql-nio-pool-46|536) [StmtExecutor.execute():358] execute Exception. errCode = 2, detailMessage = Unknown column 'ROUTINE_SCHEMA' in 'ROUTINES'
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
背景:docker里面编译的1.4.0,部署了一个fe,3个be, 暂没部署broke,fe,be共用一个存储较大的服务器,其它be节点存储较小。
1.文档示例结构的table1,table2表在批量执行下面语句时,只提交了一个查询后面的就卡死了。
2.或者一个个sql执行,第一个成功,第二个执行就卡死,终止反复提交几次会成功,如果不终止过较长时间自动超时终止。
请问上面正常吗? 原因可能是?其它查询导入本地文件未见异常
insert into table1(siteid,citycode,username,pv) values(1,1,'jim',2);
insert into table1(siteid,citycode,username,pv) values(2,1,'grace',2);
insert into table1(siteid,citycode,username,pv) values(3,2,'tom',2);
insert into table1(siteid,citycode,username,pv) values(4,3,'bush',3);
insert into table1(siteid,citycode,username,pv) values(5,3,'helen',3);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-03',1,1,'jim',2);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-05',2,1,'grace',2);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-12',3,2,'tom',2);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-15',4,3,'bush',3);
insert into table2(event_day,siteid,citycode,username,pv) values('2017-07-12',5,3,'helen',3);
后台有时候有奇怪的日志,不确定与上面现象是否有关,里面的IP非我部署的3台机器的任何一个,无17.20.x.x的服务器。
2021-10-21 14:37:47,006 WARN (doris-mysql-nio-pool-47|537) [StmtExecutor.execute():362] execute Exception
org.apache.doris.rpc.RpcException: Couldn't open transport for 172.20.0.1:9020 (open() timed out)
at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:705) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:766) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:298) ~[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:1149) [?:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
2021-10-21 14:37:48,887 WARN (doris-mysql-nio-pool-45|535) [Coordinator.getNext():688] get next fail, need cancel. query id: a6918ad7c5334e16-a220865bdf824b6c
2021-10-21 14:37:48,887 WARN (doris-mysql-nio-pool-45|535) [Coordinator.updateStatus():670] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: a6918ad7c5334e16-a220865bdf824b6c, instance id: NaN
2021-10-21 14:37:48,888 WARN (doris-mysql-nio-pool-45|535) [StmtExecutor.execute():362] execute Exception
org.apache.doris.rpc.RpcException: Couldn't open transport for 172.20.0.1:9020 (open() timed out)
at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:705) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:766) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:298) ~[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:1149) [?:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
2021-10-21 14:37:51,890 WARN (doris-mysql-nio-pool-46|536) [Coordinator.getNext():688] get next fail, need cancel. query id: d74ebcb1a0dc4fa0-8b4e1b8c2bf6793e
2021-10-21 14:37:51,890 WARN (doris-mysql-nio-pool-46|536) [Coordinator.updateStatus():670] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: d74ebcb1a0dc4fa0-8b4e1b8c2bf6793e, instance id: NaN
2021-10-21 14:37:51,891 WARN (doris-mysql-nio-pool-46|536) [StmtExecutor.execute():362] execute Exception
org.apache.doris.rpc.RpcException: Couldn't open transport for 172.20.0.1:9020 (open() timed out)
at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:705) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:766) ~[palo-fe.jar:3.4.0]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:298) ~[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:1149) [?:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
2021-10-21 14:37:51,914 WARN (doris-mysql-nio-pool-46|536) [StmtExecutor.execute():358] execute Exception. errCode = 2, detailMessage = Unknown column 'ROUTINE_SCHEMA' in 'ROUTINES'
Beta Was this translation helpful? Give feedback.
All reactions