Edit report at https://bugs.php.net/bug.php?id=49803&edit=1
ID: 49803
Comment by: s dot stuecher at mediadialog dot de
Reported by: stronk7 at moodle dot org
Summary: OCI statement cache causes ORA-01007
Status: Suspended
Type: Bug
Package: OCI8 related
Operating System: MacOS X (any)
PHP Version: 5.2.11
Block user comment: N
Private report: N
New Comment:
Reproducible with PHP 7.2.8 with statement_cache_size > 0
Previous Comments:
------------------------------------------------------------------------
[2018-02-07 01:12:35] andrewn at moodle dot com
I've just confirmed that this is still an issue today with the following configuration:
root@f7d715e97f26:/var/www/html# php -v
PHP 7.1.9 (cli) (built: Sep 1 2017 20:31:12) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies
with Zend OPcache v7.1.9, Copyright (c) 1999-2017, by Zend Technologies
Relevant output of php -i:
oci8
OCI8 Support => enabled
OCI8 DTrace Support => disabled
OCI8 Version => 2.1.7
Revision => $Id: 93e7bce2a38c2b7ca3f595e60d92cba198cba14f $
Oracle Run-time Client Library Version => 12.1.0.2.0
Oracle Compile-time Instant Client Version => 12.1
Directive => Local Value => Master Value
oci8.connection_class => no value => no value
oci8.default_prefetch => 100 => 100
oci8.events => Off => Off
oci8.max_persistent => -1 => -1
oci8.old_oci_close_semantics => Off => Off
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20
As before, setting the statement_cache_size to 0 fixes this issue but at a huge detriment to
performance.
------------------------------------------------------------------------
[2013-04-25 14:03:35] stronk7 at moodle dot org
Just to add that exactly the same problem continues happening both under latest
php 5.3.x and 5.4.x, with he module compiled with the new x64 11.2.0.3.0 version
for mac (previously using x32 10.2.0.4.0 with php 5.2).
------------------------------------------------------------------------
[2011-11-09 22:28:28] sixd@php.net
I've logged an Oracle enhancement (#13366134) so this request can be better
tracked by Oracle's normal enhancement process.
------------------------------------------------------------------------
[2010-01-06 19:42:18] sixd@php.net
Doh. I've got it.
------------------------------------------------------------------------
[2010-01-06 19:40:49] sixd@php.net
What's the testcase?
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=49803
--
Edit this bug report at https://bugs.php.net/bug.php?id=49803&edit=1