Re: Broken pipe

----- Original Message -----
From: "Nirmalya Lahiri" <nirmalyalahiri(at)yahoo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, October 02, 2005 7:34 PM
Subject: Re: [GENERAL] Broken pipe

Hi all,
I am not expert in PHP, so my assumption may not correct....
Can we solve this problem by increasing the "max_execution_time"
value at php.ini file?

--Nirmalya

--- Ben-Nes Yonatan <nimrod(at)canaan(dot)co(dot)il> wrote:

> Hi all,
>
> I sent the following email to the php mailing list also but maybe
> this
> is a more appropriate mailing list.
>
> I wrote a php script which is running very long queries (hours) on
> a
> database.
> I seem to have a problem to run the code when there are single
> queries
> which take long times (like 5 hours for an update query), from the
> log
> of the database I received the following code:
>
> 2005-09-30 17:12:13 IDT postgres : LOG: 00000: duration:
> 18730038.678
> ms statement: UPDATE product_temp SET nleft=(SELECT
> 2005-09-30 17:12:13 IDT postgres : LOCATION: exec_simple_query,
> postgres.c:1035
> 2005-09-30 17:12:13 IDT postgres : LOG: 08006: could not send data
> to
> client: Broken pipe
> 2005-09-30 17:12:13 IDT postgres : LOCATION: internal_flush,
> pqcomm.c:1050
> 2005-09-30 17:12:13 IDT postgres : LOG: 08P01: unexpected EOF on
> client
> connection
> 2005-09-30 17:12:13 IDT postgres : LOCATION: SocketBackend,
> postgres.c:287
> 2005-09-30 17:12:13 IDT postgres : LOG: 00000: disconnection:
> session
> time: 6:04:58.52
> 2005-09-30 17:12:13 IDT postgres : LOCATION: log_disconnections,
> postgres.c:3403
>
> Now after the 5 hours update it need to echo into a log file a line
> which say that it ended this command (just for me to know the
> times), my
> assumption is that PHP read the code into memory at start and
> opened the
> connection to the file, after a time which he waited to any given
> "life
> sign" he gave up and closed the connection to the file, and when
> the
> code came back to the file it encountered no connection to the file
> (broken pipe).
>
> Am I correct at my assumption? if so how can I set the PHP to wait
> how
> much I tell him?
> Ofcourse if im wrong I would like to know the reason also :)
>
>
> Thanks in advance,
> Ben-Nes Yonatan
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

Well I set the max_execution_time to 0 which is supposed to be endlessly,
but I think that after sometime even that get closed.....
I really dont know if its a postgresql problem or php....

Shana Tova! (hebrew happy new year :))
Ben-Nes Yonatan