Re: [PERFORM] could not send data to client: Broken pipe

Lists: pgsql-novicepgsql-performance
From: Pradeep Parmar <pradeep(dot)dba(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: could not send data to client: Broken pipe
Date: 2006-02-15 07:29:47
Message-ID: 580055310602142329u448d044bi@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice pgsql-performance

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?

Regards

-- Pradeep


From: Richard Huxton <dev(at)archonet(dot)com>
To: Pradeep Parmar <pradeep(dot)dba(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] could not send data to client: Broken pipe
Date: 2006-02-15 09:39:46
Message-ID: 43F2F6E2.1020004@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice pgsql-performance

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