php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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 (profile)
Status: Closed Package: OCI8 related
PHP Version: 5.4.7 OS: All
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: sixd@php.net
New email:
PHP Version: OS:

 

 [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

Pull Requests

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
 [2014-10-07 23:21 UTC] stas@php.net 
Automatic comment on behalf of sixd
Revision: http://git.php.net/?p=php-src-security.git;a=commit;h=131dd88505d5a9588ede36b22206bf13965d9137
Log: Fixed bug #63265 (Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro)
 [2014-10-07 23:32 UTC] stas@php.net 
Automatic comment on behalf of sixd
Revision: http://git.php.net/?p=php-src-security.git;a=commit;h=131dd88505d5a9588ede36b22206bf13965d9137
Log: Fixed bug #63265 (Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro)
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Nov 21 12:01:29 2024 UTC