Hi
I think the SQL errors are due to you have strict mode enabled.
Regards.
El 13/05/15 a las 07:31, Jeffrey d'Ambly escribió: 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[]]
________________________________ Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente. Evite imprimir este mensaje si no es estrictamente necesario.
This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address. Avoid printing this message if it is not absolutely necessary.