Re: [DAViCal-general] Upgrade davical on FreeBSD

[Andrew M. <an...@mo...>]

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...
------------------------------------------------------------------------