Re: Postmaster not dropping connections on tomcat restart.

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: dinakar <din_akar(at)yahoo(dot)com>
Cc: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>, "pgsql-jdbc (at) postgresql " "(dot) org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Postmaster not dropping connections on tomcat restart.
Date: 2004-03-24 14:12:25
Message-ID: 1080137545.1801.64.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dinakar

I would turn logging on, and log pids to see which pid is failing and
what it did just before it fails.

Dave

On Wed, 2004-03-24 at 08:58, 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
>
--
Dave Cramer
519 939 0336
ICQ # 14675561

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2004-03-24 16:06:07 Re: Postmaster not dropping connections on tomcat restart.
Previous Message dinakar 2004-03-24 13:58:33 Re: Postmaster not dropping connections on tomcat restart.