[IOTDB-1125] set ttl 与flush一起使用，顺序tsfile被delete导致查询Msg: 500: bitIndex < 0: -2147483648

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0, 0.11.2
• Fix Version/s: 0.12.0
• Component/s: Core/Server
• Labels: pull-request-available
• Environment: 0.11.3-SNAPSHOT
• Assignee: Chao Wang
• Reporter: 刘珍
• Created: 25/Jan/21 10:15
• Updated: 25/Aug/21 08:28
• Resolved: 08/Feb/21 03:39

Description

干净的IoTDB数据库

create timeseries root.db_0.tab0.salary with datatype=INT64,encoding=REGULAR ;

set ttl to root.db_0 100000;   --过期时间100秒

insert 2条记录，时间为当前时间

insert into root.db_0.tab0(time ,salary) values(2021-01-25T18:01:01.000+08:00,1200);

insert into root.db_0.tab0(time ,salary) values(2021-01-25T18:01:02.000+08:00,1200);

执行查询，可以查询到insert的2条记录。

select * from root.db_0.tab0;

大概100秒后再次执行查询，查询结果为空。过期的记录不可见，表现正确。

执行

FLUSH

可以看到data/data/sequence/root.db_0/0下的tsfile文件消失

unset ttl to root.db_0;

再次执行查询

select * from root.db_0.tab0;

查询结果为空，应该可以查询到，因为已经取消ttl。

delete from root.db_0.tab0;

insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:01.000+08:00,1200);
insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:02.000+08:00,1100);
insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:03.000+08:00,1000);
insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:04.000+08:00,2200);
insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:05.000+08:00,1300);
insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:06.000+08:00,1400);
insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:07.000+08:00,1500);
insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:08.000+08:00,1600);
insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:09.000+08:00,1700);
insert into root.db_0.tab0(time ,salary) values(2021-01-25T17:36:10.000+08:00,1800);

flush;

select * from root.db_0.tab0;

报错

 

Issue Links

• Blocked: IOTDB-1140 optimize regular data encoding
• links to: GitHub Pull Request #2597