From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: psql hanging |
Date: | 2007-09-05 16:26:39 |
Message-ID: | 46DED8BF.2060502@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Richard Huxton wrote:
> Steve Crawford wrote:
>> What would cause psql to hang indefinitely when the backend disappears?
>>
>> We have a script that uses psql to insert a record (TCP connection to DB
>> on different machine). The command is basically
>> psql <connection_stuff> -c "insert into..."
>>
>> A while back I had to restart the server and today discovered that some
>> of the client machines have psql processes dating back several months.
>>
>> Obviously no TCP connection on the server end but client-side shows the
>> connection as "ESTABLISHED".
>
> The OS should clear that connection down after a timeout - hours
> perhaps, but months doesn't sound right. When the connection gets closed
> down psql should exit.
>
> What OS is this? Someone here should be able to figure out what's going on.
>
RedHat 7.3 w/kernel update to 2.4.18-5 (grrrr - specific requirement to
support hardware/drivers we have).
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Owen Hartnett | 2007-09-05 16:41:15 | Re: problem with transactions in VB.NET using npgsql |
Previous Message | Tom Lane | 2007-09-05 15:52:01 | Re: problem with transactions in VB.NET using npgsql |