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
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
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