刘珍 created IOTDB-3773: ------------------------- Summary: [ query ] The first batch of results is not output Key: IOTDB-3773 URL: https://issues.apache.org/jira/browse/IOTDB-3773 Project: Apache IoTDB Issue Type: Bug Components: mpp-cluster Affects Versions: 0.14.0-SNAPSHOT Reporter: 刘珍 Assignee: Yuan Tian
master_0704_9f79ce6 , 执行查询 grep "align by device" logs/log_all.log 2022-07-07 16:17:04,778 [20220707_081704_00000_3-166] INFO o.a.i.d.m.p.Coordinator:115 - start executing sql: select count(s_4) from root.** align by device 2022-07-07 16:50:14,359 [pool-61-IoTDB-RPC-Client-1] INFO o.a.i.d.s.t.i.ClientRPCServiceImpl:593 - {color:red}*Cost: 1989760 ms*{color}, sql is select count(s_4) from root.** align by device 日志中出现查询耗时,但是后续日志还在打印此queryID的查询信息,请教田原:查询返回第一个fetch result会打印这个日志,{color:red}*但是并没有输出查询结果,需解决。*{color} 复现流程 1. 192.168.10.62/66/68 schema_region_consensus_protocol_class=org.apache.iotdb.consensus.ratis.RatisConsensus data_region_consensus_protocol_class=org.apache.iotdb.consensus.multileader.MultiLeaderConsensus schema_replication_factor=3 data_replication_factor=3 query_timeout_threshold=3600000 数据:/data/liuzhen_test/master_0704_9f79ce6/datanode/data 3.8TB 1000个设备 共3,000,000序列 ip62 cli执行查询: nohup ./sbin/start-cli.sh -h 192.168.10.62 -e "select count(s_4) from root.** align by device;" > s4.out & 查询结果:|root.test.g_0.d_ip62_991| 676560| |root.test.g_0.d_ip62_992| 676560| |root.test.g_0.d_ip62_993| 676560| |root.test.g_0.d_ip62_994| 676560| |root.test.g_0.d_ip62_995| 676560| |root.test.g_0.d_ip62_996| 676560| |root.test.g_0.d_ip62_997| 676560| |root.test.g_0.d_ip62_998| 676560| |root.test.g_0.d_ip62_999| 676560| +------------------------+----------+ It costs 3477.116s Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: fetchResults failed. Task was cancelled. (最后这个异常还是因为超时被kill) -- This message was sent by Atlassian Jira (v8.20.10#820010)