From: erwann_gilbert at yahoo dot fr Operating system: RedHat 6 PHP version: 4.3.11 PHP Bug Type: OCI8 related Bug description: problems with lock registers
Description: ------------ I have a problem with locks. I try to create a lock thanks to "SELECT X FROM TAB FOR UPDATE NOWAIT". to do this : - I parse my query : $resource = ociparse ($onnection, "SELECT X FROM TAB FOR UPDATe NOWAIT") ; - I execute my query : ociexecute ($resource, OCI_DEFAULT) ; - I don't close the connection in the script. If I use the query in SQL*PLUS and (without commit or rollback in SQL*PLUS of course) I start my php script, I obtain the ORA error wiwh tells there is a lock etc... So all is good. But if I start the script before, and the query in SQL*PLUS after, there is no lock created by the script. Like if there was an implicite rollback. I don't know if it's a problem of oci, or a problem of configuration or a problem of PHP... Reproduce code: --------------- $connect = ocilogon($user,$password,$tns) ; $resource=ociparse ($connect,"SELECT X FROM TAB FOR UPDATE NOWAIT") ; ociexecute ($resource,OCI_DEFAULT) ; Expected result: ---------------- If two scripts are executed at the same time : an oracle error in one of both script. Actual result: -------------- No error, and no lock created. -- Edit bug report at http://bugs.php.net/?id=33014&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33014&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33014&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33014&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33014&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33014&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33014&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33014&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33014&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33014&r=support Expected behavior: http://bugs.php.net/fix.php?id=33014&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33014&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33014&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33014&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33014&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33014&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33014&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33014&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33014&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33014&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33014&r=mysqlcfg