Re: [GENERAL] pq_flush: send() failed: Broken pipe

2007-03-05 Thread Andrej Ricnik-Bay

On 3/6/07, Yumiko Izumi [EMAIL PROTECTED] wrote:

Hello.

Hi,


When I carried out SQL sentence in PostgreSQL7.3.8 environment,
PostgreSQL outputs the following error messages.

Can't say anything sensible regarding the error message,
but if you have to carry on using 7.x you should upgrade
to at least 7.4.16.  Your install is 2.5 years behind, and there
were quite a few patches/security fixes since.


Cheers,
Andrej

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [GENERAL] pq_flush: send() failed: Broken pipe

2007-03-05 Thread Tom Lane
Yumiko Izumi [EMAIL PROTECTED] writes:
 When I carried out SQL sentence in PostgreSQL7.3.8 environment,
 PostgreSQL outputs the following error messages.
 ==
 Dec 19 13:50:32 gyomu01 postgres[807]: [11] LOG:  pq_flush: send() failed: 
 Broken pipe
 Dec 19 13:50:33 gyomu01 postgres[807]: [12] LOG:  pq_recvbuf: unexpected EOF 
 on client connection

These messages indicate that psql crashed, not the backend.  Did you not
see any interesting messages on the client side?  Can you get a stack
trace from the psql crash?

Also, as someone already mentioned, the current release in the 7.3
branch is 7.3.18 not 7.3.8.  If you want us to expend time looking for
the problem, it would be polite to first make sure it's not a
long-since-solved problem.

regards, tom lane

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings