shivakumar created IGNITE-12152:
-----------------------------------

             Summary: Disk space not getting released after deleting rows from 
a table or after records expired with expiration policy
                 Key: IGNITE-12152
                 URL: https://issues.apache.org/jira/browse/IGNITE-12152
             Project: Ignite
          Issue Type: Bug
          Components: documentation, persistence, sql
    Affects Versions: 2.7
            Reporter: shivakumar


To reproduce,

create a cache group and create a sql table using that cache group, then insert 
considerable rows of records to the table, monitor the disk space usage, now 
stop inserting records and delete records from the table using 

*DELETE FROM table;  (not a drop table operation)*

once this is done the *select count(*) from table;* shows the count 0 but after 
this when disk space is monitored it will be in the same usage level as it is 
in the level before rows deletion.

When I start inserting records again, the new records re-used the space 
occupied by the deleted records but still, it is not a good idea to 
unnecessarily hold disk resource.

The same can be reproduced by configuring cache expiry policy 
(CreatedExpiryPolicy) where after records expires it will not be visible in sql 
query (select * from table) but still it will hold disk resource.

 

 



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Reply via email to