|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #57619 Segmentation fault when oci8.default_prefetch greater than 0
Submitted: 2007-04-11 03:11 UTC Modified: 2012-10-26 05:41 UTC
From: ms at e-kazan dot ru Assigned:
Status: No Feedback Package: *General Issues
PHP Version: 5.2.1 OS: CentOS release 4.4 (Final)
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: ms at e-kazan dot ru
New email:
PHP Version: OS:


 [2007-04-11 03:11 UTC] ms at e-kazan dot ru
Segmentation fault occurs when doing a SELECT query using database link and oci8.default_prefetch is greater than 0

Reproduce code:
SELECT * FROM table@db_link;

db_link is created like that:
create database link "db_link"
connect to remote_database
identified by "<pwd>"
using 'SID';


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2007-04-11 03:30 UTC] ms at e-kazan dot ru
PHP version corrected - 5.2.1, not 5.1.0
 [2007-04-11 09:48 UTC] tony2001 at phpclub dot net
Please provide a short but complete reproduce case.
 [2007-04-12 07:45 UTC] tony2001 at phpclub dot net
Also GDB backtrace would be useful, since I don't think it's PHP or PECL/oci8 problem if it's only reproducible when using db_link.
 [2007-04-12 08:42 UTC] ms at e-kazan dot ru
$con = oci_connect('user', 'pass', 'db');
$stmt = oci_parse($con, "select * from table@db_link");
oci_fetch_all($stmt, $results);

#0  0x014ecb40 in ttcfopr () from /usr/lib/oracle/
#1  0x014e3ba4 in ttcdrv () from /usr/lib/oracle/
#2  0x013c8bc8 in nioqwa () from /usr/lib/oracle/
#3  0x01234618 in upirtrc () from /usr/lib/oracle/
#4  0x011a95f6 in kpurcsc () from /usr/lib/oracle/
#5  0x0115d8b8 in kpuexecv8 () from /usr/lib/oracle/
#6  0x0115fec4 in kpuexec () from /usr/lib/oracle/
#7  0x012391b6 in OCIStmtExecute () from /usr/lib/oracle/
#8  0x002c4a96 in php_oci_statement_execute () from /usr/lib/php/extensions/
#9  0x002cc4ed in zif_oci_execute () from /usr/lib/php/extensions/
#10 0x0829ebc4 in zend_do_fcall_common_helper_SPEC ()
#11 0x0829e208 in execute ()
#12 0x0827ec17 in zend_execute_scripts ()
#13 0x08234b20 in php_execute_script ()
#14 0x00000000 in ?? ()
 [2007-04-12 08:48 UTC] tony2001 at phpclub dot net
Yeah, exactly what I thought, some OIC bug.
 [2007-04-12 16:37 UTC] christopher dot jones at oracle dot com
What are the two Database versions and the OS's they are on?

Also see
 [2007-04-13 07:37 UTC] ms at e-kazan dot ru
Both sides have Oracle on CentOS 4.4, InstantClient
 [2007-04-13 07:52 UTC] tony2001 at phpclub dot net
Did you try applying the patch for Oracle Bug #3396162 ?
 [2007-06-18 14:14 UTC] christopher dot jones at oracle dot com
 [2012-10-26 05:41 UTC]
-Status: Feedback +Status: No Feedback -Package: oci8 +Package: *General Issues
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Jul 20 07:01:28 2024 UTC