You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Jinrui Zhang (Jira)" <ji...@apache.org> on 2022/07/21 11:17:00 UTC
[jira] [Commented] (IOTDB-3842) Failed to Group by LEVEL
[ https://issues.apache.org/jira/browse/IOTDB-3842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17569359#comment-17569359 ]
Jinrui Zhang commented on IOTDB-3842:
-------------------------------------
Fixed in this PR https://github.com/apache/iotdb/pull/6746
> Failed to Group by LEVEL
> -------------------------
>
> Key: IOTDB-3842
> URL: https://issues.apache.org/jira/browse/IOTDB-3842
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Cluster
> Reporter: Chao Wang
> Assignee: Jinrui Zhang
> Priority: Major
> Fix For: 0.14.0
>
>
> INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-27T23:50:00.000+08:00, true, 5, 23, 15.88, 8888.88, "IOTDB!@#$%IOTDB!@#$%IOTDB12346");
> INSERT INTO root.sgcc.wf01.wt01(timestamp, ts1) VALUES (now(), 1);
> INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (now(), true, 5, 23, 15.88, 8888.88, "IOTDB!@#$%IOTDB!@#$%IOTDB12345")
> SELECT COUNT(ts1) FROM root.sgcc.wf01.wt01 WHERE ts1 > 5 and time < 2022-05-26T14:00:00.000+08:00 GROUP BY LEVEL = 1
>
> throw exception:
> Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: "SELECT COUNT(ts1) FROM root.sgcc.wf01.wt01 WHERE ts1 > 5 and time < 2022-05-26T14:00:00.000+08:00 GROUP BY LEVEL = 1". executeStatement failed. null
> log:
> 2022-07-18 18:15:40,178 [20220718_101540_00007_36-54] INFO o.a.i.d.m.p.e.QueryExecution:223 - logical plan is:
> GroupByLevelNode-4: Output: [count(root.sgcc.*.*.ts1)], Input: 1
> └──AggregationNode-3
> └──org.apache.iotdb.db.mpp.plan.planner.plan.node.process.FilterNode@a9826c19
> └──SeriesScanNode-1:[SeriesPath: root.sgcc.wf01.wt01.ts1, DataRegion: Not Assigned]
>
> 2022-07-18 18:15:40,181 [pool-22-IoTDB-RPC-Client-1] WARN o.a.i.d.u.ErrorHandlingUtils:62 - Status code: INTERNAL_SERVER_ERROR(500), operation: "SELECT COUNT(ts1) FROM root.sgcc.wf01.wt01 WHERE ts1 > 5 and time < 2022-05-26T14:00:00.000+08:00 GROUP BY LEVEL = 1". executeStatement failed
> java.util.NoSuchElementException: null
> at java.base/java.util.ArrayList$Itr.next(ArrayList.java:1000)
> at java.base/java.util.Collections.max(Collections.java:713)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.ExchangeNodeAdder.calculateDataRegionByChildren(ExchangeNodeAdder.java:298)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.ExchangeNodeAdder.processMultiChildNode(ExchangeNodeAdder.java:224)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.ExchangeNodeAdder.visitGroupByLevel(ExchangeNodeAdder.java:212)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.ExchangeNodeAdder.visitGroupByLevel(ExchangeNodeAdder.java:59)
> at org.apache.iotdb.db.mpp.plan.planner.plan.node.process.GroupByLevelNode.accept(GroupByLevelNode.java:129)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.ExchangeNodeAdder.visit(ExchangeNodeAdder.java:325)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.DistributionPlanner.addExchangeNode(DistributionPlanner.java:59)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.DistributionPlanner.planFragments(DistributionPlanner.java:69)
> at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.doDistributedPlan(QueryExecution.java:231)
> at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.start(QueryExecution.java:165)
> at org.apache.iotdb.db.mpp.plan.Coordinator.execute(Coordinator.java:131)
> at org.apache.iotdb.db.service.thrift.impl.ClientRPCServiceImpl.executeStatement(ClientRPCServiceImpl.java:562)
> at org.apache.iotdb.service.rpc.thrift.IClientRPCService$Processor$executeStatement.getResult(IClientRPCService.java:2853)
> at org.apache.iotdb.service.rpc.thrift.IClientRPCService$Processor$executeStatement.getResult(IClientRPCService.java:2833)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38)
> at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:248)
> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:829)
> 2022-07-18 18:15:40,183 [20220718_101540_00007_36-54] INFO o.a.i.d.s.t.i.ClientRPCServiceImpl:1370 - stop and clean up
--
This message was sent by Atlassian Jira
(v8.20.10#820010)