php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: ms at e-kazan dot ru
New email:
PHP Version: OS:

 

 [2007-04-11 03:11 UTC] ms at e-kazan dot ru 
Description:
------------
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';

Patches

Pull Requests

History

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 
Code:
$con = oci_connect('user', 'pass', 'db');
$stmt = oci_parse($con, "select * from table@db_link");
oci_execute($stmt);
oci_fetch_all($stmt, $results);
print_r($results);

Backtrace:
#0  0x014ecb40 in ttcfopr () from /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
#1  0x014e3ba4 in ttcdrv () from /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
#2  0x013c8bc8 in nioqwa () from /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
#3  0x01234618 in upirtrc () from /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
#4  0x011a95f6 in kpurcsc () from /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
#5  0x0115d8b8 in kpuexecv8 () from /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
#6  0x0115fec4 in kpuexec () from /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
#7  0x012391b6 in OCIStmtExecute () from /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1
#8  0x002c4a96 in php_oci_statement_execute () from /usr/lib/php/extensions/oci8.so
#9  0x002cc4ed in zif_oci_execute () from /usr/lib/php/extensions/oci8.so
#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 http://bugs.php.net/bug.php?id=36607
 [2007-04-13 07:37 UTC] ms at e-kazan dot ru 
Both sides have Oracle 10.2.0.1.0 on CentOS 4.4, InstantClient 10.2.0.3-1
 [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 
See http://bugs.php.net/bug.php?id=41069
 [2012-10-26 05:41 UTC] sixd@php.net
-Status: Feedback +Status: No Feedback -Package: oci8 +Package: *General Issues
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Mon May 05 03:01:31 2025 UTC