We’ve been running for over a year without issue. This came up within the last month or so from what we can tell. No mysql server changes, only Observium csv
updates.
From: observium [mailto:observium-bounces@observium.org]
On Behalf Of Adam Armstrong
Sent: Friday, February 12, 2016 4:30 PM
To: Observium Network Observation System <observium@observium.org>
Subject: Re: [Observium] All ports at each polling showing "interface changed:" event log
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:
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
