X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 678C19DCA2F for ; Thu, 23 Mar 2006 13:01:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75191-02 for ; Thu, 23 Mar 2006 13:01:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from astro.systems.pipex.net (astro.systems.pipex.net [62.241.163.6]) by postgresql.org (Postfix) with ESMTP id 433319DCA2D for ; Thu, 23 Mar 2006 13:01:16 -0400 (AST) Received: from flange.edesix.com (81-86-64-236.dsl.pipex.com [81.86.64.236]) by astro.systems.pipex.net (Postfix) with ESMTP id C6012E000135; Thu, 23 Mar 2006 17:01:13 +0000 (GMT) Received: from visitor4.edesix.com ([192.168.1.154]) by flange.edesix.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.50) id 1FMTBQ-0003mN-Us; Thu, 23 Mar 2006 17:01:12 +0000 Message-ID: <4422D458.9080204@edesix.com> Date: Thu, 23 Mar 2006 17:01:12 +0000 From: Robin Iddon User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Koen Martens CC: pgsql-admin@postgresql.org Subject: Re: Random disconnects References: <4422B86C.5000703@metro.cx> In-Reply-To: <4422B86C.5000703@metro.cx> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.143 required=5 tests=[AWL=0.143] X-Spam-Score: 0.143 X-Spam-Level: X-Archive-Number: 200603/218 X-Sequence-Number: 20975 >In java, this big fat exception: > >org.postgresql.util.PSQLException: An I/O error occured while >sending to the backend. >Call stack: >org.postgresql.util.PSQLException: An I/O error occured while >sending to the backend. > at >org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214) > at > > > at websphinx.Worm.run(Crawler.java:1994) >Caused by: java.net.SocketException: Network is unreachable > > >org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:187) > ... 9 more > > > >But I think there might be some underlying problem and if so, i'd >like to know about it and fix it. > > It seems to me that the JVM is having problems writing to the socket that connects to the postgres server with the "Network is unreachable" error being the cause. What's the connectivity from your clients to your database - localhost, same LAN, routed LANs, WAN, ...? Even though the perl script says "This probably means the server terminated abnormally before or while processing the request", I doubt that's what happened - more likely is you lost the network between them (but not if you were running on localhost, probably!). Cheers, Robin