Hi Piotr, We will look into why the auto purge is having issues, but ideally the sizing and configuration needs to be done such that we don’t run into space issues.. Can you check and reduce the ttl for different traffic in contrail-collector.conf file #analytics_data_ttl=48 #analytics_config_audit_ttl=2160 #analytics_statistics_ttl=168 #analytics_flow_ttl=2 Can you let us know what’s the size of the disk space you have?
From R2.22 onwards we will an option to do sampling of flows and the rate of flow messages to collector can be controlled.. thanks Raj On Sep 12, 2015, at 1:25 PM, Piotr P <[email protected]<mailto:[email protected]>> wrote: Hi all, Could someone give advice how to purge flow database in Contrail 2.20 (64) It seems that I getting error that is already submitted on the launchpad. https://bugs.launchpad.net/juniperopenstack/+bug/1487966 In my case I can see similar messages. I've tried purge from web panel, as also via api as described here https://github.com/Juniper/contrail-controller/wiki/Contrail-Analytics-DB-data-purge as a result i got { purge_start_time: "1442086618710112" status: "running" purge_input: "{'msg_cutoff': 1442000218707280, 'flow_cutoff': 1442000218707280, 'other_cutoff': 1442000218707280, 'stats_cutoff': 1442000218707280}" purge_id: "a1f0ae57-5985-11e5-adad-00000ab90971" } I can see in analytics log error for this this purge_id 09/12/2015 07:16:51 PM [node-1:contrail-analytics-api:Analytics:0]: Database usage of 80 on node-11 exceeds threshold 09/12/2015 07:16:51 PM [node-1:contrail-analytics-api:Analytics:0]: start times:OrderedDict([('SystemObjectStartTime', 1437336915438506), ('SystemObjectFlowStartTime', 1437336915438506), ('SystemObjectStatStartTime', 1437336915438506), ('SystemObjectMsgStartTime', 1437336915438506)]) 09/12/2015 07:17:33 PM [node-1:contrail-analytics-api:Analytics:0]: Exception: Purge_id:d240d8d8-5982-11e5-9341-0050568cda0a table:MessageTableTimestamp error: 'int' object has no attribute '__getitem__' 09/12/2015 07:36:58 PM [node-1:contrail-analytics-api:Analytics:0]: start times:OrderedDict([('SystemObjectStartTime', 1437336915438506), ('SystemObjectFlowStartTime', 1437336915438506), ('SystemObjectStatStartTime', 1437336915438506), ('SystemObjectMsgStartTime', 1437336915438506)]) 09/12/2015 07:37:47 PM [node-1:contrail-analytics-api:Analytics:0]: Exception: Purge_id:a1f0ae57-5985-11e5-adad-00000ab90971 table:MessageTableTimestamp error: 'int' object has no attribute '__getitem__' I'd be glad on some hit here or on priv. Also let me ask. Is it possible to disable log flow messages on a vrouter ? I saw solution by using iptables and block specific type of messages, but maybe more clean solution is also available ? Kind Regards Piotr Pieprzycki _______________________________________________ Users mailing list [email protected]<mailto:[email protected]> http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org
_______________________________________________ Users mailing list [email protected] http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org
