Bug #58925 [Com]: No error information available when php_oci_create_env fails

Edit report at https://bugs.php.net/bug.php?id=58925&edit=1 ID: 58925 Comment by: areddan at silverarm dot com Reported by: glenn dot schmidt at deakin dot edu dot au Summary: No error information available when php_oci_create_env fails Status: Closed Type: Bug Package: *General Issues Operating System: Any PHP Version: Irrelevant Assigned To: sixd Block user comment: N Private report: N New Comment: Server load about 9 scripts open during the minute of the corruption, each one connected to the db, lasting approx 1 second each. its PHP Version 5.1.4 --with-oci8=instantclient,/usr/lib/oracle/10.2.0.4/client/lib,/usr/include/oracle/10.2.0.4/client' OCI8 Support enabled Revision $Revision: 1.269.2.16 $ Active Persistent Connections 0 Active Connections 0 Oracle Instant Client Version 10.2 oci8.default_prefetch 10 10 oci8.max_persistent -1 -1 oci8.old_oci_close_semantics 0 0 oci8.persistent_timeout -1 -1 oci8.ping_interval 60 60 oci8.privileged_connect Off Off oci8.statement_cache_size 20 20 No persistant connections are being made and every so often, we get a fail to connect (during busy times) resulting in the following in php error log. [03-Nov-2011 17:11:22] PHP Warning: ocilogon() [<a href='function.ocilogon'>function.ocilogon</a>]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries in /disk1/********/db_class.php on line 17 Previous Comments: ------------------------------------------------------------------------ [2011-11-07 20:19:01] sixd@php.net 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. Code to print the Oracle error message has been added. It may help but from previous experience I know it's not feasible to expect Oracle libraries to identify the real root causes of misconfigured systems. So, if the root cause is some memory corruption from any subsystem involved, I wouldn't expect the messages to be reliable. ------------------------------------------------------------------------ [2011-11-07 20:10:34] sixd@php.net Automatic comment from SVN on behalf of sixd Revision: http://svn.php.net/viewvc/?view=revision&amp;revision=318888 Log: Improve OCI8 NLS env creation error messages (#58925) ------------------------------------------------------------------------ [2011-11-07 19:21:56] sixd@php.net It's a pity there is no useful information in this bug about the versions and environments this is seen on. The root problem could be anywhere (including webserver memory corruption). However since the failure is coming from the environment setup, it's worth triple-checking the OCI8 environment is set correctly. Make sure scripts don't use setenv() to set Oracle environment variables. ------------------------------------------------------------------------ [2011-11-07 11:13:58] areddan at silverarm dot com Does anyone have a solution / update to this one ? I', experiencing similar issues on a clients site, and again its not repeatable. ------------------------------------------------------------------------ [2010-09-08 18:57:56] russ at iris dot washington dot edu I am seeing this error now for the last few months. Very frustrating because no way to force it to happen. As far as I know I changed nothing at all. There must be some resource limit either in PHP or Oracle that is not being reported back as being exceeded. The Apache logs (access and error) contain nothing. ------------------------------------------------------------------------ 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=58925 -- Edit this bug report at https://bugs.php.net/bug.php?id=58925&edit=1