Message-ID: <43F2F6E2.1020004@archonet.com>
Date: Wed, 15 Feb 2006 09:39:46 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 1.5 (X11/20051201)
MIME-Version: 1.0
To: Pradeep Parmar <pradeep.dba@gmail.com>
Cc: pgsql-novice@postgresql.org, pgsql-performance@postgresql.org
Subject: Re: [PERFORM] could not send data to client: Broken pipe
References: <580055310602142329u448d044bi@mail.gmail.com>
In-Reply-To: <580055310602142329u448d044bi@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Pradeep Parmar wrote:
> Hi,
> 
> I'm using Postgres 7.4. I have a web application built with php4 using
> postgres7.4
> 
> I was going through /var/log/messages of my linux box ( SLES 9). I
> encountered the following messages quite a few times.
> 
>> postgres[20199]: [4-1] ERROR:  could not send data to client: Broken pipe
>> postgres[30391]: [6-1] LOG:  could not send data to client: Broken pipe
>> postgres[30570]: [6-1] LOG:  could not send data to client: Broken pipe
> 
> Can anyone help me in interpreting these messages?
> What is causing this error msg? What is the severity?

Not really a performance question, but at a guess your client went away. 
Is there anything to indicate this in your php/apache logs? Can you 
reproduce it by hitting cancel in your web-browser?

-- 
   Richard Huxton
   Archonet Ltd