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