[2015/07/08 09:10:20 +0100] poller.php(14826): Failed dbQuery (#1062 - Duplicate entry '49-3071-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('49','3071','2335342468','65536','input')
On 08/07/2015 08:41:37, Nick Ryce <nick@fluency.net.uk> wrote:
Hi,
I have moved on to Observium 0.15.7.6578 and have noticed a strange behaviour on 2 different devices concerning a single interface each. At each poll it says the interface ifAlias has changed but it hasn’t.
Below are the log entries
Any help would be much appreciated.
1m an1.dou-gla ge-1/0/5.0 Interface changed: [ifAlias] Cust: xxx {FL000797} -> Cust: xxx {FL000797} 2m 9s an1.cen-gla ge-1/1/1.120 Interface changed: [ifAlias] Cust: xxx {FL000875} -> Cust: xxx {FL000875} 5m 59s an1.dou-gla ge-1/0/5.0 Interface changed: [ifAlias] Cust: xxx {FL000797} -> Cust: xxx {FL000797} 7m 20s an1.cen-gla ge-1/1/1.120 Interface changed: [ifAlias] Cust: xxx {FL000875} -> Cust: xxx {FL000875} 12m 20s an1.cen-gla ge-1/1/1.120 Interface changed: [ifAlias] Cust: xxx {FL000875} -> Cust: xxx {FL000875} 12m 47s an1.dou-gla ge-1/0/5.0 Interface changed: [ifAlias] Cust: xxx {FL000797} -> Cust: xxx {FL000797} 17m 13s an1.cen-gla ge-1/1/1.120 Interface changed: [ifAlias] Cust: xxx {FL000875} -> Cust: xxx {FL000875} 17m 17s an1.dou-gla ge-1/0/5.0 Interface changed: [ifAlias] Cust: xxx {FL000797} -> Cust: xxx {FL000797} 21m 41s an1.dou-gla ge-1/0/5.0 Interface changed: [ifAlias] Cust: xxx {FL000797} -> Cust: xxx {FL000797} 22m 20s an1.cen-gla ge-1/1/1.120 Interface changed: [ifAlias] Cust: xxx {FL000875} -> Cust: xxx {FL000875} 26m 18s an1.dou-gla ge-1/0/5.0 Interface changed: [ifAlias] Cust: xxx {FL000797} -> Cust: xxx {FL000797} 27m 19s an1.cen-gla ge-1/1/1.120 Interface changed: [ifAlias] Cust: xxx {FL000875} -> Cust: xxx {FL000875} 31m an1.dou-gla ge-1/0/5.0 Interface changed: [ifAlias] Cust: xxx {FL000797} -> Cust: xxx {FL000797} 32m 12s an1.cen-gla ge-1/1/1.120 Interface changed: [ifAlias] Cust: xxx {FL000875} -> Cust: xxx {FL000875}
Nick