Re: [GENERAL] Error: no connection to the server

2016-04-25 Thread Melvin Davidson 
On Mon, Apr 25, 2016 at 7:32 PM, Sameer Kumar 
wrote:

>
>
> On Mon, 25 Apr 2016 15:59 Marco Bambini,  wrote:
>
>> Hi,
>> I have a multithreaded C client and sometimes I receive the "no
>> connection to the server" error message.
>>
>
> Please add more details of the
>
> - version of Postgres.
> - Platform and OS details
>
> Are you using any Middleware like pgpool or pgbouncer?
>
> I haven't found any documentation about it and about how to fix this issue.
>>
>> Anyone can point me to the right direction?
>> How can I fix it?
>>
>> Thanks a lot.
>> --
>> Marco Bambini
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
> --
> --
> Best Regards
> Sameer Kumar | DB Solution Architect
> *ASHNIK PTE. LTD.*
>
> 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
>
> T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
>

Have you tried looking in the Postgres log for additional information?

-- 
*Melvin Davidson*
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

Re: [GENERAL] Error: no connection to the server

2016-04-25 Thread Sameer Kumar 
On Mon, 25 Apr 2016 15:59 Marco Bambini,  wrote:

> Hi,
> I have a multithreaded C client and sometimes I receive the "no connection
> to the server" error message.
>

Please add more details of the

- version of Postgres.
- Platform and OS details

Are you using any Middleware like pgpool or pgbouncer?

I haven't found any documentation about it and about how to fix this issue.
>
> Anyone can point me to the right direction?
> How can I fix it?
>
> Thanks a lot.
> --
> Marco Bambini
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
-- 
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533

T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com

Re: [GENERAL] Error: no connection to the server

2016-04-25 Thread Albe Laurenz 
Marco Bambini wrote:
> I have a multithreaded C client and sometimes I receive the "no connection to 
> the server" error
> message.
> I haven't found any documentation about it and about how to fix this issue.
> 
> Anyone can point me to the right direction?

The error message is reported in interfaces/libpq/fe-exec.c:

static bool
PQsendQueryStart(PGconn *conn)
{
if (!conn)
return false;

/* clear the error string */
resetPQExpBuffer(>errorMessage);

/* Don't try to send if we know there's no live connection. */
if (conn->status != CONNECTION_OK)
{
printfPQExpBuffer(>errorMessage,
  libpq_gettext("no connection to the server\n"));
return false;
}

So it looks like you closed the connection (maybe in some other thread)
and then try to reuse it.

Yours,
Laurenz Albe

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Error: no connection to the server

2016-04-25 Thread Marco Bambini 
Hi,
I have a multithreaded C client and sometimes I receive the "no connection to 
the server" error message.
I haven't found any documentation about it and about how to fix this issue.

Anyone can point me to the right direction?
How can I fix it?

Thanks a lot.
--
Marco Bambini

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general