#32718 [Opn->Fbk]: Sessions locks while OCIFetch is running

ID: 32718 Updated by: sniper@php.net Reported By: jogodinho at gms dot pt -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Windows XP Professional PHP Version: 5.0.4 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2005-04-19 11:33:24] jogodinho at gms dot pt The problem is not with version 4, but yes with version 5. I need to install this version to use some functionalities only available in the new version. ------------------------------------------------------------------------ [2005-04-17 14:55:13] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2005-04-15 14:16:02] sniper@php.net FYI: The PHP 4.3.11 is really the latest stable version, PHP 5.0.x is something less stable.. ------------------------------------------------------------------------ [2005-04-15 14:00:00] jogodinho at gms dot pt 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 this bug report at http://bugs.php.net/?id=32718&edit=1