Hi George-Cristian, One or more plugins that bail out and consequently core process that closes up after all plugins are gone (essentially, the message you posted) could be symptom of plugins crashing for some reason. It can help if you run the daemon under gdb with follow-fork-mode set to child and post the backtrace. Please follow this up with gdb ouptuts, etc. privately.
Cheers, Paolo On Wed, Jun 19, 2013 at 11:01:30AM +0300, George-Cristian Bîrzan wrote: > Is it possible to auto-reconnect to the DB when the connection is lost? For > reasons that pass understanding, sometimes, pmacct decides it lost the > connection to the DB, at which point it just dies: > > Jun 19 04:01:53 host nfacctd[24062]: INFO: connection lost to 'out-pgsql'; > closing connection. > Jun 19 04:01:53 host nfacctd[24062]: INFO: no more plugins active. Shutting > down. > > At that time, our PostgreSQL server didn't log anything: > > 2013-06-17 16:51:46 UTC HINT: Consider increasing the configuration > parameter "checkpoint_segments". > 2013-06-17 16:51:48 UTC LOG: checkpoints are occurring too frequently (2 > seconds apart) > 2013-06-17 16:51:48 UTC HINT: Consider increasing the configuration > parameter "checkpoint_segments". > 2013-06-17 17:53:52 UTC WARNING: pgstat wait timeout > 2013-06-17 23:58:02 UTC WARNING: pgstat wait timeout > 2013-06-19 07:52:18 UTC LOG: checkpoints are occurring too frequently (25 > seconds apart) > 2013-06-19 07:52:18 UTC HINT: Consider increasing the configuration > parameter "checkpoint_segments". > > (The 7:52 one is when I restarted it now. And, yeah, gonna fix the psql > stuff, but so far it's been not a problem, as the load on the machine is > literally 0 as long as we don't do stupid stuff like try to read the > hundreds of GB of data) > > -- > George-Cristian Bîrzan > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
