Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 799B69FB9FE for ; Wed, 28 Mar 2007 10:09:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48929-04 for ; Wed, 28 Mar 2007 10:09:31 -0300 (ADT) X-Greylist: delayed 00:26:09.322228 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id BAD4D9FBA0E for ; Wed, 28 Mar 2007 10:09:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mercure.sigma.fr (mercure.sigma.fr [195.25.81.9]) by svr4.postgresql.org (Postfix) with ESMTP id 3DE615AF89F for ; Wed, 28 Mar 2007 12:43:20 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mercure.sigma.fr (Postfix) with ESMTP id C31B546B82 for ; Wed, 28 Mar 2007 14:43:14 +0200 (CEST) Received: from mercure.sigma.fr ([127.0.0.1]) by localhost (mercure-1 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05891-113 for ; Wed, 28 Mar 2007 14:43:14 +0200 (CEST) Received: from marc (unknown [192.168.1.1]) by mercure.sigma.fr (Postfix) with ESMTP id A4FF146B80 for ; Wed, 28 Mar 2007 14:43:14 +0200 (CEST) From: Marc Cousin Organization: Sigma Informatique To: pgsql-admin@postgresql.org Subject: SSL broken pipe Date: Wed, 28 Mar 2007 14:43:14 +0200 User-Agent: KMail/1.9.6 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200703281443.14234.mcousin@sigma.fr> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200703/220 X-Sequence-Number: 25044 Hi, I've been having this problem occurring a few times in the last few days : in the postgresql log, I've seen these messages : 2007-03-28 13:53:34.845 CEST,18249 LOG: SSL SYSCALL error: Broken pipe 2007-03-28 13:53:34.846 CEST,18249 LOG: SSL SYSCALL error: Broken pipe 2007-03-28 13:53:34.846 CEST,18249 LOG: SSL SYSCALL error: Broken pipe 2007-03-28 13:53:34.846 CEST,18249 LOG: SSL SYSCALL error: Broken pipe 2007-03-28 13:53:34.847 CEST,18249 LOG: SSL SYSCALL error: Broken pipe 2007-03-28 13:53:34.847 CEST,18249 LOG: SSL SYSCALL error: Broken pipe 2007-03-28 13:53:34.847 CEST,18249 LOG: SSL SYSCALL error: Broken pipe 2007-03-28 13:53:34.848 CEST,18249 LOG: SSL SYSCALL error: Broken pipe 2007-03-28 13:53:34.848 CEST,18249 LOG: SSL SYSCALL error: Broken pipe As you can see, these messages are sent quite fast, and fill the filesystem quite rapidly. The server is postgresql 8.2.3 64 bits on debian unstable The client is pgadmin3 as provided with Postgresql 8.1.7 for Windows. I don't know what the client was doing exactly but I could investigate. Is this a known problem ? It's quite problematic, as it can fill a gigabyte of log file in a minute... Thanks in advance Marc