xiaozhihong created IOTDB-1325:
----------------------------------
Summary: Count natural month query data results report stack
overflow
Key: IOTDB-1325
URL: https://issues.apache.org/jira/browse/IOTDB-1325
Project: Apache IoTDB
Issue Type: Bug
Components: Server
Affects Versions: 0.12.0
Environment: 192.168.130.11
Reporter: xiaozhihong
The results of the operation are as follows:
select * from root.ln.wf01.wt01
+-----------------------------+-----------------------------+------------------------+--------------------------+
|
Time|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status|root.ln.wf01.wt01.hardware|
+-----------------------------+-----------------------------+------------------------+--------------------------+
|1970-01-01T08:00:01.000+08:00| 25.62| false| null|
|2018-01-01T00:08:15.000+08:00| 20.55| false| 1|
|2018-01-02T00:08:15.000+08:00| 20.55| false| 1|
|2018-01-03T00:08:15.000+08:00| 20.55| false| 1|
|2018-01-15T00:08:15.000+08:00| 20.55| false| 1|
|2018-01-25T00:08:15.000+08:00| 20.55| false| 1|
|2018-01-30T00:08:15.000+08:00| 20.55| false| 1|
|2018-02-01T00:08:15.000+08:00| 25.15| true| 2|
|2018-02-05T00:08:15.000+08:00| 25.15| true| 2|
|2018-02-15T00:08:15.000+08:00| 25.15| true| 2|
|2018-02-25T00:08:15.000+08:00| 25.15| true| 2|
|2018-02-28T00:08:15.000+08:00| 25.15| true| 2|
|2018-03-01T00:08:15.000+08:00| 25.15| true| 3|
|2018-03-10T00:08:15.000+08:00| 25.15| true| 3|
|2018-03-15T00:08:15.000+08:00| 25.15| true| 3|
|2018-03-25T00:08:15.000+08:00| 25.15| true| 3|
|2018-03-30T00:08:15.000+08:00| 25.15| true| 3|
|2018-03-31T00:08:15.000+08:00| 25.15| true| 3|
|2018-04-01T00:08:15.000+08:00| 25.15| true| 4|
|2018-04-10T00:08:15.000+08:00| 25.15| true| 4|
|2018-04-20T00:08:15.000+08:00| 25.15| true| 4|
|2018-04-30T00:08:15.000+08:00| 25.15| true| 4|
|2018-05-01T00:08:15.000+08:00| 25.15| false| 5|
|2018-05-10T00:08:15.000+08:00| 25.15| false| 5|
|2018-05-15T00:08:15.000+08:00| 25.15| false| 5|
|2018-05-25T00:08:15.000+08:00| 25.15| false| 5|
|2018-05-30T00:08:15.000+08:00| 25.15| false| 5|
|2018-05-31T00:08:15.000+08:00| 25.15| false| 5|
+-----------------------------+-----------------------------+------------------------+--------------------------+
Total line number = 28
It costs 0.084s
IoTDB> select count(*) from root.ln.wf01.wt01 group by
((2018-01-31,2018-03-31],1mo)
Msg: Fail to execute select count(*) from root.ln.wf01.wt01 group by
((2018-01-31,2018-03-31],1mo)
log_error.log:
2021-04-23 14:01:50,005 [pool-8-IoTDB-RPC-Client-8] ERROR
o.a.i.d.c.IoTDBDefaultThreadExceptionHandler:31 - Exception in thread
pool-8-IoTDB-RPC-Cl
ient-8-68
java.lang.StackOverflowError: null
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.getNextIntervalAndSlidingStep(GroupByMonthFilter.java:166)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:73)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
at
org.apache.iotdb.tsfile.read.filter.GroupByMonthFilter.satisfy(GroupByMonthFilter.java:74)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
