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

From: Date: Tue, 01 Oct 2002 17:10:20 +0000
Subject: #19529 [Opn]: Occational "Commands out of sync" errors
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-20974@lists.php.net to get a copy of this message 
 ID:               19529
 User updated by:  sroussey@network54.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:

Last thing! I do not use transactions or any transactional table
handlers. Just plain MySQL with MySQL table types.


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

[2002-10-01 11:44:41] sroussey@network54.com

Sorry to reopen. I think it was changed to Bogus because of MySQL 4
usage. However, I use 3.23.49a for the server and use the built-in
client software that comes with PHP 4.2.3. Other users see the same
errors with 4.0.x servers. 

Essentially this is a client PHP issue.

I am now logging all mysql errors to a file so I can see how different
changes affect things. As far as I can see, this condition only happens
under high load and only when using pconnect.

Again, nothing to do with MySQL 4.

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

[2002-09-22 08:47:09] joc@presence-pc.com

I agree MySQL 4.x is still in beta quality (although it works quite
well), but before upgrading to php 4.2.1 I had strictly no problem with
PHP / MySQL 4.x (and I'm using MySQL 4.x libs).

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

[2002-09-21 15:17:40] sander@php.net

IMHO, it's not a good idea to use MySQL 4.x. It's certainly not a good
idea to use 3.x libs to access a 4.x server. 

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

[2002-09-21 15:14:58] sroussey@network54.com

Additional information: this issue seems to only happen when using
mysql_pconnect. I switched to mysql_connect and the issue has gone
away. Seems to be an issue with persistent connections.

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

[2002-09-21 14:49:54] sroussey@network54.com

I don't use the MySQL 4 libs.

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

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

Thread (35 messages)

« previous php.bugs (#20974) next »