Re: Bug #12431 [Com]: ping functionality is broken

jeff_dafoe at harte-hanks dot com wrote:

Edit report at http://pecl.php.net/bugs/bug.php?id=12431&edit=1

 ID:               12431
 Comment by:       jeff_dafoe at harte-hanks dot com
 Reported By:      david at acz dot org
 Status:           Open
 Id:               12431
 Type:             Bug
 Package:          oci8

Operating System: SuSE Linux

 PHP Version:      5.2.1

New Comment: We are having the same issue here. Looks like this was introduced in 1.2.0 when OCIPing was replaced with OCIServerVersion. It's nearly impossble to work around this issue, from php-space we don't have a way to force the bad connections to reconnect. Restarting the http process seems to be the only option. If OCIServerVersion can succeed without a logged-in connection, then OCIServerVersion can't be used to test the connection status. I agree with Tony that the problem is on the Oracle side, so PHP OCI8 should revert back to using OCIPing and the systems who cannot use OCIPing need to address the issue through Oracle. FWIW, we have been using the PHP OCI implementation for over 5 years, 3 of which were against Oracle 8i on HP-UX, and the PHP OCI library's use of OCIPing never caused our server to crash.

Jeff, As you saw from Tony's subsequent update, I merged a patch to PHP 5.3 on Friday that uses OCIPing. I'll be merging this to PHP 6 and creating a PECL snapshot today. It won't be merged to PHP 5.2. Can you give an example of why you think the Ping problem is on the Oracle side? I.e. what's the testcase that causes a problem and what is the problem? Chris -- Christopher Jones, Oracle Email: christopher.jones@oracle.com Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jad