ID: 22857 Updated by: [EMAIL PROTECTED] Reported By: dean at vipersoft dot co dot uk -Status: Feedback +Status: No Feedback Bug Type: OCI8 related Operating System: Linux 2.4 PHP Version: 4.3.1 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: ------------------------------------------------------------------------ [2003-03-24 18:03:55] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip First of all, those putenv()'s are useless, you need to set them in the environment before starting Apache / running CLI. It might help if you tried debugging this with gdb. # gdb /opt/php/bin/php (gdb) run yourtest.php And do that as many times as required to get it fail.. ------------------------------------------------------------------------ [2003-03-24 14:06:01] dean at vipersoft dot co dot uk Using the sample code below to submit a number of queries to an Oracle database - about every 1 in 10 executions causes the OCIExecute function to simple "hang" for about 10 minutes before timing out. If more information is needed or any sorts of debugging is required, I will follow up to this bug with the requested information. Thanks Dean #!/opt/php/bin/php -q <? $webDbase = "blah"; $webUser = "blah"; $webPassword = "blah"; global $ORACLE_HOME; $ORACLE_HOME = "/opt/oracle/OraHome81"; PutEnv("ORACLE_SID=".$webDbase); PutEnv("LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:$ORACLE_HOME/jdbc/lib"); PutEnv("ORACLE_HOME=".$ORACLE_HOME); $conn = ocilogon($webUser, $webPassword, $webDbase) or die ("Could not connect (Bad background connect Userid or Password) [".Getenv("ORACLE_SID")."]"); // Loop around 4000 times - basically to throw a lot // of queries at the database for ($i=1;$i<=4000;$i++) { echo "Iteration ".$i."\n"; // use a random number to use differing queries $strSQL = "SELECT * FROM blah WHERE id = '".rand(0,50000)."'"; $qid = OCIparse($conn, $strSQL); echo "before execute\n"; OCIexecute($qid); echo "after execute\n"; } echo "Done"; ?> sample output from above when "hung" . . . Iteration 2671 before execute after execute Iteration 2672 before execute after execute Iteration 2673 before execute <then nothing> Notes: * Doesn't happen every time * Happens about 1 in every 10 runs of the above code * Happens from both the CLI php and through Apache * Eventually times out without finishing off its iteration ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=22857&edit=1
