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 < 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 http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
