#41069 [Bgs]: segfault when running a large query over dblink
ID: 41069
Updated by: sixd@php.net
Reported By: brian dot kao at gateway dot com
Status: Bogus
Bug Type: OCI8 related
Operating System: linux
PHP Version: 5.2.1
New Comment:
One potential workaround is to modify php_oci_statement_set_prefetch()
in oci8_statement.c and comment out either the lines that set the
prefetch memory limit, or comment out the lines that set the prefetch
row limit. In my testing the crash only occurred when both memory and
row limits were set (and you use a DB link and you have the right data
to trigger the crash). Confirmation or contradiction welcome.
Previous Comments:
------------------------------------------------------------------------
[2007-05-10 02:27:16] brian dot kao at gateway dot com
Thanks to the help from Chirstopher Jones, an Oracle/PHP consultant,
Oracle is logging a bug for this issue. For anyone having the same
issue, the bug id is 6039623. Hopefully, Oracle will have a fix soon.
------------------------------------------------------------------------
[2007-04-20 07:13:23] tony2001@php.net
>Oracle has closed the SR stating that since the database link works
>with sqlplus that the issue is with PHP which Oracle does not
support.
Are you sure SQLPlus uses the same client library?
>The database does not need a patch since there is no issue with the
>database link on the Oracle database side
I'm aware of similar issues, see the last comment here:
http://bugs.php.net/bug.php?id=36607
------------------------------------------------------------------------
[2007-04-19 21:48:13] brian dot kao at gateway dot com
Tony,
Our Oracle DBA tried reporting this issue to Oracle Support, but they
came back to us and say this is not an Oracle issue.
Here's the message I've received from our Oracle DBA:
"Oracle has closed the SR stating that since the database link works
with sqlplus that the issue is with PHP which Oracle does not support.
The database does not need a patch since there is no issue with the
database link on the Oracle database side."
Are you aware of any workaround for this issue?
------------------------------------------------------------------------
[2007-04-13 08:07:19] tony2001@php.net
>could this be a PHP OCI8 driver issue?
I'm saying it knows nothing of dblink.
>What is your recommendation for this issue, going to Oracle support?
Yes.
------------------------------------------------------------------------
[2007-04-13 08:00:41] brian dot kao at gateway dot com
could this be a PHP OCI8 driver issue?
If I limit the number of records returned, the query would run without
any issue. This only happens when running a large query over dblink.
What is your recommendation for this issue, going to Oracle support?
------------------------------------------------------------------------
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/41069
--
Edit this bug report at http://bugs.php.net/?id=41069&edit=1
Thread (9 messages)