From: jogodinho at gms dot pt
Operating system: Windows XP Professional
PHP version: 5.0.4
PHP Bug Type: OCI8 related
Bug description: Sessions locks while OCIFetch is running
Description:
------------
Recently i have submit a upgrade from version PHP4.2.3 to PHP5.0.4 (last
stable version available) and now i have some problems of scability that
they didn't happen before.
I establish a connection with a data base with following code:
----
$conn=OCILogon("user", "pass", "bd");
---
And when i submit a query (that it delays 28 seconds approximately, to
return 76000 registers) with the function OCIParse, other sessions that
they intend to establish connections apparently locks, waiting that query
finishes and sometimes i get the following warning:
---
Warning: ocifetch() [<a href='function.ocifetch'>function.ocifetch</a>]:
OCIFetch: ORA-01001: invalid cursor in ... on line 253
Reproduce code:
---------------
$conn=OCILogon("user", "pass", "bd");
$query = "select ...";
$stmt = OCIParse($conn, $query);
OCIExecute($stmt, OCI_DEFAULT);
while(OCI_Fetch($stmt))
{
OCIResult($stmt, 1);
(...)
}
Expected result:
----------------
Obtain query results
Actual result:
--------------
While the query is running, others sessions locks and sometimes i get the
warning:
---
Warning: ocifetch() [<a href='function.ocifetch'>function.ocifetch</a>]:
OCIFetch: ORA-01001: invalid cursor in ... on line 253
--
Edit bug report at http://bugs.php.net/?id=32718&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32718&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=32718&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=32718&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=32718&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=32718&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=32718&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=32718&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=32718&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=32718&r=support
Expected behavior: http://bugs.php.net/fix.php?id=32718&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=32718&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=32718&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=32718&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32718&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=32718&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=32718&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=32718&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=32718&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=32718&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=32718&r=mysqlcfg
