Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 160149F925E for ; Fri, 9 Nov 2007 18:33:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 64798-07 for ; Fri, 9 Nov 2007 18:33:40 -0400 (AST) Received: from ik-out-1112.google.com (ik-out-1112.google.com [66.249.90.181]) by postgresql.org (Postfix) with ESMTP id 0A4AA9F9627 for ; Fri, 9 Nov 2007 18:33:49 -0400 (AST) Received: by ik-out-1112.google.com with SMTP id c21so484366ika for ; Fri, 09 Nov 2007 14:33:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=kIvtWLIWqgSvOUzE01lnIVGXqSCsrxanKWlLnJ+gSug=; b=H2EdF7y47WHX1M2gmbhvUg4UWCxRvlWmRFd4iRBa0zBEfpiqdMXviLRabERDPg+yjqkB8VrnR9Fnlgi2YTxzn79aFMh3d1RJe6Cb5UlsYou9+n22g82DN7q2o3/IZUuKa3PoZ9XPg/J9b+EuiE71PFJk8CcGhFdxUn/mr674AOg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lV4jcWV54a1YLue7rJZ7BMX/S0po8qSM2aobJtIk/mpjyBnOT0e4t8i1MeNe+gaHHHi+x3MqEr9tWg6sD0kTpDH98zAs7pogzHjCKLsWlpvq6TaxDNdIhI0KoT8mqKgUI09328uMaj3Yz+mDn8FG8WkAJryVauaYoa6+6Liwwy0= Received: by 10.67.106.19 with SMTP id i19mr57924ugm.1194647627101; Fri, 09 Nov 2007 14:33:47 -0800 (PST) Received: by 10.67.95.18 with HTTP; Fri, 9 Nov 2007 14:33:47 -0800 (PST) Message-ID: Date: Fri, 9 Nov 2007 16:33:47 -0600 From: "Scott Marlowe" To: "Alvaro Herrera" Subject: Re: idle in transaction...unexpected EOF on client connection Cc: "Campbell, Lance" , "Tena Sakai" , pgsql-admin@postgresql.org In-Reply-To: <20071109222916.GK7161@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20071109222916.GK7161@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/83 X-Sequence-Number: 27326 On Nov 9, 2007 4:29 PM, Alvaro Herrera wrote: > Campbell, Lance wrote: > > I notice this in my log file as well. I do not have a fire wall that > > would impact this. > > It could be a monitoring tool that's opening the socket to check whether > Postgres is listening. If it connects then closes the socket without > actually talking the PG protocol, this is exactly what you would see. That might explain Lance's problem but not Tena's, since his (hers?) are idle in transaction, which means the connection at least did a begin; after connecting. Also possible for Lance's is an application that isn't properly closing its connections.