Re: [GENERAL] Error: no connection to the server
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
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
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
[GENERAL] Error: no connection to the server
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