[
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)