#23204 [Opn->Fbk]: Bus Error on SQL execute to local 9.2.0.3 database

ID: 23204 Updated by: sniper@php.net Reported By: craig dot mcniel at pearson dot com -Status: Open +Status: Feedback -Bug Type: Reproducible crash +Bug Type: OCI8 related Operating System: HPUX 11.11 PHP Version: 4.3.1 New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [2003-04-14 10:22:51] craig dot mcniel at pearson dot com I have compiled PHP 4.3.1 with OCI8 against 9.2.0.3 Oracle on an HPUX box running apache 1.3.27. Everything is statically linked (required by HPUX). An application ported from PHP 4.2 on AIX and Oracle 8.1.7 that was working fine Bus Errors on the SQL statement execute. This same apache server can connect to the old remote database on AIX however, the local connection works but, as soon as the first complex statement is issued Bus Error. It is possible however, to connect and issue a statement like "select sysdate() from dual" this will return the correct results. I have a TAR open with Oracle in the event this is an Oracle bug, however from the backtrace I cannot tell what might be the underlying problem. --------------------------- Command name abbreviations are allowed if unambiguous. (gdb) backtrace #0 0xc01cb794 in memcpy () from /usr/lib/libc.2 #1 0xc48fe03c in nioqrc () from /oracle/app/oracle/product/9.2.0_64/lib32/libclntsh.sl.9.0 #2 0xc4b167c8 in $00000014 () from /oracle/app/oracle/product/9.2.0_64/lib32/libclntsh.sl.9.0 #3 0xc494f504 in nioqwa () from /oracle/app/oracle/product/9.2.0_64/lib32/libclntsh.sl.9.0 #4 0xc470e09c in upirtrc () from /oracle/app/oracle/product/9.2.0_64/lib32/libclntsh.sl.9.0 #5 0xc4780fdc in kpurcsc () from /oracle/app/oracle/product/9.2.0_64/lib32/libclntsh.sl.9.0 #6 0xc473c8a0 in kpuexecv8 () from /oracle/app/oracle/product/9.2.0_64/lib32/libclntsh.sl.9.0 #7 0xc473db04 in kpuexec () from /oracle/app/oracle/product/9.2.0_64/lib32/libclntsh.sl.9.0 #8 0xc46dfbdc in OCIStmtExecute () from /oracle/app/oracle/product/9.2.0_64/lib32/libclntsh.sl.9.0 #9 0x000a6d4c in oci_execute (statement=0x40095868, func=0x400d11e0 "\00515:08\00500:00\0232003-04-10 15:07:43\0232003-04-10 15:08:06\aNICHOLS\aORAPRD2\006OracleN/u03/wwwroot/backuplogs/oracle/nichols/backuplog_oraprd2_archive_041003_151001\vArchive Log\fTYPE_ARCHIVE\tCompleted\016STAT_COMPL"..., mode=32) at /oracle/src/php-4.3.1/ext/oci8/oci8.c:1467 #10 0x000ab884 in zif_ociexecute (ht=-1000213256, return_value=0x40095a08, this_ptr=0x339, return_value_used=16384) at /oracle/src/php-4.3.1/ext/oci8/oci8.c:3885 #11 0x0009aea4 in execute (op_array=0x4008cc10) at /oracle/src/php-4.3.1/Zend/zend_execute.c:1596 #12 0x0004e354 in zend_execute_scripts (type=8, retval=0x0, file_count=3) at /oracle/src/php-4.3.1/Zend/zend.c:864 #13 0x000476e4 in php_execute_script (primary_file=0x680f0ad8) at /oracle/src/php-4.3.1/main/main.c:1573 #14 0x00051b1c in apache_php_module_main (r=0xc461f4f8, display_source_mode=0) at /oracle/src/php-4.3.1/sapi/apache/sapi_apache.c:55 #15 0x00043a14 in send_php () from ./httpd #16 0x00043b18 in send_parsed_php () from ./httpd #17 0x00176cdc in ap_invoke_handler () from ./httpd #18 0x00196f24 in process_request_internal () from ./httpd #19 0x00196fc8 in ap_process_request () from ./httpd #20 0x0018968c in child_main () from ./httpd #21 0x001899bc in make_child () from ./httpd #22 0x00189ebc in perform_idle_server_maintenance () from ./httpd #23 0x0018a768 in standalone_main () from ./httpd #24 0x0018b298 in main () from ./httpd #25 0xc0143270 in _start () from /usr/lib/libc.2 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23204&edit=1