Обсуждение: Postgresql 8.0, Tomcat 5.5 postgresql-8.0.309.jdbc3.jar and hiber nate 2.1 on Windows XP - could not receive data from client: No connectio n could be made because the target machine actively refused it

On Mon, 31 Jan 2005, Kolli, Kishore wrote:

>  I am trying to upgrade a web app running postgres7.3, tomcat 4.1 to the
> above environment. I have installed the new postgres 8.0 port and the
> postgresql as a service under user postgres. I can deploy the application to
> tomcat and everything seems to be running ok until I try to open a database
> session. The program gets kicked out with no exceptions. ( I have the open
> session method sandwiched in a try-catch clause and there is also finally
> segment). As soon as I try to open a db session, the program goes to finally
> clause with no exception thrown and when looked into the postgres log, I see
> the following error message
>
> "2005-02-01 00:23:55 LOG:  could not receive data from client: No connection
> could be made because the target machine actively refused it.
> 2005-02-01 00:23:55 LOG:  unexpected EOF on client connection"
>

The server code in question (src/backend/libpq/pqcomm.c) explains why
no error is sent to the client.  Why the error happens in the first
place is beyond me though.

Kris Jurka

r = secure_read(MyProcPort, PqRecvBuffer + PqRecvLength,
                                        PQ_BUFFER_SIZE - PqRecvLength);

if (r < 0)
{
    if (errno == EINTR)
            continue;               /* Ok if interrupted */

        /*
         * Careful: an ereport() that tries to write to the client
         * would cause recursion to here, leading to stack overflow
         * and core dump!  This message must go *only* to the
         * postmaster log.
         */
        ereport(COMMERROR,
                         (errcode_for_socket_access(),
                         errmsg("could not receive data from client: %m")));
        return EOF;
}

I take it this is a windows machine? Is port 5432 blocked on the
firewall either on the machine, or between you and the machine ? Also
make sure tcpip connections are turned on.

Dave

Kolli, Kishore wrote:

> Hi All,
>
>  I am trying to upgrade a web app running postgres7.3, tomcat 4.1 to
> the above environment. I have installed the new postgres 8.0 port and
> the postgresql as a service under user postgres. I can deploy the
> application to tomcat and everything seems to be running ok until I
> try to open a database session. The program gets kicked out with no
> exceptions. ( I have the open session method sandwiched in a try-catch
> clause and there is also finally segment). As soon as I try to open a
> db session, the program goes to finally clause with no exception
> thrown and when looked into the postgres log, I see the following
> error message
>
>
>
> "2005-02-01 00:23:55 LOG:  could not receive data from client: No
> connection could be made because the target machine actively refused it.
>
> 2005-02-01 00:23:55 LOG:  unexpected EOF on client connection"
>
>
>
>
>
> Any help is greatly appreciated.
>
> Regards
>
> **Kishore Kolli**
>
> Siemens Subscriber Networks
>
> Email: Kishore.Kolli@siemens.com <mailto:Kishore.Kolli@siemens.com>
>
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561