Hi Adam, Is it possible you are running out of memory or so? And maybe as a side result of swapping also CPU is 100%? I see in your config you have 'sql_cache_entries: 256000' which should take quite some memory per each plugin defined.
Cheers, Paolo On Thu, Feb 06, 2014 at 02:02:14PM +0100, Adam Bogdan wrote: > Hi again, > > I have a problem with running nfacctd to serve 3 mysql plugins/tables - > version nfacctd 1.5.0rc2 > config: > daemonize: true > debug: true > pidfile: /var/run/nfacctd_r7.pid > syslog: daemon > > aggregate: tag, src_as, dst_as, peer_src_as, peer_dst_as > nfacctd_ip: x.x.x.x > nfacctd_port: x > nfacctd_time_new: true > nfacctd_as_new: fallback > nfacctd_net: fallback > nfacctd_disable_checks: true > > networks_file: /etc/pmacct/networks.lst > pre_tag_map: /etc/pmacct/pretag.map > pre_tag_filter[abc]: 11 > pre_tag_filter[ddd]: 10 > pre_tag_filter[vcc]: 20 > > plugins: mysql[abc], mysql[ddd], mysql[vcc] > plugin_pipe_size: 65440000 > plugin_buffer_size: 30000 > > bgp_daemon: true > bgp_daemon_ip: x.x.x.x > bgp_daemon_max_peers: 10 > bgp_peer_src_as_type: bgp > bgp_src_as_path_type: bgp > bgp_daemon_msglog: false > bgp_agent_map: /etc/pmacct/agent.map > > sql_optimize_clauses: true > sql_dont_try_update: true > sql_multi_values: 1024000 > sql_db: pmacct > sql_host: x > sql_passwd: x > sql_table_version: 7 > sql_table_type: bgp > sql_cache_entries: 256000 > sql_preprocess: usrf=2000 > > sql_history_roundoff[abc]: m > sql_history[abc]: 5m > sql_refresh_time[abc]: 300 > sql_table[abc]: acct_bgp_abc > > sql_history_roundoff[ddd]: m > sql_history[ddd]: 5m > sql_refresh_time[ddd]: 300 > sql_table[ddd]: acct_bgp_ddd > > sql_history_roundoff[vcc]: m > sql_history[vcc]: 5m > sql_refresh_time[vcc]: 300 > sql_table[vcc]: acct_bgp_r7_vcc > > And this configuration doesn't work :( - If I enable only mysql abc i ddd > then it's ok - updates to DB are made and everything is working - when I > added vcc - it's dead - nfacctd is running but no updates to DB > - when I turn on debugging - I get only keepalives from BGP - neither one > update. When I turn off abc and ddd - vcc is working fine (updates etc.) > One more hint - when I run config above, I can't kill nfacctd normally - > only with option -9 > > > Thanks for help > > Regards > Adam > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
