ID: 24740 User updated by: rarteaga at icaro dot com dot ec Reported By: rarteaga at icaro dot com dot ec -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Linux RH9 and RH7.3 PHP Version: 4.3.2 New Comment:
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 Previous Comments: ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ [2003-07-21 11:54:58] rarteaga at icaro dot com dot ec Description: ------------ Hi, I've installed Linux RH 9.0 and Oracle 9i, I'm trying to access the database from a php script, I make de connection and make a simple select like this: "SELECT EMPNO from EMP" And I get the information just fine with the oci functions (OCILogon, OCIParse, OCIExecute, etc...). Now I get a segmentation fault when I try to retrieve information of fields that are string or characteres, something like this: "SELECT JOB from EMP" The script crashes and dies saying "segmentation fault" I'm connecting to the database as user "SCOTT" and getting information from table EMP. I can connect from an aplication I've developed in VB60 from a remote aplication server I have... but PHP is crashing... Best Regards Reproduce code: --------------- #!/usr/bin/php -q <?php putenv("ORACLE_HOME=/opt/oracle/product/9.2.0"); $username = "SCOTT"; $passwd = "TIGER"; $db="icaro"; $conn = OCILogon($username,$passwd,$db); if (!$conn) { echo "Connection failed"; echo "Error Message: [" . OCIError($conn) . "]"; exit; } else { echo "Connected!"."\n"; $parse = OCIParse($conn,"select JOB from EMP"); OCIDefineByName($parse,"ENAME",$job); OCIExecute($parse,OCI_DEFAULT); echo "\nRecuperacion de datos\n"; while (OCIFetchinto ($parse, $row, OCI_ASSOC)) { echo $job; echo "\n"; } } ?> Expected result: ---------------- I expect to see de job titles.. Actual result: -------------- [EMAIL PROTECTED] htdocs]# ./oracle.php Connected! Segmentation fault ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=24740&edit=1
