TTL configured，but vid still can be found after expiration,after compaction looks normal

[shanlai]

version:

steps

1. execute ngql:

 CREATE TAG IF NOT EXISTS ttl01 (a timestamp);
 ALTER TAG ttl01 TTL_COL = "a", TTL_DURATION = 60;
 INSERT VERTEX ttl01(a) VALUES "ttl01_01":(now());
 match (v:ttl01) return v limit 1;
 submit job compact
 match (v:ttl01) return v limit 1;

Execution plan of nGQL: match (v:ttl01) return v limit 1;

2. The problems found are as follows:

• tag: TTL configured，but vid still can be found after expiration,after compaction looks normal，edge same as tag

[critical27]

Which version is your kernel? 3.1 enterprise version?

[shanlai]

3.1.0

[HarrisChu]

for issue 2, refer #3958
we have two times:

• ::time(NULL);
• time::WallClock::fastNowInSec();

now() uses the first, and checkDataExpiredForTTL uses the second.

how to reduce:

1. start storage
2. change system time, e.g. date -s 04:12:00
3. execute query insert vertex l1(a) values "101":(now())

[critical27]

for issue 2, refer #3958 we have two times:

• ::time(NULL);
• time::WallClock::fastNowInSec();

now() uses the first, and checkDataExpiredForTTL uses the second.

how to reduce:

1. start storage
2. change system time, e.g. date -s 04:12:00
3. execute query insert vertex l1(a) values "101":(now())

👍

[critical27]

This need to verified after tagless vertex has been removed. It is expected behavior for the first issue