This is likely because your mysql server has been set to strict mode.

Foolishly this is now the default for some distros, despite a lot of stuff still not being quite ready for it!

Adam.

Sent from BlueMail

On Feb 12, 2016, at 22:40, Matt Ladewig <matt@univoip.com> wrote:

This is also causing other issues. Port name and admin/physical status updates during polling is not working.

 

Please assist.


Matt

 

 

 

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Matt Ladewig
Sent: Friday, February 12, 2016 9:13 AM
To: Observium Network Observation System <observium@observium.org>
Subject: [Observium] All ports at each polling showing "interface changed:" event log

 

We are at 7608.

 

During each polling run, every port on our system shows an interface changed event log:

https://s3.amazonaws.com/uploads.hipchat.com/131939/956300/RLSqGEGgF09oIZS/upload.png

 

Here is the port poller from one device showing this issue:

https://s3.amazonaws.com/uploads.hipchat.com/131939/956300/4ADJVr2DdsmjgXT/lax-i-edg-99_poller_021216.txt

 

This error stands out:

SQL[UPDATE `ports` set `port_label_base` ='Null',`port_label_num` ='0',`ifLastChange` ='2015-05-19 05:42:34' WHERE `port_id` = '3872']

SQL RUNTIME[0.00006795s]

ERROR[Error in query: (Unknown column 'port_label_base' in 'field list') 1054]

PORT updated rows=

 

Looks like I’m missing some structure from my DB. Please let me know what is needed to sort this out.

Thanks,


Matt

 

 

 

 

 

observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium