Hi :-)
On Thu, 08 Dec 2011 10:57:58 +0100, Morten Brekkevold morten.brekkevold@uninett.no wrote:
"DELETE FROM rrd_file WHERE netboxid IS NULL" should never take 7 hours. I'm guessing something was holding on to a database lock that the statement needed to wait for.
Does a "ps axuw" listing show many postgres processes with the status "idle in transaction"?
I tried restarting postgres just before issuing the command, so it shouldn't be any at the time.
For the last 30 minutes its been stable at 7. I noticed before upgrading I had up to max_connections and pping crashed when max_connections was reached. This behavior is gone now.
After adjusting the timeout value I can delete devices, but still get
errors
when adding devices - however bulk import seems to work.
What kind of errors?
Webpage says: "Something went wrong
Something went wrong while processing your request. Please try again later.
If the problems persists, contact your system administrator and/or report a bug on NAV bugtracker."
Apache access log: nav.vegvesen.no:80 146.2.x.y - - [08/Dec/2011:16:56:39 +0100] "POST /seeddb/netbox/add/ HTTP/1.1" 200 2011 "http://nav.vegvesen.no/seeddb/netbox/add/" "Mozilla/5.0 (Ubuntu; X11; Linux x86_64; rv:8.0) Gecko/20100101 Firefox/8.0" nav.vegvesen.no:80 146.2.x.y - - [08/Dec/2011:16:56:41 +0100] "POST /seeddb/netbox/add/ HTTP/1.1" 500 472 "http://nav.vegvesen.no/seeddb/netbox/add/" "Mozilla/5.0 (Ubuntu; X11; Linux x86_64; rv:8.0) Gecko/20100101 Firefox/8.0"
Error log: /usr/lib/python2.6/dist-packages/mod_python/importer.py:32: DeprecationWarning: the md5 module is deprecated; use hashlib instead import md5 (I guess not related)
Any other logs relevant?
Cheers,
-Sigurd