Hi Javier, The new poller do not like pgsql (7.4.x) in Fodera 3 env. [EMAIL PROTECTED] engine]# php poller2.php Content-type: text/html X-Powered-By: PHP/4.3.10
21:05:53 db_ping(pg) Connection to DB Restored... 21:05:54 db_ping(pg) Connection to DB Restored... 21:05:55 db_ping(pg) Connection to DB Restored... 21:05:56 db_ping(pg) Connection to DB Restored... 21:05:57 db_ping(pg) Connection to DB Restored... Query failed - R2 - ERROR: column "hosts.last_poll_date" must appear in the GROUP BY clause or be used in an aggregate function Min -----Original Message----- From: Javier Szyszlican [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 3:20 PM Cc: [email protected] Subject: [jffnms-users] Re: JFFNMS php processes using all available system resources Hi Aaron, Aaron Daubman wrote: > Hi Javier, et al; > > Pardon if I don't provide enough useful information up front - let me > know what would be useful to know and I'll include it. > > I'm in the process of setting up a brand new JFFNMS 0.8.1 install on a > Sunfire V20z dual opteron with 2G ram running FreeBSD 5.3-Stable SMP > for amd64 with apache2, mysql 4.1.10 and php5. > Wow, nice boxes... :) > So far I'm monitoring 6 switches and a VPN concentrator with a total > of 1191 interfaces. > > Everything had been running fine for 1.5 weeks with just 3 switches > (and maybe 600 interfaces). Early this week I added the rest of the > hosts and after a while, at random, I started getting errors like > this: > > Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to > allocate 128 bytes) in /opt/jffnms/lib/api.events.inc.php on line 288 > > Going on a previous post, I increased the memory limit in php.ini from > 8M to 32M and that seemed to fix the problem. > Thats ok. > Today, a day after upping the php memory limit, I tried to log in to > the box and could not. The console cli reacted very sluggishly. > About 15 minutes later it seems the box keeled over and reloaded. > Almost all available memory was used (it appeared by php) and the > processor load would spike. I'm attaching a text file of the output > of `ps -auxw` from 15 minutes before the box reloaded. > > After the reload, the box seems to be functioning fine - I'm just > waiting now for it to happen again. > > What should I be looking at to diagnose root-cause? I wouldn't think > 1000 interfaces would be too much for a box of this caliber to > handle... > It should handle it fine, but you are using the old poller, and your pollers are stacking up, it seems some of your hosts take more than 5 minutes to be polled, and a new poller for that host starts. This is a common problem on big installations, thats why we did the new poller (poller2), using it, you will not see any more stacking, and the load will reamain stable. Check the included crontab in docs/examples/unix for usage. > Thanks! > ~Aaron Hope that helps. Javier -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED] I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_ide95&alloc_id396&op=click _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
