Hi Paolo, Thanks for answer - I think the memory is not the problem in this case - I still have some of it available and even swap isn't used but I'll check it with smaller cache_entry value. I had problem with memory but then in logs I get this information: "Unable to fork DB writer: Cannot allocate memory" - for now I changed few options and the problem is gone. When I changed plugin from mysql to sqlite3 - updates are made.
I'll check cache_entries and let u know BR Adam 2014-02-06 Paolo Lucente <[email protected]>: > 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 >
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
