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-solution

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