Bug #15577 Updated: "failed to rollback outstanding transactions!" Oracle connection error

ID: 15577 Updated by: paul@redeye.com Reported By: ccornutt@catalog.com Status: No Feedback Bug Type: OCI8 related Operating System: Solaris PHP Version: 4.1.1 New Comment: Similar problem on linux, the big mystery was that it was happening on SELECTs. : Was using PLogon, tried to commit after every transaction but no change Changed to non persistent log ons, still no change. Eventually resolved it by specify OCILogoff after every connection. Problem seemed to be due to establishing 2 different connections within the same php script. Previous Comments: ------------------------------------------------------------------------ [2002-05-24 00:00:04] php-bugs@lists.php.net No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2002-04-13 09:16:36] thies@php.net please send me a short fully self-contained testcase. ------------------------------------------------------------------------ [2002-02-15 15:14:03] ccornutt@catalog.com I have a function: --------------------------------- function SQLreturn($sql){ $OC = @OCINLogon($this->user,$this->pass,$this->string); if($OC){ $parsed = OCIParse($OC,$sql); OCIExecute($parsed); OCIFetchInto($parsed, &$rows,OCI_ASSOC); OCIFreeStatement($parsed); OCILogOff($OC); //return the array //print_r($rows); return $rows; }else{ echo "No SQL connect: return"; } } ------------------------------------ that appears to cause some trouble...I'm not sure why either. Other database connections work fine on this same server, but this one keeps giving messages like: Warning: failed to rollback outstanding transactions!: Error while trying to retrieve text for error ORA-03113 in /export/home1/catalog/domainadmin/index.php on line 97 Warning: _oci_close_session: OCISessionEnd: Error while trying to retrieve text for error ORA-12545 in /export/home1/catalog/domainadmin/index.php on line 97 Has anyone else encountered this one? If so, any idea how to fix it? thanks, -chris ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15577&edit=1