ID: 47118 Updated by: j...@php.net Reported By: holger at noefer dot org -Status: Open +Status: Assigned Bug Type: OCI8 related Operating System: Solaris 8 PHP Version: 5.2.8 Assigned To: sixd
Previous Comments: ------------------------------------------------------------------------ [2009-06-18 21:13:48] holger at noefer dot org 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 ------------------------------------------------------------------------ [2009-02-10 19:41:36] s...@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] s...@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
