Re: Broken pipe - Mailing list pgsql-general

From Nirmalya Lahiri
Subject Re: Broken pipe
Date
Msg-id 20051002173419.28703.qmail@web30315.mail.mud.yahoo.com
Whole thread Raw
In response to Broken pipe  (Ben-Nes Yonatan <nimrod@canaan.co.il>)
List pgsql-general
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@canaan.co.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
>




__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: scoring differences between bitmasks
Next
From: Ben
Date:
Subject: Re: scoring differences between bitmasks