Error: no connection to the server

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(&conn->errorMessage);

/* Don't try to send if we know there's no live connection. */
if (conn->status != CONNECTION_OK)
{
printfPQExpBuffer(&conn->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

On Mon, 25 Apr 2016 15:59 Marco Bambini, <marco@sqlabs.com> 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

On Mon, Apr 25, 2016 at 7:32 PM, Sameer Kumar <sameer.kumar@ashnik.com>
wrote:

On Mon, 25 Apr 2016 15:59 Marco Bambini, <marco@sqlabs.com> 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.