Re: MySQL errors in newer PHP 4.2.3
Hi Steven, Some precisions : after taking a look at my mail, I noticed the very first time I saw this error was with PHP 4.2.1 and MySQL 4.0.2 (reported on this list on 27 june 2002). Regards, Jocelyn - Original Message - From: "Steven Roussey" <[EMAIL PROTECTED]> To: "'Jocelyn Fournier'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "'Mysql'" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 2:38 AM Subject: RE: MySQL errors in newer PHP 4.2.3 > Hmm, do you use pconnect or connect? > > I noticed someone changed our PHP script to use persistent connections > (likely why the server is running slower). I am wondering if a cancelled > connection is being reused or if it just is a more general bug in the > mysql client code in PHP > > Sincerely, > Steven Roussey > http://Network54.com/?pp=e > > > -Original Message- > > From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] > > > > Hi, > > > > Same problem for me, although it was already here with 4.2.0 for me > (well > > it > > seems to be also a high QPS problem...). The problem seems to > disappear > > with > > an apache restart, but sometimes appear again randomly. > > > > Regards, > > Jocelyn > > > > - Original Message ----- > > From: "Steven Roussey" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Cc: "Mysql" <[EMAIL PROTECTED]> > > Sent: Friday, September 20, 2002 2:14 AM > > Subject: MySQL errors in newer PHP 4.2.3 > > > > > > > Since updating to 4.2.3, we have been getting intermittent errors of > > > "Commands out of sync". Anyone else see this? > > > > > > Sincerely, > > > Steven Roussey > > > http://Network54.com/?pp=e > > > > > > php,sql,query > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL errors in newer PHP 4.2.3
I've always used pconnect. - Original Message - From: "Steven Roussey" <[EMAIL PROTECTED]> To: "'Jocelyn Fournier'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "'Mysql'" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 2:38 AM Subject: RE: MySQL errors in newer PHP 4.2.3 > Hmm, do you use pconnect or connect? > > I noticed someone changed our PHP script to use persistent connections > (likely why the server is running slower). I am wondering if a cancelled > connection is being reused or if it just is a more general bug in the > mysql client code in PHP > > Sincerely, > Steven Roussey > http://Network54.com/?pp=e > > > -Original Message- > > From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] > > > > Hi, > > > > Same problem for me, although it was already here with 4.2.0 for me > (well > > it > > seems to be also a high QPS problem...). The problem seems to > disappear > > with > > an apache restart, but sometimes appear again randomly. > > > > Regards, > > Jocelyn > > > > ----- Original Message - > > From: "Steven Roussey" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Cc: "Mysql" <[EMAIL PROTECTED]> > > Sent: Friday, September 20, 2002 2:14 AM > > Subject: MySQL errors in newer PHP 4.2.3 > > > > > > > Since updating to 4.2.3, we have been getting intermittent errors of > > > "Commands out of sync". Anyone else see this? > > > > > > Sincerely, > > > Steven Roussey > > > http://Network54.com/?pp=e > > > > > > php,sql,query > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL errors in newer PHP 4.2.3
Hmm, do you use pconnect or connect? I noticed someone changed our PHP script to use persistent connections (likely why the server is running slower). I am wondering if a cancelled connection is being reused or if it just is a more general bug in the mysql client code in PHP Sincerely, Steven Roussey http://Network54.com/?pp=e > -Original Message- > From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] > > Hi, > > Same problem for me, although it was already here with 4.2.0 for me (well > it > seems to be also a high QPS problem...). The problem seems to disappear > with > an apache restart, but sometimes appear again randomly. > > Regards, > Jocelyn > > - Original Message - > From: "Steven Roussey" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: "Mysql" <[EMAIL PROTECTED]> > Sent: Friday, September 20, 2002 2:14 AM > Subject: MySQL errors in newer PHP 4.2.3 > > > > Since updating to 4.2.3, we have been getting intermittent errors of > > "Commands out of sync". Anyone else see this? > > > > Sincerely, > > Steven Roussey > > http://Network54.com/?pp=e > > > > php,sql,query > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL errors in newer PHP 4.2.3
Hi, Same problem for me, although it was already here with 4.2.0 for me (well it seems to be also a high QPS problem...). The problem seems to disappear with an apache restart, but sometimes appear again randomly. Regards, Jocelyn - Original Message - From: "Steven Roussey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Mysql" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 2:14 AM Subject: MySQL errors in newer PHP 4.2.3 > Since updating to 4.2.3, we have been getting intermittent errors of > "Commands out of sync". Anyone else see this? > > Sincerely, > Steven Roussey > http://Network54.com/?pp=e > > php,sql,query > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL errors in newer PHP 4.2.3
Since updating to 4.2.3, we have been getting intermittent errors of "Commands out of sync". Anyone else see this? Sincerely, Steven Roussey http://Network54.com/?pp=e php,sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php