From:
Operating system: All
PHP version: 5.3.8
Package: PDO related
Bug Type: Bug
Bug description:PDO_OCI can't resume session when kill Oracle session's
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 bug report at https://bugs.php.net/bug.php?id=55768&edit=1
--
Try a snapshot (PHP 5.4):
https://bugs.php.net/fix.php?id=55768&r=trysnapshot54
Try a snapshot (PHP 5.3):
https://bugs.php.net/fix.php?id=55768&r=trysnapshot53
Try a snapshot (trunk):
https://bugs.php.net/fix.php?id=55768&r=trysnapshottrunk
Fixed in SVN:
https://bugs.php.net/fix.php?id=55768&r=fixed
Fixed in SVN and need be documented:
https://bugs.php.net/fix.php?id=55768&r=needdocs
Fixed in release:
https://bugs.php.net/fix.php?id=55768&r=alreadyfixed
Need backtrace:
https://bugs.php.net/fix.php?id=55768&r=needtrace
Need Reproduce Script:
https://bugs.php.net/fix.php?id=55768&r=needscript
Try newer version:
https://bugs.php.net/fix.php?id=55768&r=oldversion
Not developer issue:
https://bugs.php.net/fix.php?id=55768&r=support
Expected behavior:
https://bugs.php.net/fix.php?id=55768&r=notwrong
Not enough info:
https://bugs.php.net/fix.php?id=55768&r=notenoughinfo
Submitted twice:
https://bugs.php.net/fix.php?id=55768&r=submittedtwice
register_globals:
https://bugs.php.net/fix.php?id=55768&r=globals
PHP 4 support discontinued:
https://bugs.php.net/fix.php?id=55768&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=55768&r=dst
IIS Stability:
https://bugs.php.net/fix.php?id=55768&r=isapi
Install GNU Sed:
https://bugs.php.net/fix.php?id=55768&r=gnused
Floating point limitations:
https://bugs.php.net/fix.php?id=55768&r=float
No Zend Extensions:
https://bugs.php.net/fix.php?id=55768&r=nozend
MySQL Configuration Error:
https://bugs.php.net/fix.php?id=55768&r=mysqlcfg
