|
From: Andrew M. <an...@mo...> - 2010-01-28 01:08:52
|
On Wed, 2010-01-27 at 22:32 +0100, Matthias Fechner wrote:
>
> And now I get errormessages into the error log from apache:
> [Wed Jan 27 22:20:52 2010] [error] [client 192.168.0.151] rscds: LOG:
> always: Query: SQ: Took: 0.414886 for SELECT schema_major, schema_minor,
'SQ' means 'Slow Query' in this case it's taking 0.4 seconds, which
seems excessively slow for something that should be practically
instantaneous.
You should try and do the following:
Stop postgresql
Start postgresql
connect as the database superuser and issue a:
TRUNCATE session;
VACUUM FULL ANALYZE;
It may be that autovacuum is not properly configured on your system,
which should clean this up on a regular basis otherwise.
> [Wed Jan 27 22:29:47 2010] [error] [client 192.168.0.151] rscds: WARN:
> Login ERR: Other than one session record matches. 2, referer: http://x/
I've never seen this problem before, but the 'truncate session' above
should resolve it.
> oh you are right, could be new, I havn't seen it yet (is version 0.9.7.6).
That's as up-to-date as is reasonable, then :-)
Cheers,
Andrew.
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
So you're back... about time...
------------------------------------------------------------------------
|