OCI create segmentation fault on Apache

**Andy Hassall** · Sep 12 '06, 10:35 PM

Re: OCI create segmentation fault on Apache

On 11 Sep 2006 06:15:17 -0700, "madunix" <madunix@gmail. comwrote:

>My Server is suffering bad lag (High Utlization)
>I am running on that server Oracle10g with apache_1.3.35/ php-4.4.2
>Web visitors retrieve data from the web by php calls through oci
>cobnnection from 10g release2
>PHP is configured with the following parameters
>'./configure' '--prefix=/opt/oracle/php'
>'--with-apxs=/opt/oracle/apache/bin/apxs'
>'--with-config-file-path=/opt/oracle/apache/conf' '--enable-safe-mode'
>'--enable-session' '--with-oci8=/opt/oracle/product/10gR2'
>'--enable-sigchild' '--with-zlib-dir' '--with-unixODBC=shared ,/usr'
>Apache is configured
>./configure --enable-module=so --prefix=$HOME/apache --with-port=XXXX
>I found in the apache error log the following entries
>[Mon Sep 11 10:47:32 2006] [notice] child pid 6758 exit signal
>Segmentation fault (11), possible coredump in /opt/oracle/apache
>
>I think OCI8 calls through php causes a Segmentation Fault (11) error?
>
>is it a bug, i think this hanged the DB server....... is OCI problem (
>any one faced this problem??

You need to get a core dump file in order to trace where the problem occurred.

PHP :: Generating a gdb backtrace

http://bugs.php.net/bugs-generating-backtrace.php

--
Andy Hassall :: andy@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

**madunix** · Sep 17 '06, 05:05 AM

Re: OCI create segmentation fault on Apache

i have done gdb this mu output:
oracle@king:~/apache/bingdb ~/apache/bin/httpd ~/apache/core
GNU gdb 6.3
Copyright 2004 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 "i586-suse-linux"...Using host libthread_db
library "/lib/libthread_db.so .1".

Core was generated by `/opt/oracle/apache/bin/httpd'.
Program terminated with signal 11, Segmentation fault.

warning: current_sos: Can't read pathname for load map: Input/output
error

Reading symbols from /usr/lib/libInternalSymb ols.so...done.
Loaded symbols for /usr/lib/libInternalSymb ols.so
Reading symbols from /lib/i686/libm.so.6...don e.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /lib/libcrypt.so.1.. .done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from
/opt/oracle/product/10gR2/lib/libexpat.so.0.. .done.
Loaded symbols for /opt/oracle/product/10gR2/lib/libexpat.so.0
Reading symbols from /lib/libdl.so.2...do ne.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libc.so.6...don e.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...do ne.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/i686/libpthread.so.0 ...done.
Loaded symbols for /lib/i686/libpthread.so.0
Reading symbols from /lib/libnss_files.so .2...done.
Loaded symbols for /lib/libnss_files.so .2
Reading symbols from /opt/oracle/apache/libexec/libphp4.so...do ne.
Loaded symbols for /opt/oracle/apache/libexec/libphp4.so
Reading symbols from /lib/libz.so.1...don e.
Loaded symbols for /lib/libz.so.1
Reading symbols from /lib/libresolv.so.2. ..done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...d one.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from
/opt/oracle/product/10gR2/lib/libclntsh.so.10 .1...done.
Loaded symbols for /opt/oracle/product/10gR2/lib/libclntsh.so.10 .1
Reading symbols from /opt/oracle/product/10gR2/lib/libnnz10.so...d one.
Loaded symbols for /opt/oracle/product/10gR2/lib/libnnz10.so
#0 zend_hash_find (ht=0x0, arKey=0x81c38bc "resp_chars et",
nKeyLength=13, pData=0xbfffae7 4)
at /opt/oracle/php-4.4.2/Zend/zend_hash.h:196
196 while (arKey < arEnd) {
(gdb) bt
#0 zend_hash_find (ht=0x0, arKey=0x81c38bc "resp_chars et",
nKeyLength=13, pData=0xbfffae7 4)
at /opt/oracle/php-4.4.2/Zend/zend_hash.h:196
#1 0x40306f22 in zend_fetch_var_ address (opline=0x81f6e d0,
Ts=0xbfffaea0, type=1) at /opt/oracle/php-4.4.2/Zend/zend_execute.c: 594
#2 0x4030aa8b in execute (op_array=0x819 9944) at
/opt/oracle/php-4.4.2/Zend/zend_execute.c: 1286
#3 0x4030eb04 in execute (op_array=0x819 914c) at
/opt/oracle/php-4.4.2/Zend/zend_execute.c: 1719
#4 0x4030eb04 in execute (op_array=0x825 9544) at
/opt/oracle/php-4.4.2/Zend/zend_execute.c: 1719
#5 0x402fbfde in zend_execute_sc ripts (type=8, retval=0x0,
file_count=3) at /opt/oracle/php-4.4.2/Zend/zend.c:934
#6 0x402d4e1a in php_execute_scr ipt (primary_file=0 xbfffea84) at
/opt/oracle/php-4.4.2/main/main.c:1753
#7 0x4031487a in apache_php_modu le_main (r=0x813b23c,
display_source_ mode=0) at
/opt/oracle/php-4.4.2/sapi/apache/sapi_apache.c:5 4
#8 0x40315343 in send_php (r=0x813b23c, display_source_ mode=0,
filename=0x0) at /opt/oracle/php-4.4.2/sapi/apache/mod_php4.c:627
#9 0x40315396 in send_parsed_php (r=0x813b23c) at
/opt/oracle/php-4.4.2/sapi/apache/mod_php4.c:642
#10 0x0806d249 in ap_invoke_handl er ()
#11 0x08084e6c in process_request _internal ()
#12 0x08084ee2 in ap_process_requ est ()
#13 0x0807aef0 in child_main ()
#14 0x0807b16a in make_child ()
#15 0x0807b518 in perform_idle_se rver_maintenanc e ()
#16 0x0807bb8c in standalone_main ()
#17 0x0807c1dc in main ()
(gdb)
Andy Hassall wrote:

On 11 Sep 2006 06:15:17 -0700, "madunix" <madunix@gmail. comwrote:
>

My Server is suffering bad lag (High Utlization)
I am running on that server Oracle10g with apache_1.3.35/ php-4.4.2
Web visitors retrieve data from the web by php calls through oci
cobnnection from 10g release2
PHP is configured with the following parameters
'./configure' '--prefix=/opt/oracle/php'
'--with-apxs=/opt/oracle/apache/bin/apxs'
'--with-config-file-path=/opt/oracle/apache/conf' '--enable-safe-mode'
'--enable-session' '--with-oci8=/opt/oracle/product/10gR2'
'--enable-sigchild' '--with-zlib-dir' '--with-unixODBC=shared ,/usr'
Apache is configured
./configure --enable-module=so --prefix=$HOME/apache --with-port=XXXX
I found in the apache error log the following entries
[Mon Sep 11 10:47:32 2006] [notice] child pid 6758 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache

I think OCI8 calls through php causes a Segmentation Fault (11) error?

is it a bug, i think this hanged the DB server....... is OCI problem (
any one faced this problem??

>
You need to get a core dump file in order to trace where the problem occurred.
>

PHP :: Generating a gdb backtrace

http://bugs.php.net/bugs-generating-backtrace.php

>
--
Andy Hassall :: andy@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

**Andy Hassall** · Sep 18 '06, 07:35 PM

Re: OCI create segmentation fault on Apache

On 16 Sep 2006 22:14:54 -0700, "madunix" <madunix@gmail. comwrote:

>i have done gdb this mu output:
>oracle@king: ~/apache/bingdb ~/apache/bin/httpd ~/apache/core
>GNU gdb 6.3

>#0 zend_hash_find (ht=0x0, arKey=0x81c38bc "resp_chars et",
>nKeyLength=1 3, pData=0xbfffae7 4)
at /opt/oracle/php-4.4.2/Zend/zend_hash.h:196
>196 while (arKey < arEnd) {
>(gdb) bt
>#0 zend_hash_find (ht=0x0, arKey=0x81c38bc "resp_chars et",
>nKeyLength=1 3, pData=0xbfffae7 4)
at /opt/oracle/php-4.4.2/Zend/zend_hash.h:196
>#1 0x40306f22 in zend_fetch_var_ address (opline=0x81f6e d0,
>Ts=0xbfffaea 0, type=1) at /opt/oracle/php-4.4.2/Zend/zend_execute.c: 594
>#2 0x4030aa8b in execute (op_array=0x819 9944) at
>/opt/oracle/php-4.4.2/Zend/zend_execute.c: 1286
>#3 0x4030eb04 in execute (op_array=0x819 914c) at
>/opt/oracle/php-4.4.2/Zend/zend_execute.c: 1719
>#4 0x4030eb04 in execute (op_array=0x825 9544) at
>/opt/oracle/php-4.4.2/Zend/zend_execute.c: 1719
>#5 0x402fbfde in zend_execute_sc ripts (type=8, retval=0x0,
>file_count=3 ) at /opt/oracle/php-4.4.2/Zend/zend.c:934
>#6 0x402d4e1a in php_execute_scr ipt (primary_file=0 xbfffea84) at
>/opt/oracle/php-4.4.2/main/main.c:1753
>#7 0x4031487a in apache_php_modu le_main (r=0x813b23c,
>display_source _mode=0) at
>/opt/oracle/php-4.4.2/sapi/apache/sapi_apache.c:5 4
>#8 0x40315343 in send_php (r=0x813b23c, display_source_ mode=0,
>filename=0x0 ) at /opt/oracle/php-4.4.2/sapi/apache/mod_php4.c:627
>#9 0x40315396 in send_parsed_php (r=0x813b23c) at
>/opt/oracle/php-4.4.2/sapi/apache/mod_php4.c:642
>#10 0x0806d249 in ap_invoke_handl er ()
>#11 0x08084e6c in process_request _internal ()
>#12 0x08084ee2 in ap_process_requ est ()
>#13 0x0807aef0 in child_main ()
>#14 0x0807b16a in make_child ()
>#15 0x0807b518 in perform_idle_se rver_maintenanc e ()
>#16 0x0807bb8c in standalone_main ()
>#17 0x0807c1dc in main ()

Doesn't appear to have crashed in the OCI8 code - which may mean it's a bug
elsewhere (the variable names look like something to do with the response
characterset), or a previous request corrupted memory and it's only showing up
on a subsequent request (in which case it'll be a pain to find), or something
else.

Does it reproduce on the latest version of that branch? (4.4.4)

--
Andy Hassall :: andy@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

OCI create segmentation fault on Apache

OCI create segmentation fault on Apache

Comment

Comment

Comment