This table grows unbound over time resulting in gigabytes of largely unecessary data. From an example customer who has a 2Y old Satellite installation with 20,000 consumers/hosts
table_name | total | index | toast | table
cp_event | 12 GB | 5682 MB | 8192 bytes | 6484 MB
select count(*) from cp_event;
We need a policy and procedure in place to delete anything in this table over ~7 Days (or configurable value) as it is no longer something that needs to be stored.
This will delete all data older than 14 days as anything beyond a week isn't needed.
# echo "delete from cp_event where timestamp < now() - interval '14 days';" | sudo -u postgres psql -d candlepin
This will setup a weekly cron to ensure continuous cleanup.
1) Download cp_event_cleanup from this Bugzilla
2) Copy to /etc/cron.weekly/
3) chmod +x /etc/cron.weekly/cp_event_cleanup
Created attachment 1482482 [details]
Lets get rid of this data entirely. It is not valuable or worth collecting and setting up policy on retention.
I reworded this RFE to state our intentions to just cease collection of the data in the cp_event table and also remove any functionality in the Satellite 6 UI that references the Events tab in the Content Host UI.
Assigning the bug to me since I'm the owner for aha card: SAT-E-342, 343.
According to the comments in aha card, the first part of this feature can be verified:
SAT-E-342: Upgrade Sat6.5 to Sat6.6 [VERIFIED]
1). The 'cp_event' table is still existing, but it will stop writing new data to the table.
2). The 'Events' element is still existing in WebUI, but the table is null.
The second part of this feature is still developing (SAT-E-343) [Ready to develop]
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.