Should i make the max heap say 1gb instead?
That to me seems abit extreme!?
Any idea why the memory gets full so quickly
I'm only polling 40 devices
Simon
Sent from my iPhone
On 10 Aug 2015, at 16:51, Adam Armstrong adama@memetic.org wrote:
Sounds like your memory tables are full again :)
On 10/08/2015 16:50:32, Simon Smith simonsmith5521@gmail.com wrote:
Well some good news,
it has started playing good to me again? i have no idea why!?
the alerts now only shows 1 alert and the sensors have all re-appeared for each machine ?
don’t no what on earth it was as i didn’t change any config, DB or anything apart from upgrade and downgrade the php,mysql and apache
i will keep a close eye on it over the coming hours :)
however I’m still seeing these tho,
PoE Certain MEMORY DB error for table 'ports-state'. Certain MEMORY DB error for table 'ports-state’.
Regards
Simon
On 10 Aug 2015, at 4:28 pm, Adam Armstrong adama@memetic.org wrote:
It's possible that if your memory tables were full, a recent change might not have applied.
You can manually apply update/224.sql if this is the case :)
adam.
On 10/08/2015 15:51:51, Simon Smith simonsmith5521@gmail.com wrote:
Hi,
rebooted mysql, that fixed a few issues but not the sensors still :(
I have also noticed a lot of these when i run the discovery and poller myself
PoE Certain MEMORY DB error for table 'ports-state'. Certain MEMORY DB error for table 'ports-state’.
I have already increased my max_heap_table_size to 512mb but still showing ?
also attached is screenshots of the sensors page all strange and the alerts being incorrect,
i have a feeling ive goofed up the monitoring! and gunna have to start a fresh :(
regards
Simon
On 10 Aug 2015, at 3:12 pm, Mike Stupalov mike@observium.org wrote:
On 10.08.15 17:09, Simon Smith wrote:
sods law, just changed my server to use PHP 5.4 (PAIN TO DO as using ubuntu 12.04) and the code gets updated
I have just noticed however all my sensors for my servers have vanished and every 5 mins I’m getting event alerts saying the sensors are below 0 ?
also when i view fanspeeds, temperature or voltage page, the last changed says 45y 232d ago and Value NaN ?
any ideas?
That after reboot mysql, because sensors/status use in-memory tables which reset on reboot/restart.
Simon
> On 10 Aug 2015, at 2:57 pm, Mike Stupalov mike@observium.org wrote: > >> On 10.08.15 16:36, Louis Bailleul wrote: >> What do you think of the workaround proposed by Gerwin Krist ? >> >> in ./includes/rrdtool.inc.php >> - function rrdtool_pipe_close(&$rrd_process, &$rrd_pipes)* >> + function rrdtool_pipe_close($rrd_process, &$rrd_pipes)* >> >> It doesn't look like PHP devs have and will be looking into this bug, so might as well have a workaround ready on this side. > Not sure that this really can help, but it doesn't create new problems, therefore try in r6868 :) >> >> Best regards, >> Louis >> >> >> August 10 2015 2:27 PM, "Adam Armstrong" adama@memetic.org wrote: >> Indeed, it seems that downgrading PHP would be a good idea. >> The version in Ubuntu 14.04, 5.5.9 seems unaffected. >> adam. >> >>> >>> On 10/08/2015 14:09:29, Laurent Dumont admin@coldnorthadmin.com wrote: >>> >>> I remember seeing the issue mentioned by someone a few months back. Could it be this? >>> >>> http://observium.observium.narkive.com/Kl9IZ3MD/tons-of-rrd-zombie-processes... >>> >>> https://bugs.php.net/bug.php?id=69014 >>> >>> On 8/10/2015 9:04 AM, Simon Smith wrote: >>>> Hi Mike, >>>> updated to 5.6, made a difference for about 10mins, 2 runs, then started again? >>>> i managed to catch them showing with ‘ps aux’ - http://pastebin.com/6uyJUUT1 >>>> www-data 15353 0.0 0.0 0 0 ? Z 13:56 0:00 [sh] <defunct> >>>> www-data 15393 0.0 0.0 0 0 ? Z 13:56 0:00 [sh] <defunct> >>>> www-data 15399 0.0 0.0 0 0 ? Z 13:56 0:00 [sh] <defunct> >>>> Regards >>>> Simon >>>>> On 10 Aug 2015, at 1:11 pm, Mike Stupalov mike@observium.org wrote: >>>>> >>>>> On 10.08.15 15:05, Simon Smith wrote: >>>>>> sorry should of been first thing to attach >>>>>> root@observium:/opt/observium# ./discovery.php -VV >>>>>> Observium 0.15.8.6861 >>>>>> Software versions: >>>>>> OS: Linux 2.6.32-40-pve [amd64] (Ubuntu 12.04) >>>>>> Apache: 2.4.12 >>>>>> PHP: 5.6.11-1+deb.sury.org~precise+1 >>>>>> Python: Python 2.7.3 >>>>>> MySQL: 5.5.44-0ubuntu0.12.04.1 (extension: mysqli 5.6.24) >>>>> I think you should also upgrade mysql to 5.6 from same repo: >>>>> https://launchpad.net/~ondrej/+archive/ubuntu/mysql-5.6 >>>>> >>>>>> >>>>>> SNMP: NET-SNMP 5.4.3 >>>>>> RRDtool: 1.4.9 >>>>>> Charset info: >>>>>> PHP: UTF-8 >>>>>> MySQL: utf8 >>>>>> Timezones info: >>>>>> Date: Monday, 10-Aug-15 13:04:53 BST >>>>>> PHP: +01:00 >>>>>> MySQL: +01:00 >>>>>>> On 10 Aug 2015, at 12:36 pm, Mike Stupalov mike@observium.org wrote: >>>>>>> >>>>>>> >>>>>>> show: >>>>>>> ./discovery.php -VV >>>>>>> >>>>>>>> On 10.08.15 13:59, Simon Smith wrote: >>>>>>>> Hi All, >>>>>>>> i did an update this morning to latest SVN and working fine (thumbs up) >>>>>>>> I then disabled the cron job to update PHP, MySQL and Apache as I’m still using 5.3, 5.2 and 2.2 (updated to 5.6, 5.5 and 2.4) >>>>>>>> now the apache has just completely gone tits up !? >>>>>>>> I’m seeing about 50 of ' [sh] <defunct> ' in my ‘ ps aux ‘ >>>>>>>> erm, where do i begin to start looking? >>>>>>>> i updated using https://launchpad.net/~ondrej/+archive/ubuntu/php5-5.6 as I’m running ubuntu 12.04 lts >>>>>>>> regards >>>>>>>> Simon >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> observium mailing list >>>>>>>> observium@observium.org >>>>>>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>>>>>> >>>>>>> -- >>>>>>> Mike Stupalov >>>>>>> http://observium.org >>>>>>> _______________________________________________ >>>>>>> observium mailing list >>>>>>> observium@observium.org >>>>>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>>>>> >>>>>> _______________________________________________ >>>>>> observium mailing list >>>>>> observium@observium.org >>>>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>>>> >>>>> -- >>>>> Mike Stupalov >>>>> http://observium.org >>>>> _______________________________________________ >>>>> observium mailing list >>>>> observium@observium.org >>>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>>> >>>> _______________________________________________ >>>> observium mailing list >>>> observium@observium.org >>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> >> >> _______________________________________________ >> observium mailing list >> observium@observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > > -- > Mike Stupalov > http://observium.org > _______________________________________________ > observium mailing list > observium@observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalov http://observium.org _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium