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.org]mike@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.org]adama@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...]
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/6uyJUUT1%5Dhttp://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.org]mike@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/%5D~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.org]mike@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.6%5Dhttps://launchpad... [https://launchpad.net/~ondrej/+archive/ubuntu/php5-5.6%5D%C2%A0as 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.org]observium@observium.org [mailto:observium@observium.org] [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium%5Dhttp://postm... [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