search cancel

CSR File is very large like 55 GB

book

Article ID: 175065

calendar_today

Updated On:

Products

Security Analytics

Issue/Introduction

CSR File is very large like 55 GB

Environment

7.2.2

Cause

There is an issue in 7.2.2 that would create blank Indicators.  It does it faster and faster until the postgres database is 55GB is size.

Resolution

To fix it, please run the following 2 commands:

echo "DELETE FROM deepsee_favorites WHERE name = ''" | su – postgres -c "psql -d dsweb"
echo "VACUUM (FULL, ANALYZE, VERBOSE) deepsee_favorites" | su – postgres -c "psql -d dsweb"

OR if you prefer, from the postgres command line:
> VACUUM (FULL, ANALYZE, VERBOSE) deepsee_favorites;
#> SELECT COUNT(*) AS count FROM deepsee_favorites AS df WHERE df.name = '';
#> DELETE FROM deepsee_favorites WHERE name = '';