ID: 29779
Comment by: rickyblankenaufulland at leonardo dot de
Reported By: robertg2 at hope dot ac dot uk
Status: Suspended
Bug Type: OCI8 related
Operating System: Solaris 8
PHP Version: 5.0.1
Assigned To: tony2001
New Comment:
Expiring the same problem on Linux (Fedora 2, Kernel 2.6.5). Restarting
Apache with option graceful is okay in an internal environment but
fixing this error would be very nice too ;-)
Previous Comments:
------------------------------------------------------------------------
[2004-11-22 15:00:06] robertg2 at hope dot ac dot uk
I ended up using the oracle extension rather than the oci8 extension.
Have had no problems since.
------------------------------------------------------------------------
[2004-11-22 14:44:29] stasamj at kscems dot ksc dot nasa dot gov
Getting a very similar problem with database on Solaris 8 64-bit Oracle
8.1.7.3.0 using Oracle 9.2.0.5 listener, PHP server 4.3.7 on RedHat
Linux (2.4)/Apache 1.3. Following weekly cold backup, PHP keeps trying
to use cached persistent connections, giving ORA-24327 and/or ORA-03113
(end-of-file on communication channel). Can trap the error, but can't
figure out how to flush the dead connections from the connection cache!
Hate to cron an Apache restart daily...
------------------------------------------------------------------------
[2004-08-21 21:59:10] [EMAIL PROTECTED]
Yes, these functions establish new connection. But this error can be
also concerned with internal Oracle Interface Library problems (search
this error message in google) and not with PHP.
Nevertheless, PHP doesn't ping already established connections, because
it would slow down things too much. Probably in the future we will add
an ini setting for it, but currently ociping() is just disabled for
perfomance reasons.
------------------------------------------------------------------------
[2004-08-21 21:23:56] robertg2 at hope dot ac dot uk
Thanks Tony. Can I just clarify something - are you saying that
oci_new_connect() and ocinlogon() don't actually establish new
connections? I was under the impression that these functions forced a
new connection to be made.
------------------------------------------------------------------------
[2004-08-21 20:30:34] [EMAIL PROTECTED]
It's a known feature and will be probably fixed in future versions.
Currently you can fix it yourself with uncommenting ociping() function
in oci8.c and recompiling PHP.
Or, much easier way, do not shutdown the database or restart Apache in
the same time - all established connections will be discarded and
ocilogon/oci_connect will establish new ones.
------------------------------------------------------------------------
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
http://bugs.php.net/29779
--
Edit this bug report at http://bugs.php.net/?id=29779&edit=1
