ages during that time?
>
> |-Original Message-
> |From: Dario Brignardello [mailto:[EMAIL PROTECTED]
> |Sent: Mittwoch, 03. August 2005 19:33
> |To: KÖPFERL Robert
> |Cc: pgsql-admin@postgresql.org
> |Subject: Re: [ADMIN] Blocking connection and timeout problem
> |
|From: Dario Brignardello [mailto:[EMAIL PROTECTED]
|Sent: Mittwoch, 03. August 2005 19:33
|To: KÖPFERL Robert
|Cc: pgsql-admin@postgresql.org
|Subject: Re: [ADMIN] Blocking connection and timeout problem
|
|
|Assuming you are on a linux box (Not sure if it's stated in your mail,
|sorry if I
wrote:
>
>
>
> |-Original Message-
> |From: Tom Lane [mailto:[EMAIL PROTECTED]
> |Sent: Mittwoch, 03. August 2005 16:38
> |To: KÖPFERL Robert
> |Cc: pgsql-admin@postgresql.org
> |Subject: Re: [ADMIN] Blocking connection and timeout problem
> |
> |
> |=?iso-8859
wrote:
>
>
>
> |-Original Message-
> |From: Tom Lane [mailto:[EMAIL PROTECTED]
> |Sent: Mittwoch, 03. August 2005 16:38
> |To: KÖPFERL Robert
> |Cc: pgsql-admin@postgresql.org
> |Subject: Re: [ADMIN] Blocking connection and timeout problem
> |
> |
> |=?iso-8859
d that is bad, for a DBA at least).
Regards,
Guido
On 8/3/05, KÖPFERL Robert <[EMAIL PROTECTED]> wrote:
|-Original Message-|From: Tom Lane [mailto:[EMAIL PROTECTED]]|Sent: Mittwoch, 03. August 2005 16:38|To: KÖPFERL Robert|Cc:
pgsql-admin@postgresql.org|Subject: Re: [ADMIN] Blocking
|-Original Message-
|From: Tom Lane [mailto:[EMAIL PROTECTED]
|Sent: Mittwoch, 03. August 2005 16:38
|To: KÖPFERL Robert
|Cc: pgsql-admin@postgresql.org
|Subject: Re: [ADMIN] Blocking connection and timeout problem
|
|
|=?iso-8859-1?Q?K=D6PFERL_Robert?= <[EMAIL PROTECTED]>
=?iso-8859-1?Q?K=D6PFERL_Robert?= <[EMAIL PROTECTED]> writes:
> Why is that? Why isn't client A's transaction detected as dead ?
It will be eventually, when the TCP connection times out. The standard
timeout is generally an hour or two :-(
regards, tom lane
-
Hi,
I managed to reproduce a locking problem, which is about blocking
transactions and dead connections. How can this be avoided?
What I did was:
1. Start a transaction on Client A
2. Execute a fcn doing an UPDATE on a certain record on client A
3. Execute a fcn doing an UPDATE on the same record
