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 mailto: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 < mailto:mike@observium.orgmike@observium.org mailto: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" < mailto:adama@memetic.orgadama@memetic.org mailto: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 mailto: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... http://observium.observium.narkive.com/Kl9IZ3MD/tons-of-rrd-zombie-processes-solution > > https://bugs.php.net/bug.php?id=69014 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/6uyJUUT1http://pastebin.com/6uyJUUT1 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 < mailto:mike@observium.orgmike@observium.org mailto: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 http://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 https://launchpad.net/%7Eondrej/+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 < mailto:mike@observium.orgmike@observium.org mailto: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/%7Eondrej/+archive/ubuntu/php5-5.6https://launchpad.net/~ondrej/+archive/ubuntu/php5-5.6 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 mailto:observium@observium.org >>>>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>>>> >>>>> -- >>>>> Mike Stupalov >>>>> http://observium.org http://observium.org/_______________________________________________ >>>>> observium mailing list >>>>> mailto:observium@observium.orgobservium@observium.org mailto:observium@observium.org >>>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>>> _______________________________________________ >>>> observium mailing list >>>> observium@observium.org mailto:observium@observium.org >>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> >>> -- >>> Mike Stupalov >>> http://observium.org http://observium.org/_______________________________________________ >>> observium mailing list >>> observium@observium.org mailto:observium@observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium@observium.org mailto:observium@observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalov http://observium.org http://observium.org/_______________________________________________ observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalov http://observium.org http://observium.org/_______________________________________________ observium mailing list observium@observium.org mailto: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