Edit report at https://bugs.php.net/bug.php?id=55768&edit=1
ID: 55768
Updated by: tony2...@php.net
Reported by: mikhail dot v dot gavrilov at gmail dot com
Summary: PDO_OCI can't resume session when kill Oracle
session's
-Status: Open
+Status: Closed
Type: Bug
Package: Oracle related
Operating System: All
PHP Version: 5.3.8
-Assigned To:
+Assigned To: tony2001
Block user comment: N
Private report: N
New Comment:
This bug has been fixed in SVN.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
For Windows:
http://windows.php.net/snapshots/
Thank you for the report, and for helping us make PHP better.
Previous Comments:
------------------------------------------------------------------------
[2011-09-27 09:11:54] tony2...@php.net
Automatic comment from SVN on behalf of tony2001
Revision: http://svn.php.net/viewvc/?view=revision&revision=317381
Log: fix bug #55768 (PDO_OCI can't resume Oracle session after it's been killed)
------------------------------------------------------------------------
[2011-09-23 13:04:06] mikhail dot v dot gavrilov at gmail dot com
Description:
------------
I found problem in PDO_OCI, if Oracle session killed by ALTER SYSTEM KILL
SESSION operator, PDO_OCI can't resume session.
For example we can find all PHP active sessions on Oracle:
SELECT
'ALTER SYSTEM KILL SESSION ''' || s.sid||','|| s.serial#||''' IMMEDIATE;'
FROM gv$session s
JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id WHERE
s.type != 'BACKGROUND'and s.program like 'php-fpm: pool%';
And run results strings for kill session:
ALTER SYSTEM KILL SESSION 'xxxx,xxx' IMMEDIATE; ALTER SYSTEM KILL SESSION
'xxxx,xxx' IMMEDIATE;
First error that catch PHP script look so:
SQLSTATE[01002]: Disconnect error: 3113 OCIStmtExecute: Error while trying to
retrieve text for error ORA-03113 separator not found in message(3144)separator
not found in message(3142)
(/root/rpmbuild/BUILD/php-5.3.8/ext/pdo_oci/oci_statement.c:148)
Second and all next error look so:
SQLSTATE[HY000]: General error: 3114 OCIStmtExecute: Error while trying to
retrieve text for error ORA-03114
(/root/rpmbuild/BUILD/php-5.3.8/ext/pdo_oci/oci_statement.c:148)
My connection parameters:
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION PDO::ATTR_PERSISTENT => true
PDO::ATTR_AUTOCOMMIT => false
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=55768&edit=1
