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

ID: 15577 Updated by: bgrogan@gasou.edu Reported By: ccornutt@catalog.com Status: No Feedback Bug Type: OCI8 related Operating System: Solaris PHP Version: 4.1.1 New Comment: I also get the famous ORA - 03113 error when trying to select data from certain tables with a simple script. Other tables I can select from. Still troubleshooting this. Previous Comments: ------------------------------------------------------------------------ [2002-06-08 12:56:59] paul@redeye.com Ignore my posting, the problem has returned. However, given this error only occurs for us with an application that uses two different connections in the same script that would appear to be a clue. ------------------------------------------------------------------------ [2002-06-08 04:44:29] paul@redeye.com 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. ------------------------------------------------------------------------ [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