Summary
The following warning message may regularly appear in the SMS System Log:
Cleanup failed on SFLOW because: Failed to get oldest partition for table "FACT_SFLOW"
This happens in TippingPoint SMS v2 Appliance w/25-IPS 4.5.0.98012. Upon checking, the following error lines are visible in LTT:
Logfile,Line,Date,Severity,Class,Message
sms-info.log,5987,2018-02-27 09:31:39,ERROR,VerticaCleanup, Error in getting oldest partition
sms-info.log,18380,2018-02-27 09:41:39,ERROR,VerticaCleanup, Error in getting oldest partition
sms-info.log,30771,2018-02-27 09:51:39,ERROR,VerticaCleanup, Error in getting oldest partition
This is an issue that has been improved in the newer versions of TippingPoint SMS.
To address the problem, restart the vertica database from service mode:
/etc/init.d/dwd stop
/etc/init.d/dwd start
If the issue persists, run the following:
rm -f /usr/local/TippingPoint/SMS/logs/healthstats.pid
/etc/init.d/healthstats start
If the procedure above does not work, upgrade to the latest SMS version.