php.net |  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
Have you experienced this issue?
Rate the importance of this bug to you:

 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Sun Jul 21 07:01:28 2024 UTC