Bug #49803 [Com]: OCI statement cache causes ORA-01007

Edit report at https://bugs.php.net/bug.php?id=49803&edit=1 ID: 49803 Comment by: andrewn at moodle dot com 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: I'm just wondering why this bug is marked as "Suspended" when, 11 yeaers after it was raised, it is still a bug. Previous Comments: ------------------------------------------------------------------------ [2020-05-11 15:38:50] stronk7 at moodle dot org More than 10 years, still impossible to use statement caching with many DDL operations. Completely unbeilable, I'm afraid. PHP could at very least allow the setting to be configured dynamically (maybe it's impossible, I don't know). Or warn whenever it's used under intense DDL ops. And Oracle, well, I imagine enhancement #13366134 will be somewhere. If you had to paid me for the processing time I've spent along these 10 years with the setting disabled... really. I won't comment here again. Pathetic. Ciao :-/ ------------------------------------------------------------------------ [2018-08-29 12:49:40] s dot stuecher at mediadialog dot de Reproducible with PHP 7.2.8 with statement_cache_size > 0 ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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