By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,929 Members | 634 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,929 IT Pros & Developers. It's quick & easy.

OCI create segmentation fault on Apache

P: n/a
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
[Mon Sep 11 10:49:21 2006] [notice] child pid 7287 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache
[Mon Sep 11 10:53:45 2006] [notice] child pid 7387 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache
[Mon Sep 11 10:53:46 2006] [notice] child pid 7276 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache
[Mon Sep 11 10:56:16 2006] [notice] child pid 7334 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache
[Mon Sep 11 10:59:21 2006] [notice] child pid 8138 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache
[Mon Sep 11 11:01:08 2006] [notice] child pid 6883 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache
[Mon Sep 11 11:06:04 2006] [notice] child pid 8102 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache
[Mon Sep 11 11:07:22 2006] [notice] child pid 8392 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache
[Mon Sep 11 11:07:22 2006] [notice] child pid 8652 exit signal
Segmentation fault (11), possible coredump in /opt/oracle/apache
[Mon Sep 11 11:16:18 2006] [notice] child pid 8915 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??

Sep 11 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 11 Sep 2006 06:15:17 -0700, "madunix" <ma*****@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.

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

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Sep 12 '06 #2

P: n/a
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/libInternalSymbols.so...done.
Loaded symbols for /usr/lib/libInternalSymbols.so
Reading symbols from /lib/i686/libm.so.6...done.
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...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
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...done.
Loaded symbols for /opt/oracle/apache/libexec/libphp4.so
Reading symbols from /lib/libz.so.1...done.
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...done.
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...done.
Loaded symbols for /opt/oracle/product/10gR2/lib/libnnz10.so
#0 zend_hash_find (ht=0x0, arKey=0x81c38bc "resp_charset",
nKeyLength=13, pData=0xbfffae74)
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_charset",
nKeyLength=13, pData=0xbfffae74)
at /opt/oracle/php-4.4.2/Zend/zend_hash.h:196
#1 0x40306f22 in zend_fetch_var_address (opline=0x81f6ed0,
Ts=0xbfffaea0, type=1) at /opt/oracle/php-4.4.2/Zend/zend_execute.c:594
#2 0x4030aa8b in execute (op_array=0x8199944) at
/opt/oracle/php-4.4.2/Zend/zend_execute.c:1286
#3 0x4030eb04 in execute (op_array=0x819914c) at
/opt/oracle/php-4.4.2/Zend/zend_execute.c:1719
#4 0x4030eb04 in execute (op_array=0x8259544) at
/opt/oracle/php-4.4.2/Zend/zend_execute.c:1719
#5 0x402fbfde in zend_execute_scripts (type=8, retval=0x0,
file_count=3) at /opt/oracle/php-4.4.2/Zend/zend.c:934
#6 0x402d4e1a in php_execute_script (primary_file=0xbfffea84) at
/opt/oracle/php-4.4.2/main/main.c:1753
#7 0x4031487a in apache_php_module_main (r=0x813b23c,
display_source_mode=0) at
/opt/oracle/php-4.4.2/sapi/apache/sapi_apache.c:54
#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_handler ()
#11 0x08084e6c in process_request_internal ()
#12 0x08084ee2 in ap_process_request ()
#13 0x0807aef0 in child_main ()
#14 0x0807b16a in make_child ()
#15 0x0807b518 in perform_idle_server_maintenance ()
#16 0x0807bb8c in standalone_main ()
#17 0x0807c1dc in main ()
(gdb)
Andy Hassall wrote:
On 11 Sep 2006 06:15:17 -0700, "madunix" <ma*****@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.

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

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Sep 17 '06 #3

P: n/a
On 16 Sep 2006 22:14:54 -0700, "madunix" <ma*****@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_charset",
nKeyLength=13, pData=0xbfffae74)
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_charset",
nKeyLength=13, pData=0xbfffae74)
at /opt/oracle/php-4.4.2/Zend/zend_hash.h:196
#1 0x40306f22 in zend_fetch_var_address (opline=0x81f6ed0,
Ts=0xbfffaea0, type=1) at /opt/oracle/php-4.4.2/Zend/zend_execute.c:594
#2 0x4030aa8b in execute (op_array=0x8199944) at
/opt/oracle/php-4.4.2/Zend/zend_execute.c:1286
#3 0x4030eb04 in execute (op_array=0x819914c) at
/opt/oracle/php-4.4.2/Zend/zend_execute.c:1719
#4 0x4030eb04 in execute (op_array=0x8259544) at
/opt/oracle/php-4.4.2/Zend/zend_execute.c:1719
#5 0x402fbfde in zend_execute_scripts (type=8, retval=0x0,
file_count=3) at /opt/oracle/php-4.4.2/Zend/zend.c:934
#6 0x402d4e1a in php_execute_script (primary_file=0xbfffea84) at
/opt/oracle/php-4.4.2/main/main.c:1753
#7 0x4031487a in apache_php_module_main (r=0x813b23c,
display_source_mode=0) at
/opt/oracle/php-4.4.2/sapi/apache/sapi_apache.c:54
#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_handler ()
#11 0x08084e6c in process_request_internal ()
#12 0x08084ee2 in ap_process_request ()
#13 0x0807aef0 in child_main ()
#14 0x0807b16a in make_child ()
#15 0x0807b518 in perform_idle_server_maintenance ()
#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 :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Sep 18 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.