#37531 [NEW]: Persistent connection corruption

From: Date: Fri, 19 May 2006 22:29:13 +0000
Subject: #37531 [NEW]: Persistent connection corruption
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-97393@lists.php.net to get a copy of this message
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

« previous php.bugs (#97393) next »