I just installed a new obs server using the professional edition. For some reason all my graphs are empty. I think this maybe due to rrdcached, but I have no idea why. Also when I run the poller in debug mode I saw some SQL errors? Is this something I should be concerned about?
Also found this in /var/log/messages
May 12 22:23:17 sjc-corp-net01 rrdcached[2470]: queue_thread_main: rrd_update_r (/opt/observium/rrd/nj-wan01/port-13.rrd) failed with status -1. (/opt/observium/rrd/nj-wan01/port-13.rrd: not a simple signed integer: '1.844674407371E+19')
May 12 22:25:03 sjc-corp-net01 rrdcached[2470]: queue_thread_main: rrd_update_r (/opt/observium/rrd/nj-wan01/port-13.rrd) failed with status -1. (/opt/observium/rrd/nj-wan01/port-13.rrd: not a simple signed integer: '1.844674407371E+19')
May 12 22:30:27 sjc-corp-net01 rrdcached[2470]: queue_thread_main: rrd_update_r (/opt/observium/rrd/nj-wan01/port-13.rrd) failed with status -1. (/opt/observium/rrd/nj-wan01/port-13.rrd: not a simple signed integer: '1.844674407371E+19')
SQL[SELECT * FROM `cef_switching` WHERE `device_id` = '63' AND `entPhysicalIndex = '7051' AND `afi` = 'ipv4' AND `cef_index` = '1']
RUNTIME[0.00008607s]
ERROR[Error in query: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'afi` = 'ipv4' AND `cef_index` = '1'' at line 1]
RRD /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv4-1.rrd already exists - no need to create.
SQL[UPDATE `cef_switching` set `drop` ='0',`punt` ='0',`punt2host` ='0',`drop_prev` ='',`punt_prev` ='',`punt2host_prev` ='',`updated` ='1431494692',`updated_prev` ='' WHERE `device_id` = '63' AND `entPhysicalIndex` = '7051' AND `afi` = 'ipv4' AND `cef_index` = '1']
RUNTIME[0.00063586s]
RRD[cmd[update /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv4-1.rrd N:0:0:0 --daemon unix:/var/rrdtool/rrdcached/rrdcached.sock]
stdout[OK u:0.00 s:0.02 r:56.10]
stderr[]]
| |-2: RP LES
SQL[SELECT * FROM `cef_switching` WHERE `device_id` = '63' AND `entPhysicalIndex = '7051' AND `afi` = 'ipv4' AND `cef_index` = '2']
RUNTIME[0.00007796s]
ERROR[Error in query: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'afi` = 'ipv4' AND `cef_index` = '2'' at line 1]
RRD /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv4-2.rrd already exists - no need to create.
SQL[UPDATE `cef_switching` set `drop` ='0',`punt` ='395367',`punt2host` ='1150',`drop_prev` ='',`punt_prev` ='',`punt2host_prev` ='',`updated` ='1431494692',`updated_prev` ='' WHERE `device_id` = '63' AND `entPhysicalIndex` = '7051' AND `afi` = 'ipv4' AND `cef_index` = '2']
RUNTIME[0.00068498s]
RRD[cmd[update /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv4-2.rrd N:0:395367:1150 --daemon unix:/var/rrdtool/rrdcached/rrdcached.sock]
stdout[OK u:0.00 s:0.02 r:56.11]
stderr[]]
|- ipv6 RRD /opt/observium/rrd/nj-wan01/cef-pfx-7051-ipv6.rrd already exists - no need to create.
SQL[UPDATE `cef_prefix` set `cef_pfx` ='' WHERE `device_id` = '63' AND `entPhysicalIndex` = '7051' AND `afi` = 'ipv6']
RUNTIME[0.00073409s]
RRD[cmd[update /opt/observium/rrd/nj-wan01/cef-pfx-7051-ipv6.rrd N:U --daemon unix:/var/rrdtool/rrdcached/rrdcached.sock]
stdout[OK u:0.00 s:0.02 r:56.11]
stderr[]]
| |-1: RP LES
SQL[SELECT * FROM `cef_switching` WHERE `device_id` = '63' AND `entPhysicalIndex = '7051' AND `afi` = 'ipv6' AND `cef_index` = '1']
RUNTIME[0.00008082s]
ERROR[Error in query: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'afi` = 'ipv6' AND `cef_index` = '1'' at line 1]
RRD /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv6-1.rrd already exists - no need to create.
SQL[UPDATE `cef_switching` set `drop` ='0',`punt` ='0',`punt2host` ='0',`drop_prev` ='',`punt_prev` ='',`punt2host_prev` ='',`updated` ='1431494692',`updated_prev` ='' WHERE `device_id` = '63' AND `entPhysicalIndex` = '7051' AND `afi` = 'ipv6' AND `cef_index` = '1']
RUNTIME[0.00065994s]
RRD[cmd[update /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv6-1.rrd N:0:0:0 --daemon unix:/var/rrdtool/rrdcached/rrdcached.sock]
stdout[OK u:0.00 s:0.02 r:56.11]
stderr[]]