Lei Rui created IOTDB-317:
-----------------------------
Summary: [0.8.1] flush data, execute a wrong aggregation query and
the server fails
Key: IOTDB-317
URL: https://issues.apache.org/jira/browse/IOTDB-317
Project: Apache IoTDB
Issue Type: Bug
Reporter: Lei Rui
*tag release/0.8.1*
I start a new server and run the following commands in a client:
```
SET STORAGE GROUP TO root.ln.wf01.wt01;
CREATE TIMESERIES root.ln.wf01.wt01.status WITH DATATYPE=BOOLEAN, ENCODING=PLAIN
CREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT,
ENCODING=PLAIN
CREATE TIMESERIES root.ln.wf01.wt01.hardware WITH DATATYPE=INT32, ENCODING=PLAIN
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware)
values(1, 1.1, false, 11)
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware) values(2,
2.2, true, 22)
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware) values(3,
3.3, false, 33 )
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware)
values(4, 4.4, false, 44)
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware) values(5,
5.5, false, 55)
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware)
values(6, 1.1, false, 11)
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware) values(7,
2.2, true, 22)
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware) values(8,
3.3, false, 33 )
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware)
values(9, 4.4, false, 44)
INSERT INTO root.ln.wf01.wt01(timestamp,temperature,status, hardware)
values(10, 5.5, false, 55)
select mean(temperature) from root.ln.wf01.wt01
*select abc(temperature) from root.ln.wf01.wt01*
// Msg: Cannot get column abc(root.ln.wf01.wt01.temperature) data type
// It costs 0.014s
select mean(temperature) from root.ln.wf01.wt01
select count(temperature) from root.ln.wf01.wt01
*flush*
select count(temperature) from root.ln.wf01.wt01
// Msg: null
// It costs 0.011s
select * from root
// Msg: java.nio.channels.ClosedByInterruptException
// It costs 0.015s
```
As can be seen, after executing a wrong aggregation query "select
abc(temperature) from root.ln.wf01.wt01" and a flush command (you can also
flush before executing this wrong aggregation query), the following two queries
fail.
I then close the client and restart a new client, queries still fail.
I close the server and restart, queries work finally.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
