#19529 [Asn]: Occational "Commands out of sync" errors

ID: 19529 Updated by: zak@php.net Reported By: sroussey@network54.com Status: Assigned Bug Type: MySQL related Operating System: Linux 2.4.18 PHP Version: 4.2.3 Assigned To: georg New Comment: Interesting stuff. I am heading out on the road for about a month. I will follow up with this as soon as I get stable network access again. Previous Comments: ------------------------------------------------------------------------ [2002-10-10 15:03:07] derick@php.net reassigning ------------------------------------------------------------------------ [2002-10-10 13:07:13] sroussey@network54.com OK, no need to wait. Getting the errors already with 3.23.49a. I looked at the change in CVS and it only frees a memory leak from unbuffered queries. ------------------------------------------------------------------------ [2002-10-10 13:04:54] sroussey@network54.com PS: In this bug system, should I be using Add Comment rather than Edit Submission? I keep reseting the Status and I don't mean to. Maybe the bug system should add whatever is the current choice is to the list available. ------------------------------------------------------------------------ [2002-10-10 13:01:28] sroussey@network54.com Recent CVS does not help 4.0.2 over the long term (24 hours). I woke up and the log was full of the error. Will try 3.23.49a for 24 hours and report back. As far as explicitly calling mysql_free_result(), yikes! Trying to find any missing will be a pain! I guess the real way to deal with this is (yuck) track all the result sets and dispose of any left over when the connection is being reset. Therefore getting the order right. Unless we can reset the connenction last. Is there a way to order the callbacks? ------------------------------------------------------------------------ [2002-10-09 08:01:40] zak@php.net A possible fix (based on discussions between Rasmus and the MySQL team) has just been committed to CVS. If the fix works praise Rasmus, if it fails, blame me! :) Please try the latest CVS version and see if the bug can be reproduced. Also, regarding the connect_timeout tests. If connect_timeout is set to -1, then we want to rely on the MySQL settings for this option, rather than attempting to override the option with a value set in PHP. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19529 -- Edit this bug report at http://bugs.php.net/?id=19529&edit=1