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 '0-unknown-0:0:0:0:0:0-0:0:0:0:0:0-0-0-0-188.176.68.71-194.182.12' for key 'PRIMARY'
DEBUG ( default/mysql ): purging process (CAUSE: safe action) ( default/mysql ) *** Purging cache - START *** DEBUG ( default/mysql ): 569 VALUES statements sent to the MySQL server. ERROR ( default/mysql ): Duplicate entry '0-unknown-0:0:0:0:0:0-0:0:0:0:0:0-0-0-0-91.100.100.103-94.231.97' for key 'PRIMARY' DEBUG ( default/mysql ): purging process (CAUSE: safe action) ( default/mysql ) *** Purging cache - START *** DEBUG ( default/mysql ): 565 VALUES statements sent to the MySQL server. ERROR ( default/mysql ): Duplicate entry '0-unknown-0:0:0:0:0:0-0:0:0:0:0:0-0-0-0-94.231.102.73-95.166.47.' for key 'PRIMARY' My config ! nfacctd configuration example ! ! Did you know CONFIG-KEYS contains the detailed list of all configuration keys ! supported by 'nfacctd' and 'pmacctd' ? ! debug: true !daemonize: true aggregate: tag, src_host, dst_host plugin_pipe_size: 40960000 plugin_buffer_size: 40960 nfacctd_port: 9000 ! nfacctd_time_secs: true nfacctd_time_new: true plugins: mysql sql_db: pmacct sql_table: acct sql_table_version: 2 sql_passwd: ***** sql_user: root sql_refresh_time: 600 sql_multi_values: 100000 sql_dont_try_update: true sql_cache_entries: 256000 ! sql_optimize_clauses: true sql_history: 10m sql_history_roundoff: mh Thomas
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
