On 2015-03-24 16:05, Morten Brekkevold wrote:
Did this only occur after upgrading to 4.2.5? Does it go on like this "forever", or does it calm down a while after starting ipdevpoll?
It started with 4.2.4. I have Munin-graphs of all servers and the postgres server have a load going from 2 to 60 after upgrading to 4.2.4, the server running NAV has a load decrease from 2-3 to less than 1. This goes on forever.
I would connect to PostgreSQL and issue a "ALTER DATABASE nav SET log_min_duration_statement TO 1500;", then restart NAV.
Just did, the main thing looks like
2015-03-24 23:05:58 CET LOG: duration: 130238.622 ms statement: INSERT INTO "ipdevpoll_job_log" ("netboxid", "job_name", "end_time", "duration", "success", "interval") VALUES (1187, 'dns', '2015-03-24 23:03:48.719354', 1285.223631, true, 3600) RETURNING "ipdevpoll_job_log"."id"
about 1800 lines with 'INSERT INTO "ipdevpoll_job_log"' in 45 minutes.
but there are other statements as well.
Normally I would suspect something like a faulty raid cache battery or drive failure for this kind of symptoms, but everything has been checked out.
Any ideas appreciated!
Cheers,
-Sigurd