On Thu, 19 Mar 2015 18:25:43 +0100 Sigurd Mytting sigurd@mytting.no wrote:
2015-03-19 18:17:40 CET STATEMENT: INSERT INTO eventq (eventqid, subid, netboxid, deviceid, eventtypeid, state, value, source, target) VALUES (104811, NULL, 530, 2269, 'boxState', s', 1, 'pping', 'eventEngine') 2015-03-19 18:17:40 CET ERROR: insert or update on table "eventqvar" violates foreign key constraint "eventqvar_eventqid_fkey" 2015-03-19 18:17:40 CET DETAIL: Key (eventqid)=(104811) is not present in table "eventq". 2015-03-19 18:17:40 CET STATEMENT: INSERT INTO eventqvar (eventqid, var, val) VALUES (104811, 'descr', '')
I tried /usr/lib/nav/navsyncdb, but "No outstanding schema changes."...
Any ideas?
Yes, my initial reaction is that the 4.2.4 release is b0rked, and should not be used until we make a new release. I have removed the download from Launchpad.
The fix for https://bugs.launchpad.net/nav/+bug/1403365 seems to have caused this regression. I see now that fixing this in code instead of in the db schema would have been less invasive.
We will have a fix and a new release by the end of the workday today.
Apologies for the inconvenience!