Re: CLOSE_WAIT when database is offline
Re: CLOSE_WAIT when database is offline
- Subject: Re: CLOSE_WAIT when database is offline
- From: Alexander Spohr <email@hidden>
- Date: Mon, 17 Oct 2011 16:51:39 +0200
Am 17.10.2011 um 16:19 schrieb Philippe Rabier:
> Alexander, do you open a database connection each time the web app receives an incoming request?
No. But the app tries to reconnect when the database goes down.
atze
>
> Philippe
>
> Sent from my iPhone
>
> On 17 oct. 2011, at 14:54, Alexander Spohr <email@hidden> wrote:
>
>> Hi list,
>>
>> we have a rather busy WO-service. Sometimes one of our multiple database servers fails and CLOSE_WAIT shows its ugly head and kills the performance.
>>
>> What I think the problem is:
>> - WebServer asks AppServer for data
>> - AppServer tries to connect to db
>> - more requests come in
>> - AppServer tries to connect to db
>> - more requests come in
>> - AppServer tries to connect to db
>> - more requests come in
>> ...
>> Then after a while the WebServers close their side of the connection but the app connection threads still wait in queue for the database. So the app never acknowledges the close and we slowly die.
>>
>> Is this what happens?
>> Can we do something against it?
>> A delegate method perhaps, to throw an error if we can not connect to the db? (And of course retrying later to reconnect - after all the database will come online again)
>>
>> Any pointers are welcome,
>>
>> atze
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden