Page MenuHomePhabricator

Audit file size
Closed, ResolvedPublic

Description

Post Gravy 'tinkering' we now get the same Adyen audit report twice - each of these is 50MB

-rw-r--r-- 1 jenkins www-data 55164053 Feb 27 02:08 settlement_detail_report_batch_1152.csv
-rw-r--r-- 1 jenkins www-data 55164053 Feb 27 08:26 settlement_detail_report_2026-02-26.csv

If I gzip they go down to 9MB

I'm a bit scared not to keep both of them cos I'm never quite sure when Gravy will cause unexpected change & wasting disk seems less bad than missing out on files (e.g if we stopped receiving the one we had decided we could delete). However I think we could treat one as 'ignored' which seems easier to recover from

There is also a 3rd copy of one of these in gravy/ignored which is the same as the 2 above but with slightly different column names.

Note these are currently weekly files & the peak size is about 5 times this

Easiest option is just to gzip files when they are moved to 'completed' - I already did similar here - https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1247663

Event Timeline

Change #1247710 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Start ignoring one of the adyen audit files

https://gerrit.wikimedia.org/r/1247710

These are now being gzipped when moved to ignored - can do for completed too it we want
Can also ignore one of the adyen files? https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1247710?usp=dashboard

Change #1247710 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Start ignoring one of the adyen audit files

https://gerrit.wikimedia.org/r/1247710

Change #1270579 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Gzip files when completed

https://gerrit.wikimedia.org/r/1270579

Change #1270579 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Gzip files when completed

https://gerrit.wikimedia.org/r/1270579

Eileenmcnaughton added a subscriber: Dwisehaupt.

This is done & working with one follow up patch - https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1276263

@Dwisehaupt it would be reasonable now to gzip all the files in audit/*/completed or audit/*/ignored if they are not already gzipped except perhaps the batches directory as those are different to the others

XenoRyet set Final Story Points to 4.

This compression has been completed. We have dropped from ~133G of space for these files to ~35G.

I used the following command to do the final work:

sudo pigz -9 `find /srv/archive/civi/audit | grep -i .csv$ | grep -v /batches/ | grep -v /incoming/`

This is clear for closing from our end for the compression.