Обсуждение: plphp crashing server

Uh oh, I think plphp is crashing the server. When I
update a row in the table with the trigger, this
happens:

server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting
reset: Failed.

And this is what shows up in the log:

LOG:  server process (PID 31665) was terminated by
signal 11
LOG:  terminating any other active server processes

Wow. I still don't see anything wrong with the plphp
function - how could it cause the entire server to
crash?

Thanks,
CSN



____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs

Jeez, nevermind again! Turns out this was the problem
in the plphp script:

$sql="select * from table where id=123";
$result=spi_exec_query($sqll);

I'm still curious about the "Call-time
pass-by-reference has been deprecated" warning if
anybody knows.

Thanks,
CSN


--- CSN <cool_screen_name90001@yahoo.com> wrote:

> Uh oh, I think plphp is crashing the server. When I
> update a row in the table with the trigger, this
> happens:
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting
> reset: Failed.
>
> And this is what shows up in the log:
>
> LOG:  server process (PID 31665) was terminated by
> signal 11
> LOG:  terminating any other active server processes
>
> Wow. I still don't see anything wrong with the plphp
> function - how could it cause the entire server to
> crash?
>
> Thanks,
> CSN
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

On Thu, Aug 11, 2005 at 01:50:21PM -0700, CSN wrote:
> And this is what shows up in the log:
>
> LOG:  server process (PID 31665) was terminated by
> signal 11
> LOG:  terminating any other active server processes
>
> Wow. I still don't see anything wrong with the plphp
> function - how could it cause the entire server to
> crash?

Not your function, but the plPHP handler can if called with the right
(or wrong) function.  I guess you should show the function or a reduced
test case to the plPHP developers.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"La verdad no siempre es bonita, pero el hambre de ella sí"

On Thu, Aug 11, 2005 at 01:59:56PM -0700, CSN wrote:
>
> Jeez, nevermind again! Turns out this was the problem
> in the plphp script:
>
> $sql="select * from table where id=123";
> $result=spi_exec_query($sqll);

If this is reproducable (ie, you can provide a script to trigger it),
please make sure you register the bug somewhere
(Postgresql/distributer/etc). Server crashing is never a good thing.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.