err… svn updates.
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Matt Ladewig Sent: Friday, February 12, 2016 5:19 PM To: Observium Network Observation System observium@observium.org Subject: Re: [Observium] All ports at each polling showing "interface changed:" event log
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.orgmailto: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 BlueMailhttp://www.bluemail.me/r On Feb 12, 2016, at 22:40, Matt Ladewig <matt@univoip.commailto: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.orgmailto: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/u...
Here is the port poller from one device showing this issue: https://s3.amazonaws.com/uploads.hipchat.com/131939/956300/4ADJVr2DdsmjgXT/l...
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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium