ID: 26393
User updated by: troy dot tinnes at motorola dot com
Reported By: troy dot tinnes at motorola dot com
Status: Bogus
Bug Type: OCI8 related
Operating System: Solaris 2.8
PHP Version: 4.3.4
New Comment:
Can we perhaps keep this one open and close the other one? Looks like
that other person fixed their problem using persistent connections and
probably not as motivated to work with you guys as I am .... This is a
critical bug for me and holding up my development at the moment!
Previous Comments:
------------------------------------------------------------------------
[2003-11-27 01:09:06] [EMAIL PROTECTED]
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same.
Thank you for your interest in PHP.
Exactly same as bug #24531
------------------------------------------------------------------------
[2003-11-27 00:28:04] [EMAIL PROTECTED]
User reported that patch produced exact same backtrace as before.
(PLEASE don't add that same bt anymore..)
------------------------------------------------------------------------
[2003-11-25 14:18:22] [EMAIL PROTECTED]
Oops..I meant the Open reports.. :)
See bug #24531 which has some patch in it.
Try the patch..
------------------------------------------------------------------------
[2003-11-24 23:19:56] troy dot tinnes at motorola dot com
Description:
------------
Environment:
Sun Solaris 2.8
Sun Ultra Enterprise
PHP 4.3.4
Apache 2.0.47
Problem Description: On some HTML outputs, the page code stops
unexpectedly. There does not appear to be any real reason for halting
the execution - it stops generating code many times - midway through
displaying a record (1 HTML table row). For example if I have a query
that shows which people bought widget "a" in the past month - the
output might be ok. Use the same script and show which people bought
widget "b" - the script might stop 3/4 of the way down the page
mid-record. One thing that is consistent - is that it will always stop
in the same place. 2 days later, Widget "b" output might be fine -
displaying Widget "a" is now a problem.
Reproduce code:
---------------
I use object-oriented code to do the database activities - example:
$db = new myDB ($db1);
$db->connect();
$db->query($sql1);
In the db.class file, I have functions like this:
function connect ()
{
$conn = ocilogon ($this->username, $this->password,
$this->hostspec);
$this->conn = $conn;
}
AND
function query ($sql)
{
$this->stmt = @ociparse ($this->conn, $sql);
if (!$this->stmt) {
return false;
}
else {
@ociexecute($this->stmt, OCI_DEFAULT);
return($this->rowcount());
}
}
As I said before, I do not use persistent connections because I have
several different database instances I connect to based on the type of
information requested.
Expected result:
----------------
I am hoping to see complete HTML outputs!
Actual result:
--------------
BACKTRACE:
---------
solaris8:/opt/web/apache_php/apache2/bin# /usr/misc/bin/gdb
/opt/web/apache_php/apache2/bin/httpd
GNU gdb 5.3
Copyright 2002 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"...
(gdb) run -X
Starting program: /opt/web/apache_php/apache2/bin/httpd -X
[New LWP 1]
[New LWP 2]
[New LWP 3]
[New LWP 4]
[New LWP 5]
Program received signal SIGSEGV, Segmentation fault.
0xff0331f0 in strlen () from /usr/lib/libc.so.1
(gdb) bt
#0 0xff0331f0 in strlen () from /usr/lib/libc.so.1
#1 0xfe1e5918 in _oci_close_session (session=0x313bc8)
at /opt/web/apache_php/source/php-4.3.4/ext/oci8/oci8.c:2443
#2 0xfe1e0ca8 in _oci_session_list_dtor (rsrc=0x200e30)
at /opt/web/apache_php/source/php-4.3.4/ext/oci8/oci8.c:935
#3 0xfe36dcb0 in list_entry_destructor (ptr=0x200e30)
at /opt/web/apache_php/source/php-4.3.4/Zend/zend_list.c:177
#4 0xfe36aa64 in zend_hash_apply_deleter (ht=0xfe3e13fc, p=0x2017b0)
at /opt/web/apache_php/source/php-4.3.4/Zend/zend_hash.c:608
#5 0xfe36ae04 in zend_hash_graceful_reverse_destroy (ht=0xfe3e13fc)
at /opt/web/apache_php/source/php-4.3.4/Zend/zend_hash.c:674
#6 0xfe36dee0 in zend_destroy_rsrc_list (ht=0xfe3e13fc)
at /opt/web/apache_php/source/php-4.3.4/Zend/zend_list.c:233
#7 0xfe3501dc in shutdown_executor ()
at
/opt/web/apache_php/source/php-4.3.4/Zend/zend_execute_API.c:213
#8 0xfe3612f8 in zend_deactivate ()
at /opt/web/apache_php/source/php-4.3.4/Zend/zend.c:665
#9 0xfe306904 in php_request_shutdown (dummy=0x0)
at /opt/web/apache_php/source/php-4.3.4/main/main.c:998
#10 0xfe383be8 in php_apache_request_dtor (r=0x187dd0)
at
/opt/web/apache_php/source/php-4.3.4/sapi/apache2handler/sapi_apache2.c:449
#11 0xfe3840b8 in php_handler (r=0x187dd0)
---Type <return> to continue, or q <return> to quit---
at
/opt/web/apache_php/source/php-4.3.4/sapi/apache2handler/sapi_apache2.c:553
#12 0x0004a37c in ap_run_handler (r=0x187dd0) at config.c:195 #13
0x0004a950 in ap_invoke_handler (r=0x187dd0) at config.c:401 #14
0x00037d60 in ap_process_request (r=0x187dd0) at http_request.c:288 #15
0x00033274 in ap_process_http_connection (c=0x169220) at
http_core.c:293 #16 0x00055740 in ap_run_process_connection
(c=0x169220) at connection.c:85 #17 0x00048b78 in child_main
(child_num_arg=1470896) at prefork.c:694 #18 0x00048d70 in make_child
(s=0x9bb80, slot=0) at prefork.c:734 #19 0x00048dfc in startup_children
(number_to_start=4) at prefork.c:806 #20 0x0004962c in ap_mpm_run
(_pconf=0x1, plog=0xd1558, s=0x9bb80)
at prefork.c:1022
#21 0x0004f23c in main (argc=2, argv=0xffbefd1c) at main.c:660
(gdb)
LOG ENTRY IN APACHE
----------------------
websrv01:/opt/web/apache_php/apache/logs% grep Segment error_log [Thu
Nov 20 20:31:59 2003] [error] [client 200.30.7.100] Segmentation Fault
- core dumped [Thu Nov 20 20:33:46 2003] [error] [client 200.30.7.100]
Segmentation Fault - core dumped [Thu Nov 20 20:33:55 2003] [error]
[client 200.30.7.100] Segmentation Fault - core dumped [Thu Nov 20
20:47:37 2003] [error] [client 200.30.7.100] Segmentation Fault - core
dumped [Sun Nov 23 19:55:45 2003] [notice] child pid 4946 exit signal
Segmentation fault (11) [Sun Nov 23 19:56:04 2003] [notice] child pid
6151 exit signal Segmentation fault (11) [Sun Nov 23 19:58:31 2003]
[notice] child pid 6536 exit signal Segmentation fault (11) [Sun Nov 23
20:05:13 2003] [notice] child pid 7172 exit signal Segmentation fault
(11) [Mon Nov 24 13:39:02 2003] [notice] child pid 27426 exit signal
Segmentation fault (11)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=26393&edit=1
