#41564 [NEW]: Lost connection to MySQL server during query

From: mm7102_us at yahoo dot com Operating system: Linux daffy.perf.redhat.com PHP version: 4.4.7 PHP Bug Type: MySQL related Bug description: Lost connection to MySQL server during query Description: ------------ We have internal apllication (PHP Version 4.1.2) which is using Mysql as databse. The application is having 10 pages(Admin,login,Sales,etc.,) and all these pages connects to database mysql. When I hit Admin page everytime they sometimes execute ok and sometimes they don't I am getting below error message "Lost connection to MySQL server during query" My using following environment System: Linux daffy.perf.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 06:41:59 EDT 2002 i686 unknown Web Server :Apache/1.3.23 Notes :"Query is working fine from sql prompt" CPU utilization is normal No load on Mysql Mysql is installed on the same machine Please help me in resoving this Reproduce code: --------------- #Get user list from db $SQL = "select u.user_name,u.fname,u.lname,u.user_id,visits, date_format( u.lu_date, '%m/%d/%Y') lu_date, from users u left outer join users_bb ub on ub.user_id = u.user_id left outer join users_per_type upt on upt.user_id = u.user_id AND upt.tab = 'default' order by 1"; $RESULT = mysql_query($SQL) or die(mysql_error()); $COUNT = mysql_num_rows($RESULT); // error -most of the times Expected result: ---------------- Query should execute always Actual result: -------------- some times I will get Lost connection to MySQL server during query -- Edit bug report at http://bugs.php.net/?id=41564&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=41564&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=41564&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=41564&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=41564&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=41564&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=41564&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=41564&r=needscript Try newer version: http://bugs.php.net/fix.php?id=41564&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=41564&r=support Expected behavior: http://bugs.php.net/fix.php?id=41564&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=41564&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=41564&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=41564&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41564&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=41564&r=dst IIS Stability: http://bugs.php.net/fix.php?id=41564&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=41564&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=41564&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=41564&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=41564&r=mysqlcfg