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

Поиск
Список
Период
Сортировка
От Pawan Sharma
Тема Re: Connect is not available, request timeout after 30000ms.
Дата
Msg-id CAKqG8NXXK3Mu-b4+GkjQ_uYyrPAaLGPktL7o5yH+GBxSH_8PMA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Connect is not available, request timeout after 30000ms.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Connect is not available, request timeout after 30000ms.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
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.klaver@aklaver.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.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Connect is not available, request timeout after 30000ms.
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Connect is not available, request timeout after 30000ms.