On Thu, 14 Mar 2013 15:24:45 +0400 Aln Kapa <alnkapa@gmail.com> wrote:
>
> I connect to the database using the PGDAC, and then send a NOTIFY to
> myself every minute. In this case, the logs get that.
>
> 2013-03-10 10:34:36 19797 LOG: process 19797 still waiting for
> AccessExclusiveLock on object 0 of class 1262 of database 0 after
> 3000.100 ms
> 2013-03-10 10:34:36 19797 STATEMENT: NOTIFY test105, ''
> 2013-03-10 10:34:37 19797 LOG: process 19797 acquired
> AccessExclusiveLock on object 0 of class 1262 of database 0 after
> 3315.206 ms
> 2013-03-10 10:34:37 19797 STATEMENT: NOTIFY test105, ''
> 2013-03-10 10:34:37 19797 LOG: duration: 3315.322 ms statement:
> NOTIFY test105, ''
> 2013-03-10 14:27:43 19797 LOG: could not receive data from client:
> Connection reset by peer
> 2013-03-10 14:27:43 19797 LOG: unexpected EOF on client connection
>
> Tell me what's the problem?
Are the last two lines your perceived problem? Is the NOTIFY working?
There's really not enough information here to actually understand
what you're asking. Based on the log information, it looks like
a client program issues a notify, then drops the connection. Could
be because in intervening network control device times out the TCP
state, or could be because the client drops the conneciton, or
because the client crashed, or is poorly implementd in that it looses
its TCP socket.
In any event, the 4 hour lag between the NOTIFY and the conneciton drop
during which nothing happens seems to indicate that the two events
are probably not related.
Is any of that helpful? I feel like I don't understand your question
and suspect that you didn't receive an answer to your first post
because most people didn't understand it. If my comments don't
address your question, perhaps try describing it differently.
--
Bill Moran <wmoran@potentialtech.com>