ID: 24740
Comment by: nicola dot martin at gsquadro dot com
Reported By: rarteaga at icaro dot com dot ec
Status: Open
Bug Type: OCI8 related
Operating System: Linux RH9 and RH7.3
PHP Version: 4.3.2
New Comment:
On RH 9 with PHP 4.2.2 and Oracle 9i the following example:
<?php
require_once 'DB.php';
$debug= 2;
$persistent = false;
$dsn = 'oci8://csl2:[EMAIL PROTECTED]/';
$_db_conn = DB::connect($dsn, array('debug' => $debug,
'persistent' => $persistent));
if (DB::isError($_db_conn)) {
die ($_db_conn->getMessage());
}
$sql =' select titolo from users ';
$query = $_db_conn->query($sql);
if(DB::iserror($query)){
die($query->getMessage());
}
$rows_arr=array();
while($query->fetchInto($row, DB_FETCHMODE_ASSOC)){
array_push($rows_arr, $row['TITOLO']);
}
$query->free();
foreach ($rows_arr as $key => $rows ){
echo "$key => ".$rows."\n";
}
$_db_conn->disconnect();
?>
After the end of script get me "Segmentation fault".
Previous Comments:
------------------------------------------------------------------------
[2003-07-22 11:59:20] rarteaga at icaro dot com dot ec
Still not working, I downloaded and run the script with the CVS
snapshot:
http://snaps.php.net/php4-STABLE-latest.tar.gz
The backtrace I get:
Starting program: /usr/bin/php oracle.php
[New Thread 1084011968 (LWP 12585)]
Content-type: text/html
X-Powered-By: PHP/4.3.3RC2-dev
Connected!
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1084011968 (LWP 12585)]
0x4207bfea in memcpy () from /lib/tls/libc.so.6
(gdb) bt
#0 0x4207bfea in memcpy () from /lib/tls/libc.so.6
#1 0x40406a13 in nioqrc () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#2 0x40538395 in ttcdrv () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#3 0x4040d1a8 in nioqwa () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#4 0x40261330 in upirtrc () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#5 0x4022393a in kpurcsc () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#6 0x401e6124 in kpuexecv8 () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#7 0x401e7cf7 in kpuexec () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#8 0x4024598f in OCIStmtExecute () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#9 0x08083efd in oci_execute (statement=0x822c014, func=0x817d0d6
"OCIExecute", mode=32)
at /usr/local/php4-STABLE-200307221530/ext/oci8/oci8.c:1491
#10 0x0808a1c0 in zif_ociexecute (ht=1, return_value=0x822bf94,
this_ptr=0x0, return_value_used=0)
at /usr/local/php4-STABLE-200307221530/ext/oci8/oci8.c:3972
#11 0x0816fbc7 in execute (op_array=0x81ff58c) at
/usr/local/php4-STABLE-200307221530/Zend/zend_execute.c:1616
#12 0x08160182 in zend_execute_scripts (type=8, retval=0x0,
file_count=3)
at /usr/local/php4-STABLE-200307221530/Zend/zend.c:885
#13 0x08130aec in php_execute_script (primary_file=0xbfffdc90) at
/usr/local/php4-STABLE-200307221530/main/main.c:1685
#14 0x08175ead in main (argc=2, argv=0xbfffdd34) at
/usr/local/php4-STABLE-200307221530/sapi/cgi/cgi_main.c:1542
#15 0x42015504 in __libc_start_main () from /lib/tls/libc.so.6
------------------------------------------------------------------------
[2003-07-22 10:33:12] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php4-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
AFAIK, this is fixed already.
------------------------------------------------------------------------
[2003-07-21 22:18:01] rarteaga at icaro dot com dot ec
Here's the backtrace
Starting program: /usr/bin/php oracle.php
[New Thread 1084011968 (LWP 31640)]
Content-type: text/html
X-Powered-By: PHP/4.3.2
Connected!
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1084011968 (LWP 31640)]
0x4207bfea in memcpy () from /lib/tls/libc.so.6
(gdb) bt
#0 0x4207bfea in memcpy () from /lib/tls/libc.so.6
#1 0x40406a13 in nioqrc () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#2 0x40538395 in ttcdrv () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#3 0x4040d1a8 in nioqwa () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#4 0x40261330 in upirtrc ()
from /opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#5 0x4022393a in kpurcsc ()
from /opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#6 0x401e6124 in kpuexecv8 ()
from /opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#7 0x401e7cf7 in kpuexec ()
from /opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#8 0x4024598f in OCIStmtExecute ()
from /opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#9 0x080838d9 in oci_execute (statement=0x8223004,
func=0x81750f6 "OCIExecute", mode=32)
at /usr/local/php-4.3.2/ext/oci8/oci8.c:1491
#10 0x08089b9c in zif_ociexecute (ht=1, return_value=0x8222f84,
this_ptr=0x0,
return_value_used=0) at /usr/local/php-4.3.2/ext/oci8/oci8.c:3975
#11 0x0816809f in execute (op_array=0x81f65c4)
at /usr/local/php-4.3.2/Zend/zend_execute.c:1606
#12 0x081586f8 in zend_execute_scripts (type=8, retval=0x0,
file_count=3)
at /usr/local/php-4.3.2/Zend/zend.c:869
---Type <return> to continue, or q <return> to quit---
#13 0x081292ca in php_execute_script (primary_file=0xbfffeb20)
at /usr/local/php-4.3.2/main/main.c:1671
#14 0x0816e207 in main (argc=2, argv=0xbfffebc4)
at /usr/local/php-4.3.2/sapi/cgi/cgi_main.c:1501
#15 0x42015504 in __libc_start_main () from /lib/tls/libc.so.6
Regards
Rafa...
------------------------------------------------------------------------
[2003-07-21 16:59:21] [EMAIL PROTECTED]
Could you please generate a backttrace from the crash?
------------------------------------------------------------------------
[2003-07-21 11:58:21] rarteaga at icaro dot com dot ec
I'm sorry I made a mistake on the line
OCIDefineByName($parse,"ENAME",$job);
The correct value must be JOB, it will be like this:
OCIDefineByName($parse,"JOB",$job);
Still doesn't work..
Regards
------------------------------------------------------------------------
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/24740
--
Edit this bug report at http://bugs.php.net/?id=24740&edit=1
