ID: 19517 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: No Feedback Bug Type: OCI8 related Operating System: windows 2000 and linux PHP Version: 4.2.3 New Comment:
No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2002-11-26 20:14:08] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-11-26 15:33:36] [EMAIL PROTECTED] This might be an Apache 2 problem. Can you reproduce the crash with the latest CVS release on Apache over 2.0.43? ------------------------------------------------------------------------ [2002-11-05 14:13:23] [EMAIL PROTECTED] I get this error in my apache error log when multithreading is turned on: [notice] child pid 28373 exit signal Segmentation fault (11) Apache: 2.0.X (mpm worker) OS: HP-UX 11.00 (with linker patches) PHP: 4.2.2 dso with oci8 extension Oracle: 8.1.6 If I set ThreadsPerChild to 1 (single threaded), I don't get any segfaults. With ThreadsPerChild set to 2 (or higher) I get the segmentation faults with as few as 2 concurrent requests (ab -n 10 -c 2 http://testurl/). With particularly high load (>100 concurrent requests) Apache 2 hangs, and has to be killed. I also get this error message in my php log: "PHP Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name" On the same system, Apache 1.3.26 with PHP as CGI works perfectly. ------------------------------------------------------------------------ [2002-09-20 03:30:06] [EMAIL PROTECTED] on medium/high load and on multi-threaded serveurs ( apache 1.3.X windows and apache 2.0.X (mpm=worker) on linux), oci cause segmentation fault to apache. I test with apache 1.3.26 / 2.0.40 on windows 2000 server and professionnal, php 4.2.3, oracle 8.1.7.0 and 9.0.1 ( on the same and different Pc). I test with and without autocommit. i always get the same result. the script: <? $c = ocilogon ( 'test', "test", "db9"); $sql = "select count(id) as nb_row from test"; $stmt = ociparse ( $c, $sql ); ociexecute ( $stmt ); ocifetchinto ( $stmt, $tab ); print_r ( $tab ); ocilogoff ( $c ); ?> i run test with microsoft web apllication stress tools and ab. the error message is : _oci_open_server: ORA12154 TNS: could not resolve service name. All works fine with linux / apache 1.3.X. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19517&edit=1