ID: 30808
User updated by: michael dot caplan at lechateau dot ca
Reported By: michael dot caplan at lechateau dot ca
Status: Suspended
Bug Type: OCI8 related
Operating System: RHE 3
PHP Version: 5.0.2
Assigned To: tony2001
New Comment:
hi tony,
how does the mysql connect function handle this problem, or does it
ping the server each time?
Previous Comments:
------------------------------------------------------------------------
[2004-11-18 17:54:04] [EMAIL PROTECTED]
>And I don't see why a solution would necessarily depend on
pre-pinging.
I'd be glad to hear your proposal, Patrick.
------------------------------------------------------------------------
[2004-11-18 17:25:35] patrick dot lambert at noggin dot com
It would be great if this flaw in the OCI8
implementation could be resolved. It has been bugged
numerous times over the years. And I don't see why a
solution would necessarily depend on pre-pinging.
------------------------------------------------------------------------
[2004-11-18 16:59:38] michael dot caplan at lechateau dot ca
Ah, yes -- I suppose pinging every time would be a huge overhead. But,
how do other db supported by PHP (mysql for example) handle this issue?
I can most definately restart mysqld without needed to restart apache to
kill all my mysql persistant connections. The mysql library seams to
handle this without issue (or perhaps this is something that is
negotiated on the mysqld side)?
Also, perhaps I am miss understanding you, but you suggest that this
issue will be fixed in PDO OCI. If so, why cannot it be fixed in the
current OCI8 library?
Thanks,
Michael
------------------------------------------------------------------------
[2004-11-18 15:21:25] [EMAIL PROTECTED]
New ini option is needed because pinging every connection would lead to
huge overhead.
Your situation in fact is an exception, rather then a rule - most
people do not restart DB every day, so they would definitely not agree
with this slowdown.
------------------------------------------------------------------------
[2004-11-18 15:09:14] michael dot caplan at lechateau dot ca
Uncommenting the oci_ping() call does the trick. Both persitant and
non persistant connection then work after an Oracle restart.
But your reply confuses me. Why a new ini option (you mean at compile
time?)? Shouldn't this be the default behaviour? And why should I
wait till PDO for a stable way to connect to Oracle? Shouldn't this
issue be resolved in the current PHP OCI8 function library?
Thanks,
Michael
------------------------------------------------------------------------
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/30808
--
Edit this bug report at http://bugs.php.net/?id=30808&edit=1
