ID: 28924
Comment by: cdcampos at netcabo dot pt
Reported By: ben at grinvalds dot net
Status: Open
Bug Type: OCI8 related
Operating System: Windows XP
PHP Version: 5.0.0RC3
Assigned To: tony2001
New Comment:
I have an application running on PHP5, using OCI8, and the only
scenario in which I was able have some stability is with 5.0.0 (like
Tanis reported above). Even so, it hangs every now and then, and Apache
needs to be restarted.
I looked at the change log in 5.0.2 and found nothing about this
(serious) problems with the extension. I have upgraded my application
to version 5, mostly because of the SOAP functions, but it seems that
the OCI8 extension was not ready yet...
Previous Comments:
------------------------------------------------------------------------
[2004-09-23 13:56:32] andrew at onvol dot net
I have to same problem and I've tried with the following setups:
windows 2K/Apache2.0.50/PHP5.0.1(SAPI)/Oracle 9.2
windows 2K/Apache1.3.31/PHP5.0.1(SAPI)/Oracle 9.2
Seems to work fine with CGI.
------------------------------------------------------------------------
[2004-08-25 14:42:29] wreckmybike at yahoo dot com
Here’s the setup: windows XP/Apache2.0.50/PHP5.0.0(SAPI)/Oracle 9.2
Applications interacting with OCI8 (logon, parse, execute,
fetch,logoff), which worked as expected using the latest PHP4 release,
resulted in an apache2 crash. "Parent: child process exited with status
3221225477 -- Restarting"..
I then upgraded to PHP5.0.1 which seems to have fixed the above crashes
but now causes every couple of requests to result in the browser hanging
- waiting for the server response. If I hit the browsers refresh button
it forces a response. I suspect it has something to do with the OCI8
Logon/Logoff function.
I have none of these issues when running PHP5 as a CGI.
------------------------------------------------------------------------
[2004-08-23 12:49:04] tanis at altralogica dot it
I am experiencing the same problem with Apache 1.3.29 and PHP 5.0.0,
5.0.1 and 5.0.2-dev of today (August, 23), so I guess this has not been
solved yet.
Is there anything I could to do help debug this problem? I am getting
mad trying to work with this configuration but I cannot do otherwise.
Till now 5.0.0 is the only one that is working from time to time. All
other versions hung immediately.
------------------------------------------------------------------------
[2004-07-19 23:46:09] ben at grinvalds dot net
I went and got the latest version PHP 5.0.1-dev (cli). I ran the
following script from the console and it consistantly hung the php
execution. This is how I executed it at the command prompt (> php.exe
-f test.php).
Here is the script I ran. The object count for my database was just
over 10,000 records.
<?php
$conn = oci_connect("scott", "tiger", "yourhost");
$stmt = oci_parse($conn, "select * from all_objects where owner =
'SYS'");
oci_execute($stmt);
$count = 0;
while ($row = oci_fetch_assoc($stmt))
echo $count++ . " ";
oci_free_statement($stmt);
oci_close($conn);
echo "Executed Query";
?>
------------------------------------------------------------------------
[2004-07-19 17:24:56] [EMAIL PROTECTED]
Could you please try latest CVS snapshots from http://snaps.php.net?
And could you try to run the code from console too?
Does it 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/28924
--
Edit this bug report at http://bugs.php.net/?id=28924&edit=1
