Re: Postmaster not dropping connections on tomcat restart.

More specifically this error is generated when a client doesn't properly
close the connection to the database. In jdbc that means the close
method was never called on the connection object. This most commonly
occurs when a client app simply exits (i.e. the jvm shuts down) without
any finalizers/etc running to properly shutdown. Or this can be caused
by bad code that fails to close a connection in all cases.

--Barry

dinakar wrote:
> can you pls let me know how to check that why the
> client fails...
>
> --- Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>
>>It won't affect performance directly, but I'd like
>>to know why your
>>client is failing.
>>
>>Dave
>>On Wed, 2004-03-24 at 07:25, dinakar wrote:
>>
>>>Hi Dave,
>>>
>>> thanks dave, will this affect the application
>>>performance. ?
>>>
>>>Thanks,
>>>Dinakar
>>>
>>>--- Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>>>
>>>>Dinakar,
>>>>
>>>>This is a result of the client quitting, not the
>>>>backend.
>>>>
>>>>Dave
>>>>On Tue, 2004-03-23 at 23:57, dinakar wrote:
>>>>
>>>>>Hi All,
>>>>>
>>>>>Even i have implement the same for my
>>
>>aplication.
>>
>>>>>sometime i am getting
>>>>>
>>>>>"unexpected EOF on client connection"
>>>>>
>>>>>in the postgres log file.
>>>>>
>>>>>any idea ? pls advise.
>>>>>
>>>>>Thanks,
>>>>>dinakar
>>>>>
>>>>>
>>>>>
>>>>>--- Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> wrote:
>>>>>
>>>>>>On 22/03/2004 20:36 Dave Cramer wrote:
>>>>>>
>>>>>>>Please look a the docs at
>>>>>>>
>>
>>http://doc.postgresintl.com/jdbc/ch11s04.html
>>
>>>>>>>I set his up and tested it, it works!
>>>>>>
>>>>>>Virtually identical to how I do it. Maybe
>>
>>Paul
>>
>>>>and
>>>>
>>>>>>dinakar will take the
>>>>>>hint ;)
>>>>>>
>>>>>>--
>>>>>>Paul Thomas
>>>>>>
>>>>>
> +------------------------------+---------------------------------------------+
>
>>>>>>| Thomas Micro Systems Limited | Software
>>>>
>>>>Solutions
>>>>
>>>>>>for
>>>>>>Business |
>>>>>>| Computer Consultants |
>>>>>>http://www.thomas-micro-systems-ltd.co.uk
>>
>>|
>>
> +------------------------------+---------------------------------------------+
>
>>>>>>---------------------------(end of
>>>>>>broadcast)---------------------------
>>>>>>TIP 3: if posting/reading through Usenet,
>>
>>please
>>
>>>>>>send an appropriate
>>>>>> subscribe-nomail command to
>>>>>>majordomo(at)postgresql(dot)org so that your
>>>>>> message can get through to the mailing
>>>>
>>>>list
>>>>
>>>>>cleanly
>>>>>
>>>>>
>>>>>__________________________________
>>>>>Do you Yahoo!?
>>>>>Yahoo! Finance Tax Center - File online. File
>>
>>on
>>
>>>>time.
>>>>
>>>>>http://taxes.yahoo.com/filing.html
>>>>>
>>>>>---------------------------(end of
>>>>
>>>>broadcast)---------------------------
>>>>
>>>>>TIP 9: the planner will ignore your desire to
>>>>
>>>>choose an index scan if your
>>>>
>>>>> joining column's datatypes do not match
>>>>>
>>>>
>>>>--
>>>>Dave Cramer
>>>>519 939 0336
>>>>ICQ # 14675561
>>>>
>>>
>>>
>>>__________________________________
>>>Do you Yahoo!?
>>>Yahoo! Finance Tax Center - File online. File on
>>
>>time.
>>
>>>http://taxes.yahoo.com/filing.html
>>>
>>
>>--
>>Dave Cramer
>>519 939 0336
>>ICQ # 14675561
>>
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 7: don't forget to increase your free space map
>
> settings
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> http://taxes.yahoo.com/filing.html
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend