ID: 30412 Updated by: [EMAIL PROTECTED] Reported By: subscription at nazarenko dot net -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: SuSE Linux 8.2 PHP Version: 5.0.3RC1 New Comment:
Please, try latest snapshot with non-threaded Apache. Are you still able to replicate the problem ? Previous Comments: ------------------------------------------------------------------------ [2004-12-03 11:52:49] rathamahata at ehouse dot ru Sorry, please ignore previous post. That was apache with MPM=prefork + php compiled against apache with mpm=worker. I don't know how did it work. After i recompiled php against current apache problem had disappeared. ------------------------------------------------------------------------ [2004-12-03 11:31:54] rathamahata at ehouse dot ru It looks like this happens (the browser would just wait with nothing happening) even with prefork mpm. strace shows Process 27641 attached - interrupt to quit futex(0x83967f0, FUTEX_WAIT, 2, NULL which is strange becouse apache is compiled with mpm=prefork `apache2 -l' Compiled in modules: core.c mod_access.c mod_auth.c mod_include.c mod_deflate.c mod_log_config.c mod_expires.c mod_setenvif.c prefork.c http_core.c mod_mime.c mod_status.c mod_autoindex.c mod_info.c mod_cgi.c mod_dir.c mod_alias.c mod_rewrite.c mod_so.c ------------------------------------------------------------------------ [2004-12-02 15:17:32] subscription at nazarenko dot net Let me confirm it again after some more testing today that I still do get segfaults, but not that often than before. Also, let me point out that it seems to be exclusively Apache/PHP problem. The same script is run from the shell environment with no problems at all. Now to the example that you have asked for. It is really simple. In fact *any* Oracle query will cause occasional browser "hanging". Here is a bit of code I used today for testing: <?php $db_conn = ocilogon( "user", "password", "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myoracle)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=CRPT)))") or die("Critical Error: No connection to Oracle!"); $cmdstr = " SELECT DISTINCT TRIM(XM.X_MEMBER_ID) MEMBER_ID, S.X_MEMBER_ID DBS_ID FROM TABLE_SITE_PART SP, TABLE_SITE_PART SP2, TABLE_X_MEMBERDATA XM, TABLE_SITE S WHERE SP2.X_CLASS_KEY = 9 AND SP2.LEVEL_TO_BIN IN (0,1,2,3,4,5) AND SP2.SITE_PART2SITE_PART = SP.OBJID AND SP2.X_SITE_PART2MEMBERDATA = XM.OBJID AND SP.ALL_SITE_PART2SITE = S.OBJID AND XM.X_STATUS = 'Active' AND S.STATUS = '0' ORDER BY TRIM(XM.X_MEMBER_ID) "; $parsed = ociparse($db_conn, $cmdstr); ociexecute($parsed); $boxrows = ocifetchstatement($parsed, $listbox); OCIFreeStatement($parsed); print_r($listbox); ?> Most of the times this would work fine returning me an array of data. But sometimes the browser would just wait with nothing happening. And very rarely the page would fail immediately (producing a segfault in apache's error log) Hope this helps. ------------------------------------------------------------------------ [2004-12-02 01:20:38] [EMAIL PROTECTED] >[Thu Dec 02 00:57:47 2004] [warn] child process 18167 still did not exit, sending a SIGTERM I don't think PHP/OCI8 is causing this. I saw this problem many times without OCI8 enabled or even without any module enabled at all. >Some page loads are unsuccessful, but there >is no segfault! The browser just keeps waiting and waiting >and nothing I would be very thankful if you provide tiny reproduce script, that I can use to reproduce your problem. happens. ------------------------------------------------------------------------ [2004-12-02 01:05:47] subscription at nazarenko dot net Marking it as open... ------------------------------------------------------------------------ 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/30412 -- Edit this bug report at http://bugs.php.net/?id=30412&edit=1