|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2005-04-15 14:16 UTC] sniper@php.net
[2005-04-17 14:55 UTC] sniper@php.net
[2005-04-19 11:33 UTC] jogodinho at gms dot pt
[2005-04-21 17:25 UTC] sniper@php.net
[2005-04-29 01:00 UTC] php-bugs at lists dot php dot net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Nov 07 10:00:01 2025 UTC |
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