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/26 07:55:00 UTC
[jira] [Commented] (IOTDB-3960) NPE when executing align by device with value filter query
[ https://issues.apache.org/jira/browse/IOTDB-3960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17571269#comment-17571269 ]
Jinrui Zhang commented on IOTDB-3960:
-------------------------------------
Got it
> NPE when executing align by device with value filter query
> ----------------------------------------------------------
>
> Key: IOTDB-3960
> URL: https://issues.apache.org/jira/browse/IOTDB-3960
> Project: Apache IoTDB
> Issue Type: Bug
> Affects Versions: master branch
> Reporter: Minghui Liu
> Assignee: Jinrui Zhang
> Priority: Major
> Fix For: master branch
>
>
> 228284 [20220726_021157_00097_0-56] INFO o.a.iotdb.db.mpp.plan.Coordinator - start executing sql: select * from root.** where s1 > 100 align by device
> 228284 [20220726_021157_00097_0-56] INFO o.a.i.db.mpp.plan.analyze.Analyzer - Query[20220726_021157_00097_0]: fetch query schema...
> 228284 [20220726_021157_00097_0-56] INFO o.a.i.db.mpp.plan.analyze.Analyzer - Query[20220726_021157_00097_0]: fetch schema done
> 228284 [20220726_021157_00097_0-56] INFO o.a.i.d.m.p.e.QueryExecution - logical plan is:
> DeviceView-10
> ├──TransformNode-2
> │ └──AlignedSeriesScanNode-1:[SeriesPath: root.sg1.d1[s3,s4,s5,s1,s2], DataRegion: Not Assigned]
> └──TransformNode-9
> └──TimeJoinNode-8
> ├──SeriesScanNode-3:[SeriesPath: root.sg1.d2.s3, DataRegion: Not Assigned]
> ├──SeriesScanNode-4:[SeriesPath: root.sg1.d2.s4, DataRegion: Not Assigned]
> ├──SeriesScanNode-5:[SeriesPath: root.sg1.d2.s5, DataRegion: Not Assigned]
> ├──SeriesScanNode-6:[SeriesPath: root.sg1.d2.s1, DataRegion: Not Assigned]
> └──SeriesScanNode-7:[SeriesPath: root.sg1.d2.s2, DataRegion: Not Assigned]
>
> 260374 [pool-23-IoTDB-timedQuerySqlCount-1] INFO QUERY_FREQUENCY - Query count in current 1 minute 2
> 267140 [pool-18-IoTDB-RPC-Client-1] ERROR o.a.i.db.utils.ErrorHandlingUtils - Status code: INTERNAL_SERVER_ERROR(500), operation: "select * from root.** where s1 > 100 align by device". executeStatement failed
> java.lang.NullPointerException: null
> at org.apache.iotdb.db.mpp.plan.planner.plan.FragmentInstance.setDataRegionAndHost(FragmentInstance.java:96)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.SimpleFragmentParallelPlanner.produceFragmentInstance(SimpleFragmentParallelPlanner.java:105)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.SimpleFragmentParallelPlanner.prepare(SimpleFragmentParallelPlanner.java:80)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.SimpleFragmentParallelPlanner.parallelPlan(SimpleFragmentParallelPlanner.java:71)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.DistributionPlanner.planFragmentInstances(DistributionPlanner.java:92)
> at org.apache.iotdb.db.mpp.plan.planner.distribution.DistributionPlanner.planFragments(DistributionPlanner.java:76)
> at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.doDistributedPlan(QueryExecution.java:274)
> at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.start(QueryExecution.java:181)
> at org.apache.iotdb.db.mpp.plan.Coordinator.execute(Coordinator.java:146)
> 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)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)