Bug 213708 - SQL statement - large resultsets the process simply dies
Summary: SQL statement - large resultsets the process simply dies
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Red Hat Enterprise Linux 3
Classification: Red Hat
Component: php
Version: 3.0
Hardware: i686
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Joe Orton
QA Contact: David Lawrence
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2006-11-02 17:23 UTC by Daniel Hanman
Modified: 2008-08-02 23:40 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2007-10-19 18:40:13 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Daniel Hanman 2006-11-02 17:23:54 UTC
Description of problem:
We have a website running on Apache, PHP and MySQL DB. This sits on RedHat
Advanced Server 3.
We experienced problems using the standard AS3 PHP RPM - php-4.3.2-36.ent.
Using this, in a PHP page we connected to a database, prepared a SQL statement
and called get_result_array().
For small resultsets there was no problem, but for large resultsets the process
simply died and did not return.
There were no errors in the apache error log.
This issue resolves with php4-4.3.10-10.i386.rpm - which is not the standard one
for this version of AS3.

Version-Release number of selected component (if applicable):
RHEL AS 3 Update 6. Standard php-4.3.2-36 RedHat RPM

How reproducible:
Fairly, you just need a DB capable of producing large data sets


Steps to Reproduce:
For small resultsets there was no problem, but for large resultsets the process
simply died and did not return.
There were no errors in the apache error log.

  
Actual results:


Expected results:
Results from the SQL query

Additional info:

Comment 1 Joe Orton 2007-04-25 12:35:35 UTC
Thanks for the report.  Can you give an example script which shows this problem?
 (or a preciese description of exactly what the script in question does -
get_result_array() is not a PHP function; what does that function do?)

Comment 2 RHEL Program Management 2007-10-19 18:40:13 UTC
This bug is filed against RHEL 3, which is in maintenance phase.
During the maintenance phase, only security errata and select mission
critical bug fixes will be released for enterprise products. Since
this bug does not meet that criteria, it is now being closed.
 
For more information of the RHEL errata support policy, please visit:
http://www.redhat.com/security/updates/errata/
 
If you feel this bug is indeed mission critical, please contact your
support representative. You may be asked to provide detailed
information on how this bug is affecting you.


Note You need to log in before you can comment on or make changes to this bug.