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

ID: 19529 User updated by: sroussey@network54.com Reported By: sroussey@network54.com -Status: Bogus +Status: Open Bug Type: MySQL related Operating System: Linux 2.4.18 PHP Version: 4.2.3 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2002-09-21 01:42:05] sniper@php.net Mysql 4.x is still beta quality. So please stick to the stable releases for now. ------------------------------------------------------------------------ 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