ID: 19517 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: windows 2000 and linux PHP Version: 4.2.3 New Comment:
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 Previous Comments: ------------------------------------------------------------------------ [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
