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

["刘珍 (Jira)" <ji...@apache.org>]

刘珍 created IOTDB-1125:
-------------------------

             Summary: set ttl 与flush一起使用，顺序tsfile被delete导致查询Msg: 500: bitIndex < 0: -2147483648
                 Key: IOTDB-1125
                 URL: https://issues.apache.org/jira/browse/IOTDB-1125
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Server
            Reporter: 刘珍
         Attachments: image-2021-01-25-18-13-30-909.png, image-2021-01-25-18-13-34-397.png, image-2021-01-25-18-15-40-631.png

干净的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;


!image-2021-01-25-18-13-34-397.png!

大概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;

报错

!image-2021-01-25-18-15-40-631.png!

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)