#47118 [NoF->Opn]: Segmentation fault on ociexecute
ID: 47118
User updated by: holger at noefer dot org
Reported By: holger at noefer dot org
-Status: No Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Solaris 8
PHP Version: 5.2.8
Assigned To: sixd
New Comment:
Hi,
sorry for my very late response.
The workaround to increase oci8.default_prefetch worked for me,
sometimes I got an segmenation fault.
After that I applied the patch and removed the increased
oci8.default_prefetch value from php.ini.
The patch works fine and resolved my problem, no segmentation
faults seen any more.
Thanks for helping with the bug.
Best regards,
Holger
Previous Comments:
------------------------------------------------------------------------
[2009-02-18 01:00:02] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2009-02-10 19:41:36] sixd@php.net
If you think it is #41069, you can examine use of Oracle dblinks in
your application.
The changes in php_oci_statement_set_prefetch() in
http://cvs.php.net/viewvc.cgi/pecl/oci8/oci8_statement.c?r1=1.7.2.14.2.28.2.4&r2=1.7.2.14.2.28.2.5
are the patch, if you want to test a code fix.
If this doesn't help, I'd recommend upgrading OCI8 to 1.3.4 from PECL
before we continue investigation.
------------------------------------------------------------------------
[2009-01-30 18:52:18] holger at noefer dot org
Hello,
I changed oci8.default_prefetch from 10 to 100.
The segmentation faults seems to be fewer than before.
Perhaps it is related to this bug?
http://bugs.php.net/bug.php?id=41069
Best regards,
Holger
------------------------------------------------------------------------
[2009-01-30 15:04:24] holger at noefer dot org
Hello,
sorry for the long time I did not respond to the bug but it
is hard to aim the bug.
The bug seems to appear when I use persistent connections.
Here are the default settings in php.ini
oci8.default_prefetch => 10 => 10
oci8.max_persistent => -1 => -1
oci8.old_oci_close_semantics => 0 => 0
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20
Should the oci8.persistent_timeout be changed?
I will try to post some code next week.
Best regards,
Holger
------------------------------------------------------------------------
[2009-01-15 21:46:24] sixd@php.net
Please help narrow down the problem with the aim of supplying a
reproducable testcase. Look at patterns in the frequency of crash, the
statement(s) that crash, and the environment (machine, environment
variables, build options, connection etc) that causes the crash.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/47118
--
Edit this bug report at http://bugs.php.net/?id=47118&edit=1
Thread (9 messages)