ID: 47118 User updated by: holger at noefer dot org Reported By: holger at noefer dot org Status: Open Bug Type: OCI8 related Operating System: Solaris 8 PHP Version: 5.2.8 New Comment:
Hello, I changed oci8.default_prefetch from 10 to 100. The segmentation faults seems to be fewer than before. Perhaps it is related to this bug? http://bugs.php.net/bug.php?id=41069 Best regards, Holger Previous Comments: ------------------------------------------------------------------------ [2009-01-30 15:04:24] holger at noefer dot org Hello, sorry for the long time I did not respond to the bug but it is hard to aim the bug. The bug seems to appear when I use persistent connections. Here are the default settings in php.ini oci8.default_prefetch => 10 => 10 oci8.max_persistent => -1 => -1 oci8.old_oci_close_semantics => 0 => 0 oci8.persistent_timeout => -1 => -1 oci8.ping_interval => 60 => 60 oci8.privileged_connect => Off => Off oci8.statement_cache_size => 20 => 20 Should the oci8.persistent_timeout be changed? I will try to post some code next week. Best regards, Holger ------------------------------------------------------------------------ [2009-01-23 01:00:08] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2009-01-15 21:46:24] s...@php.net Please help narrow down the problem with the aim of supplying a reproducable testcase. Look at patterns in the frequency of crash, the statement(s) that crash, and the environment (machine, environment variables, build options, connection etc) that causes the crash. ------------------------------------------------------------------------ [2009-01-15 20:13:24] holger at noefer dot org Description: ------------ Hello, we have a problem with PHP and Oracle. The versions are the following: php 5.2.8 (latest) Latest Oracle Instant Client 10.2.0.4.0 (latest) Apache 1.3.37 ./configure \ --prefix=/opt/php-5.2.8 \ --with-apxs=/opt/apache-content/bin/apxs \ --with-mysql=/opt/mysql-for-php5 \ --enable-shmop \ --enable-sysvsem \ --enable-ftp \ --enable-sysvshm \ --with-oci8=instantclient,/usr/oracle_instant/instantclient_10_2 \ --with-freetype-dir=/opt/lib \ --with-zlib-dir=/opt/lib \ --with-jpeg-dir=/opt/lib \ --with-gd \ --with-gettext \ --with-iconv-dir [Thu Jan 15 20:46:09 2009] [notice] child pid 13292 exit signal Segmentation Fault (11) [13289] EACCELERATOR: PHP crashed on opline 69 of ociexecute() at /www/vhost/inc/ticker/artikel.inc.php:755 [Thu Jan 15 20:46:16 2009] [notice] child pid 13289 exit signal Segmentation Fault (11) [13902] EACCELERATOR: PHP crashed on opline 69 of ociexecute() at /www/vhost/inc/ticker/artikel.inc.php:755 [Thu Jan 15 20:46:17 2009] [notice] child pid 13902 exit signal Segmentation Fault (11) [13278] EACCELERATOR: PHP crashed on opline 141 of ociexecute() at /www/vhost/inc/ticker/dpaticker.inc.php:77 PHP seems to crash on ociexecute. If I disable eaccelerator and Zend optimiser the problem is the same. Best regards and thanks for help, Holger Actual result: -------------- server:/opt/apache-content/coredump # gdb /opt/apache-content/libexec/libhttpd.ep core GNU gdb 6.6 Copyright (C) 2006 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "sparc-sun-solaris2.8"... Reading symbols from /opt/apache-content/libexec/libhttpd.so...done. Loaded symbols for /opt/apache-content/libexec/libhttpd.so Reading symbols from /opt/BerkeleyDB.3.3/lib/libdb-3.3.so...done. Loaded symbols for /usr/local/BerkeleyDB.3.3/lib/libdb-3.3.so Reading symbols from /usr/lib/libsocket.so.1...done. Loaded symbols for /usr/lib/libsocket.so.1 Reading symbols from /usr/lib/libnsl.so.1...done. Loaded symbols for /usr/lib/libnsl.so.1 Reading symbols from /usr/lib/libpthread.so.1...done. Loaded symbols for /usr/lib/libpthread.so.1 Reading symbols from /opt/lib/libexpat.so.0...done. Loaded symbols for /opt/lib/libexpat.so.0 Reading symbols from /usr/lib/libdl.so.1...done. Loaded symbols for /usr/lib/libdl.so.1 Reading symbols from /usr/lib/libc.so.1...done. Loaded symbols for /usr/lib/libc.so.1 Reading symbols from /usr/lib/libmp.so.2...done. Loaded symbols for /usr/lib/libmp.so.2 Reading symbols from /usr/platform/SUNW,Sun-Fire-880/lib/libc_psr.so.1...done. Loaded symbols for /usr/platform/SUNW,Sun-Fire-880/lib/libc_psr.so.1 Reading symbols from /usr/lib/libthread.so.1...done. Loaded symbols for /usr/lib/libthread.so.1 Reading symbols from /usr/lib/nss_files.so.1...done. Loaded symbols for /usr/lib/nss_files.so.1 Reading symbols from /opt/apache-content/libexec/mod_env.so...done. Loaded symbols for /opt/apache-content/libexec/mod_env.so Reading symbols from /opt/apache-content/libexec/mod_log_config.so...done. Loaded symbols for /opt/apache-content/libexec/mod_log_config.so Reading symbols from /opt/apache-content/libexec/mod_mime.so...done. Loaded symbols for /opt/apache-content/libexec/mod_mime.so Reading symbols from /opt/apache-content/libexec/mod_status.so...done. Loaded symbols for /opt/apache-content/libexec/mod_status.so Reading symbols from /opt/apache-content/libexec/mod_dir.so...done. Loaded symbols for /opt/apache-content/libexec/mod_dir.so Reading symbols from /opt/apache-content/libexec/mod_cgi.so...done. Loaded symbols for /opt/apache-content/libexec/mod_cgi.so Reading symbols from /opt/apache-content/libexec/libproxy.so...done. Loaded symbols for /opt/apache-content/libexec/libproxy.so Reading symbols from /opt/apache-content/libexec/mod_alias.so...done. Loaded symbols for /opt/apache-content/libexec/mod_alias.so Reading symbols from /opt/apache-content/libexec/mod_rewrite.so...done. Loaded symbols for /opt/apache-content/libexec/mod_rewrite.so Reading symbols from /opt/apache-content/libexec/mod_access.so...done. Loaded symbols for /opt/apache-content/libexec/mod_access.so Reading symbols from /opt/apache-content/libexec/mod_auth.so...done. Loaded symbols for /opt/apache-content/libexec/mod_auth.so Reading symbols from /opt/apache-content/libexec/mod_setenvif.so...done. Loaded symbols for /opt/apache-content/libexec/mod_setenvif.so Reading symbols from /opt/apache-content/libexec/libssl.so...done. Loaded symbols for /opt/apache-content/libexec/libssl.so Reading symbols from /opt/openssl/lib/libssl.so.0.9.8...done. Loaded symbols for /opt/openssl/lib/libssl.so.0.9.8 Reading symbols from /opt/openssl/lib/libcrypto.so.0.9.8...done. Loaded symbols for /opt/openssl/lib/libcrypto.so.0.9.8 Reading symbols from /opt/lib/libgcc_s.so.1...done. Loaded symbols for /opt/lib/libgcc_s.so.1 Reading symbols from /opt/apache-content/libexec/libphp5.so...done. Loaded symbols for /opt/apache-content/libexec/libphp5.so Reading symbols from /usr/lib/librt.so.1...done. Loaded symbols for /usr/lib/librt.so.1 Reading symbols from /opt/mysql-5.0.67-solaris8-sparc/lib/libmysqlclient.so.15...done. Loaded symbols for /opt/mysql-for-php5/lib/libmysqlclient.so.15 Reading symbols from /usr/lib/libintl.so.1... warning: Lowest section in /usr/lib/libintl.so.1 is .hash at 00000074 done. Loaded symbols for /usr/lib/libintl.so.1 Reading symbols from /opt/lib/libfreetype.so.6...done. Loaded symbols for /opt/lib/libfreetype.so.6 Reading symbols from /opt/lib/libpng.so.3...done. Loaded symbols for /opt/lib/libpng.so.3 Reading symbols from /opt/lib/libz.so...done. Loaded symbols for /opt/lib/libz.so Reading symbols from /opt/lib/libjpeg.so.62...done. Loaded symbols for /opt/lib/libjpeg.so.62 Reading symbols from /usr/lib/libresolv.so.2...done. Loaded symbols for /usr/lib/libresolv.so.2 Reading symbols from /usr/lib/libm.so.1...done. Loaded symbols for /usr/lib/libm.so.1 Reading symbols from /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1...done. Loaded symbols for /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1 Reading symbols from /opt/lib/libxml2.so.2...done. Loaded symbols for /opt/lib/libxml2.so.2 Reading symbols from /opt/lib/libiconv.so.2...done. Loaded symbols for /opt/lib/libiconv.so.2 Reading symbols from /usr/lib/libaio.so.1...done. Loaded symbols for /usr/lib/libaio.so.1 Reading symbols from /usr/lib/libgen.so.1...done. Loaded symbols for /usr/lib/libgen.so.1 Reading symbols from /usr/oracle_instant/instantclient_10_2/libnnz10.so...done. Loaded symbols for /usr/oracle_instant/instantclient_10_2/libnnz10.so Reading symbols from /usr/lib/libkstat.so.1...done. Loaded symbols for /usr/lib/libkstat.so.1 Reading symbols from /usr/lib/libsched.so.1...done. Loaded symbols for /usr/lib/libsched.so.1 Reading symbols from /opt/php-5.2.8/lib/php/extensions/saprfc.so...done. Loaded symbols for /opt/php-5.2.8/lib/php/extensions/saprfc.so Reading symbols from /usr/sap/rfcsdk/lib/librfccm.so...done. Loaded symbols for /usr/sap/rfcsdk/lib/librfccm.so Reading symbols from /usr/lib/libw.so.1... warning: Lowest section in /usr/lib/libw.so.1 is .hash at 00000074 done. Loaded symbols for /usr/lib/libw.so.1 Reading symbols from /opt/php-5.2.8/lib/php/extensions/libpdf_php.so...done. Loaded symbols for /opt/php-5.2.8/lib/php/extensions/libpdf_php.so Reading symbols from /opt/php-5.2.8/lib/php/extensions/eaccelerator.so...done. Loaded symbols for /opt/php-5.2.8/lib/php/extensions/eaccelerator.so Reading symbols from /usr/oracle_instant/instantclient_10_2/libociei.so...done. Loaded symbols for /usr/oracle_instant/instantclient_10_2/libociei.so Reading symbols from /usr/lib/locale/de/de.so.2...done. Loaded symbols for /usr/lib/locale/de/de.so.2 Reading symbols from /usr/lib/ld.so.1...done. Loaded symbols for /lib/ld.so.1 Core was generated by `/opt/apache-content/bin/httpd -R /opt/apache-content/libexec -f /opt/apache-con'. Program terminated with signal 11, Segmentation fault. #0 0xff0991f0 in __sigprocmask () from /usr/lib/libthread.so.1 (gdb) bt #0 0xff0991f0 in __sigprocmask () from /usr/lib/libthread.so.1 #1 0xff08e574 in _resetsig () from /usr/lib/libthread.so.1 #2 0xff08dd14 in _sigon () from /usr/lib/libthread.so.1 #3 0xff090d54 in _thrp_kill () from /usr/lib/libthread.so.1 #4 0xff098d50 in kill () from /usr/lib/libthread.so.1 #5 0xff328d34 in sig_coredump () from /opt/apache-content/libexec/libhttpd.so #6 <signal handler called> #7 0xff0991f0 in __sigprocmask () from /usr/lib/libthread.so.1 #8 0xff08e574 in _resetsig () from /usr/lib/libthread.so.1 #9 0xff08dd14 in _sigon () from /usr/lib/libthread.so.1 #10 0xff090d54 in _thrp_kill () from /usr/lib/libthread.so.1 #11 0xff098d50 in kill () from /usr/lib/libthread.so.1 #12 <signal handler called> #13 0xfcdd2e94 in ttcfopr () from /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1 #14 0xfcdc81a0 in ttcdrv () from /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1 #15 0xfcc7030c in nioqwa () from /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1 #16 0xfcab0718 in upirtrc () from /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1 #17 0xfca1d150 in kpurcsc () from /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1 #18 0xfc9bad7c in kpuexecv8 () from /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1 #19 0xfc9bd420 in kpuexec () from /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1 #20 0xfca75004 in OCIStmtExecute () from /usr/oracle_instant/instantclient_10_2/libclntsh.so.10.1 #21 0xfe54b804 in php_oci_statement_execute (statement=0xc3058, mode=32) at /home/user/php5-new/php-5.2.8/ext/oci8/oci8_statement.c:442 #22 0xfe552d98 in zif_oci_execute (ht=798808, return_value=0xaf5d18, return_value_ptr=0x0, this_ptr=0x0, return_value_used=1) at /home/user/php5-new/php-5.2.8/ext/oci8/oci8_interface.c:1302 #23 0xfe6eec80 in zend_do_fcall_common_helper_SPEC (execute_data=0xffbea828) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:200 #24 0xfe6ee418 in execute (op_array=0x926f70) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:92 #25 0xfe6eea30 in zend_do_fcall_common_helper_SPEC (execute_data=0xffbeab80) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:234 #26 0xfe6ee418 in execute (op_array=0x926e90) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:92 #27 0xfe6eea30 in zend_do_fcall_common_helper_SPEC (execute_data=0xffbec8e0) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:234 #28 0xfe6ee418 in execute (op_array=0x853ff8) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:92 #29 0xfe6eea30 in zend_do_fcall_common_helper_SPEC (execute_data=0xffbecb48) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:234 #30 0xfe6ee418 in execute (op_array=0xa29e08) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:92 #31 0xfe6f7b40 in ZEND_INCLUDE_OR_EVAL_SPEC_TMP_HANDLER (execute_data=0xffbed4f0) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:4662 #32 0xfe6ee418 in execute (op_array=0xa4e3f8) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:92 #33 0xfe6f7b40 in ZEND_INCLUDE_OR_EVAL_SPEC_TMP_HANDLER (execute_data=0xffbedec8) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:4662 #34 0xfe6ee418 in execute (op_array=0xb4b60) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:92 #35 0xfe6f7b40 in ZEND_INCLUDE_OR_EVAL_SPEC_TMP_HANDLER (execute_data=0xffbeea00) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:4662 #36 0xfe6ee418 in execute (op_array=0xb30b0) at /home/user/php5-new/php-5.2.8/Zend/zend_vm_execute.h:92 #37 0xfe6d1f70 in zend_execute_scripts (type=8, retval=0x0, file_count=3) at /home/user/php5-new/php-5.2.8/Zend/zend.c:1134 #38 0xfe68f290 in php_execute_script (primary_file=0xffbef098) at /home/user/php5-new/php-5.2.8/main/main.c:2023 #39 0xfe748800 in apache_php_module_main (r=0xffbef080, display_source_mode=0) at /home/user/php5-new/php-5.2.8/sapi/apache/sapi_apache.c:53 #40 0xfe7494f8 in send_php (r=0x8d2b8, display_source_mode=0, filename=0x0) at /home/user/php5-new/php-5.2.8/sapi/apache/mod_php5.c:664 #41 0xfe749634 in send_parsed_php (r=0x8d2b8) at /home/user/php5-new/php-5.2.8/sapi/apache/mod_php5.c:679 #42 0xff31518c in ap_invoke_handler () from /opt/apache-content/libexec/libhttpd.so #43 0xff33b600 in process_request_internal () from /opt/apache-content/libexec/libhttpd.so #44 0xff33b69c in ap_process_request () from /opt/apache-content/libexec/libhttpd.so #45 0xff32bbdc in child_main () from /opt/apache-content/libexec/libhttpd.so #46 0xff32c010 in make_child () from /opt/apache-content/libexec/libhttpd.so #47 0xff32c14c in startup_children () from /opt/apache-content/libexec/libhttpd.so #48 0xff32cdf0 in standalone_main () from /opt/apache-content/libexec/libhttpd.so #49 0xff32dd04 in ap_main () from /opt/apache-content/libexec/libhttpd.so #50 0x0001075c in main () (gdb) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=47118&edit=1
