From: jreed at myers dot com
Operating system: Linux - 386
PHP version: 5.1.4
PHP Bug Type: OCI8 related
Bug description: Persistent connection corruption
Description:
------------
If you open a persistent connection on one page, then on another page you
open a file using fopen, thus creating a file resource, and then attempt
to obtain a persistent oci8 connection using ociplogon(), the returned
resource is not a valid oci8 connection resource. If you then attempt to
use that connection resource you get the following warning:
"supplied resource is not a valid oci8 connection resource"
If you close the file using fclose() prior to calling ociplogon() then
everything works fine.
This problem was introduced in v5.1.3 and continues in 5.1.4.
Reproduce code:
---------------
page1.html
<?php
putenv("TNS_ADMIN=/etc/myers");
$conn_ora = ociplogon("portal", "portal123", "eng2");
ocilogoff($conn_ora);
header("Location: page2.html");
?>
page2.html
<?php
$fp = fopen('/tmp/test.log','a');
$conn_ora = ociplogon($username, $password, $db);
$sql = "select * from dual";
$stmt = ociparse($conn_ora, $sql);
?>
Expected result:
----------------
Page redirects to second page and get a blank page.
Actual result:
--------------
Warning: ociparse(): supplied resource is not a valid oci8 connection
resource in /www/myers/sites/portal/main/orders/test2.html on line 7
Warning: ocilogoff(): supplied resource is not a valid oci8 connection
resource in /www/myers/sites/portal/main/orders/test2.html on line 8
--
Edit bug report at http://bugs.php.net/?id=37531&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=37531&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=37531&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=37531&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37531&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=37531&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=37531&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=37531&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=37531&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=37531&r=support
Expected behavior: http://bugs.php.net/fix.php?id=37531&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=37531&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=37531&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37531&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37531&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37531&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=37531&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=37531&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=37531&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=37531&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=37531&r=mysqlcfg
