Hello,

using the Log Retention with a value 365 or even 31 the Cronjob /usr/share/centreon/cron/centstorage_purge.php doesn’t clean (all) old comments.

I’ve got comments from 2017.

Responsible SQL Query to cleanup:

DELETE FROM comments WHERE (deletion_time is not null and deletion_time ' .
            '< __RETENTION__) OR (expire_time < __RETENTION__ AND expire_time <> 0)

Value for __RETENTION__ is the value from the config, in my case 365. The table field expire_time is always 0, so the second part of the query is never matching.

The field deletion_time is on many entrys NULL (currently 100174 entrys) and on 3287090 entrys not null. 

I’m not sure about the fields deletion_time and expire_time what are they for. But comments from 2017 shouldn’t be there in Year 2025 with retention period of 365 days. 

Manually checking the filter:

SELECT * FROM centreon_storage.comments WHERE (deletion_time is not null and deletion_time < 1708297200 ) OR (expire_time < 1708297200  AND expire_time <> 0)

Returns 0 results.

SELECT COUNT(*) FROM centreon_storage.comments WHERE entry_time < 1708297200 

Returns 89889.

There are also 89889 comments older then retention.

Should i build my own clean job filtering on entry_time? What are the deletion_time and expire_time for?