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

ID: 19529 Updated by: georg@php.net Reported By: sroussey@network54.com -Status: Assigned +Status: Closed Bug Type: MySQL related Operating System: Linux 2.4.18 PHP Version: 4.2.3 Assigned To: georg New Comment: Fixed in cvs/4_3 Branch. Previous Comments: ------------------------------------------------------------------------ [2002-11-12 08:19:05] Xuefer@21cn.com sorry for my wrong reporting, my problem is made by my wrong re-built, after done ./cvsclean and ./config.nice and make/make install, problem gone :) by now, i have to stick to 4.2.2, hope this bug(#19529) will be fix soon ------------------------------------------------------------------------ [2002-11-12 03:24:36] Xuefer@21cn.com forgot to say, my php is 4.2.2 ------------------------------------------------------------------------ [2002-11-11 00:18:05] Xuefer@21cn.com i did't get any error with apache1.3.26 mod php compiled with mysql4.0.2 client lib connect to mysql4.0.4 but once i rebuild php, with mysql4.0.4 client lib, get the same error as u unnable to do mysql_select_db, and unnable to connect from remote, event use connect do not help(not sure) hope this info help u guys ------------------------------------------------------------------------ [2002-10-24 20:53:27] sroussey@network54.com Workarounds: A) Don't use persistent connections. B) If you must, you need to edit PHP source, ext/mysql/php_mysql.c (I think). Look for a callback function that has ROLLBACK in it. Either disable the callback or comment out all the lines in it. PHP 4.3.0 should do (B) over what is in 4.2.1. Better to still not have transactional garantee than to break all sites and then still not have transactional garantee. My $0.02. ------------------------------------------------------------------------ [2002-10-24 02:33:52] kevinbr@netcomm.ie Upgraded to PHP 4.2.3, using EZ Portal Content Server. Linux 2.2.15 MySQL client 3.22.32 Apache 1.3.26 Was working before upgrade to PHP 4.2.3, now getting 30% command sync errors, this is not a heavily loaded site, just in dev stage. I have stopped httpd, mysql, and restarted, and problem is exhibited straight away. Thus doubtful load or time related. Turned off persistant connections, problem went away. Fix soon? ------------------------------------------------------------------------ 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