[pmacct-discussion] Netflow ASR1K

2010-09-11 Thread Thomas Raabo - ZitCom A/S
Iam trying trying to get some numbers that i can use... Iam exporting from two cisco asr1002 routers. What i then do is ftp a 15 gb file the goes via the asr1002 routers and i just cant seem to see the numbers And after an hour i just seeing 17751 bytes of data in mysql... And iam not

[pmacct-discussion] duplicates...

2010-09-11 Thread Thomas Raabo - ZitCom A/S
Once every 10 min iam getting some errors DEBUG ( default/mysql ): purging process (CAUSE: safe action) ( default/mysql ) *** Purging cache - START *** DEBUG ( default/mysql ): 568 VALUES statements sent to the MySQL server. ERROR ( default/mysql ): Duplicate entry

Re: [pmacct-discussion] duplicates...

2010-09-11 Thread Paolo Lucente
Hi Thomas, This very likely answers why you are not seeing all you expect in the database. Reason you get duplicates is pmacct is trying to insert into the database more than once per 600 seconds (as per your configuration) and sql_dont_try_update is set to true. So quickest work-around is to