Skip site navigation (1) Skip section navigation (2)

Re: BUG #6183: FATAL: canceling authentication due to timeout

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thorvald Natvig" <thorvald(at)medallia(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6183: FATAL: canceling authentication due to timeout
Date: 2011-08-30 00:50:46
Message-ID: 1148.1314665446@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Thorvald Natvig" <thorvald(at)medallia(dot)com> writes:
> We get a lot of "FATAL:  canceling authentication due to timeout" in the
> log, with accompanying closed connections to clients.

Well, the only known cause of that (other than genuine timeout
conditions) is in fact fixed in 9.1rc1.  You have not provided any
information that would permit anyone to look for another cause.

> There does indeed seem to be a correlation between doing vacuum and seeing
> this error.

Are you doing VACUUM FULLs on pg_authid (and if so, why)?  If you are,
is it possible that those are queuing up behind other queries that
access pg_authid, and for some reason aren't releasing their locks
promptly?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Thorvald NatvigDate: 2011-08-30 01:22:51
Subject: Re: BUG #6183: FATAL: canceling authentication due to timeout
Previous:From: Tom LaneDate: 2011-08-30 00:12:19
Subject: Re: BUG #6182: /etc/init.d/postgresql-8.4 is incomplete for chkconfig

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group