On Fri, 2 Mar 2018 21:42:35 +0100 Søren Aurehøj soren@fab-it.dk wrote:
** WARNING -- WILL REMOVE ALL GRAPHITE + NAV-DATA **
/etc/init.d/nav stop; /etc/init.d/carbon-cache stop; /etc/init.d/apache2 stop rm -rf /var/lib/graphite/whisper/* rm /var/lib/graphite/graphite.db python /usr/share/pyshared/graphite/manage.py syncdb chown _graphite:_graphite /var/lib/graphite/graphite.db chmod o-r /var/lib/graphite/graphite.db su - postgres -c 'psql nav -c "truncate device, vlan, netbios cascade;"' /etc/init.d/carbon-cache start; /etc/init.d/nav start; /etc/init.d/apache2 start
Which I found in the nav-users mailing list [1]
I'm glad you got it to work, but to me, this looks like total overkill for your situation. You are completely trashing parts of your NAV database, when the problem is only with Graphite's whisper files.
Probably, this would have been more than enough:
cd /etc/carbon rm storage-schemas.conf storage-aggregation.conf ln -s /etc/nav/graphite/storage-schemas.conf . ln -s /etc/nav/graphite/storage-aggregation.conf . service carbon-cache restart rm -rf /var/lib/graphite/whisper/*
Happy NAVing! :-)