Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

"Cleanup failed on SFLOW because: Failed to get oldest partition for table FACT_SFLOW" error shows in TippingPoint SMS

    • Updated:
    • 25 Mar 2019
    • Product/Version:
    • TippingPoint SMS 5.1
    • Platform:
    • N/A N/A
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
Details
Public

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.

Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1122196
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.