ID: 43563
Comment by: tdrewes at gmx dot net
Reported By: bteissier at tennaxia dot com
Status: No Feedback
Bug Type: OCI8 related
Operating System: Win 2K3
PHP Version: 5.2.5
Assigned To: sixd
New Comment:
Hi,
I have a similiar problem with my setup here:
PHP 5.2.5
Windows XP SP2
OCI8
Apache 2.0.63
When calling this code:
---------------8<------------------------
$sql = 'BEGIN rtm.getrtmsitesummary(:p_site_id, :p_site_type_code_no,
:p_site_status_type_code_no, :p_last_contact_time_from,
:p_last_contact_time_to, :p_zip_code, :p_city, :p_cursor, :p_error);
END;';
$stmt = OCIParse($conn, $sql);
// Create a new cursor resource
$datalist = oci_new_cursor($conn);
// Bind the cursor resource to the Oracle argument
oci_bind_by_name($stmt,":p_site_id",$filter_siteid);
oci_bind_by_name($stmt,":p_site_type_code_no",$filter_sitetype);
oci_bind_by_name($stmt,":p_site_status_type_code_no",$filter_sitestatus);
oci_bind_by_name($stmt,":p_last_contact_time_from",$fromdate);
oci_bind_by_name($stmt,":p_last_contact_time_to",$todate);
oci_bind_by_name($stmt,":p_zip_code",$filter_zipcode);
oci_bind_by_name($stmt,":p_city",$filter_city);
oci_bind_by_name($stmt,":p_cursor",$datalist,-1,OCI_B_CURSOR);
oci_bind_by_name($stmt,":p_error",$p_error,70);
// Execute the statement
$result = oci_execute($stmt);
---------------8<------------------------
oci_execute crashes sometimes (about 50% of the time).
The weird thing is:
The first time it works all the time.
When calling the php screen/function again, it crashes with a
probability of ~50%.
When calling the php screen/function again, it crashes with a
probability of ~90%.
"Crashes" means in my context:
oci_execute is not returning. Apache crashes with this error:
---------------------------
Faulting application Apache.exe, version 2.0.63.200, faulting module
orageneric10.dll, version 10.2.0.1, fault address 0x000baee7.
---------------------------
Previous Comments:
------------------------------------------------------------------------
[2008-02-06 01:00:00] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2008-01-29 01:17:37] [EMAIL PROTECTED]
I can't reproduce with PHP 5.2.5 CLI on Windows XP using Oracle XE
(10.2.0.1) libraries and database.
------------------------------------------------------------------------
[2007-12-13 10:50:25] bteissier at tennaxia dot com
In sqlplus => OK
With php cli => same crash
Other plateforms : app on XP/2003 server and oracle 10g on XP/2003
server => OK
------------------------------------------------------------------------
[2007-12-11 19:57:24] [EMAIL PROTECTED]
I couldn't reproduce this - though I was using Linux and Instant Client
11g.
Does the crash happen consistently? Does it happen if you run the
script in CLI? Does it happen to databases on other platforms or
versions? Does it happen in SQL*Plus, . . .
------------------------------------------------------------------------
[2007-12-11 14:28:06] bteissier at tennaxia dot com
The snaphot does not solve the problem.
My company also used Zend Core for Oracle but had the same problem.
------------------------------------------------------------------------
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/43563
--
Edit this bug report at http://bugs.php.net/?id=43563&edit=1
