Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-2467

After upgrade to CE v17.9.0 Graphs are empty NaN dump rrdtool

Details

    • Bug
    • Resolution: Not A Bug
    • Minor
    • None
    • Community Edition, Professional Edition
    • Web Interface

    Description

      Hello all,

      After upgrade to CE v17.9.0 the graphs of devices are empty and the rrdtool dump shows NaN for the rrd file.

      The only graphs that are displaying information are the Polling Information graphs.

      In the db.log I can see a lot of "Failed dbQuery (#2006 - MySQL server has gone away)"

      poller.php(30612): Failed dbQuery (#2006 - MySQL server has gone away), Query: INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('poll','167','1508165401.9348','16.12','1').

      The rrd directory and subdirectory have the right permission/ownership:

      drwxrwxrwx 376 www-data www-data  20K Oct 16 13:44 rrd

      The config file has no white spaces.

      We had done upgrades before, and they had been flawless perfectly.

      Any suggestions or clues to point at, it will be appreciated.

      Thanks.

      Attachments

        Activity

          [OBS-2467] After upgrade to CE v17.9.0 Graphs are empty NaN dump rrdtool
          emiliomejias Emilio MEJIAS added a comment - - edited

          Hello, update info:

          After reading the debug info from the poller, it was not able to connect to the rrdcached socket. Investigating, when we made the upgrade version of Observium we also upgraded from debian 8 to debian 9, thus, the new config file of rrdcached (/etc/default/rrdcached) has been changed.

          Now the problem is solved.

          Greetings.

          emiliomejias Emilio MEJIAS added a comment - - edited Hello, update info: After reading the debug info from the poller, it was not able to connect to the rrdcached socket. Investigating, when we made the upgrade version of Observium we also upgraded from debian 8 to debian 9, thus, the new config file of rrdcached (/etc/default/rrdcached) has been changed. Now the problem is solved. Greetings.
          adama Adam Armstrong added a comment -

          Hi Emilio,

          Can you give me SSH/HTTP access to the Observium server?

          adama@observium.org

          adama Adam Armstrong added a comment - Hi Emilio, Can you give me SSH/HTTP access to the Observium server? adama@observium.org
          emiliomejias Emilio MEJIAS added a comment -

          Update info,

          We have moved to a Professional Version (http://docs.observium.org/updating/#migrate-an-existing-community-edition-installation-to-the-subscription-edition):

          Observium 17.10.8889 (11th October 2017)
          OS Linux 4.9.0-4-amd64 [amd64] (Debian 9)
          Apache 2.4.25 (Debian)
          PHP 7.0.19-1 (OPcache: ENABLED)
          Python 2.7.13
          MySQL 10.1.26-MariaDB-0+deb9u1 (extension: mysqli 5.0.12-dev)
          SNMP NET-SNMP 5.7.3
          RRDtool 1.6.0 (rrdcached 1.6.0: unix:/var/run/rrdcached.sock)

           

          And we have the same symptom for the graph, and NaN for rrd of devices.

           

          emiliomejias Emilio MEJIAS added a comment - Update info, We have moved to a Professional Version ( http://docs.observium.org/updating/#migrate-an-existing-community-edition-installation-to-the-subscription-edition): Observium 17.10.8889 (11th October 2017) OS Linux 4.9.0-4-amd64 [amd64] (Debian 9) Apache 2.4.25 (Debian) PHP 7.0.19-1 (OPcache: ENABLED) Python 2.7.13 MySQL 10.1.26-MariaDB-0+deb9u1 (extension: mysqli 5.0.12-dev) SNMP NET-SNMP 5.7.3 RRDtool 1.6.0 (rrdcached 1.6.0: unix:/var/run/rrdcached.sock)   And we have the same symptom for the graph, and NaN for rrd of devices.  

          People

            adama Adam Armstrong
            emiliomejias Emilio MEJIAS
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: