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

From: Date: Fri, 20 Sep 2002 20:24:57 +0000
Subject: #19529 [Com]: Occational "Commands out of sync" errors
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-19908@lists.php.net to get a copy of this message 
 ID:               19529
 Comment by:       joc@presence-pc.com
 Reported By:      sroussey@network54.com
 Status:           Open
 Bug Type:         MySQL related
 Operating System: Linux 2.4.18
 PHP Version:      4.2.3
 New Comment:

Same problem for me with PHP 4.2.1 and MySQL 4.0.x.
mysql_query sometimes fails just after calling mysql_select_db (I'm not
using mysql_db_query). (only under high query per second).
Sometimes I'm not experiencing the error message but mysql_query fails
to return a valid resource identifier (and then mysql_fetch_row fails)
- again first mysql_query after mysql_select_db is affected -.
I'm using pconnect with mysql.
I'm linking statically with the mysql lib provided with mysql 4.0.x.


Previous Comments:
------------------------------------------------------------------------

[2002-09-20 13:28:52] sroussey@network54.com

There is no easily repeatable test case, as this seems to only happen
at high load, and it is intermittent.

Randomly, mysql_query will fail (more specificly, mysql_db_query), and
the error message is "Commands out of sync".

MySQL info on error: 
http://www.mysql.com/doc/en/Commands_out_of_sync.html

Other users have confirmed this back to version 4.2.1.

We only use the built-in mysql client lib in PHP.

------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=19529&edit=1

Thread (35 messages)

« previous php.bugs (#19908) next »