php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #63265 Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro
Submitted: 2012-10-12 02:09 UTC Modified: 2012-10-12 02:09 UTC
From: sixd@php.net Assigned: sixd
Status: Closed Package: OCI8 related
PHP Version: 5.4.7 OS: All
Private report: No CVE-ID:
 [2012-10-12 02:09 UTC] sixd@php.net
Description:
------------
The error ORA-00028 "your session has been killed" should be added to the 
PHP_OCI_HANDLE_ERROR macro.  This would allow a connection that was killed with  
ALTER SYSTEM KILL SESSION to be directly marked for re-establishment. 

Currently after getting ORA-00028, reusing the connection gives ORA-01012 which 
causes the cleanup.  Adding ORA-00028 would reduce the number of operations 
needed to recover from a DBA killing a session: after getting ORA-00028 the next 
connection reuse would "work" because OCI8 has reopened the connection.


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2012-10-12 02:09 UTC] sixd@php.net
-Assigned To: +Assigned To: sixd
 [2012-10-19 01:56 UTC] sixd@php.net
Automatic comment on behalf of sixd
Revision: http://git.php.net/?p=php-src.git;a=commit;h=131dd88505d5a9588ede36b22206bf13965d9137
Log: Fixed bug #63265 (Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro)
 [2012-10-19 01:56 UTC] sixd@php.net
-Status: Assigned +Status: Closed
 
PHP Copyright © 2001-2014 The PHP Group
All rights reserved.
Last updated: Fri Apr 18 15:02:26 2014 UTC