Re: Connect is not available, request timeout after 30000ms.

In PostgreSQL logs it's showing select queries are running with duration
approx 37001.347ms

On Tue, Jun 25, 2019, 7:44 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 6/25/19 7:06 AM, Pawan Sharma wrote:
> > Can the app connect at all?
> > - yes connection between database and app B is successfully established.
> > What is the app doing when it gets the error?
> > - from the app B we trying to delete some records in database.
> > Where is the error message appearing?
> > - messages are appearing in app server log.
>
> What shows up in the Postgres log at around the same time?
>
> > Are there other error messages before or after the above?
> > -no there, nothing and after.
> >
> > On Tue, Jun 25, 2019 at 7:25 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> > <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
> >
> > On 6/25/19 6:49 AM, Pawan Sharma wrote:
> > > Hi All,
> > >
> > >
> > > I have upgarded my PostgreSQL database from 10 to 11 version using
> > > pg_dump method.
> > >
> > > That database is used by two apps.
> > >
> > > 1. A (most of the transaction are SELECT AND INSERT)
> > > 2. B ( most of the transaction UPDATE AND DELETE)
> > >
> > > After the upgarde I am facing *error:connection is not available,
> > > request timeout after 3000ms* with app B whereas app A is working
> > fine
> > > with same database..
> >
> > Can the app connect at all?
> >
> > What is the app doing when it gets the error?
> >
> > Where is the error message appearing?
> >
> > Are there other error messages befor eor afterthe above?
> >
> > >
> > > I have upgarded my JDBC driver with lastest driver to fix this
> > issue but
> > > no luck.
> > >
> > >
> > > Thanks for advance help.
> > >
> > >
> > > Regards,
> > > Pawan
> > >
> >
> >
> > --
> > Adrian Klaver
> > adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>