pping is unable to post boxUp/boxDown events
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Network Administration Visualized |
Fix Released
|
Critical
|
Morten Brekkevold |
Bug Description
It appears the fix for bug 1403365 has caused a regression that stops the pping from being able to post events, essentially breaking one of the most important features of NAV.
Unfortunately, this made it into the 4.2.4 release, which we have now retracted.
These symptomatic errors can be seen in pping.log:
[2015-03-20 11:47:52] db.py:execute:167 [Critical] Throwing away update...
[2015-03-20 11:47:52] db.py:execute:165 [Critical] insert or update on table "eventqvar" violates foreign key constraint "eventqvar_
DETAIL: Key (eventqid)
[2015-03-20 11:47:52] db.py:execute:167 [Critical] Throwing away update...
[2015-03-20 11:47:52] db.py:execute:165 [Critical] null value in column "subid" violates not-null constraint
There may be more components than pping that post events with explicit subid=NULL values, so the best option for a quick fix may be to add a database trigger that translates NULL values in the subid field to empty strings.