RE: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
Three days and no problems, I have to assume that the max_connections fix our problem. -Original Message- From: Kevin Angus [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 4:50 PM To: vchkpw@inter7.com Subject: RE: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again I did up the wait_timeout and that is not the issue, in my.cnf we had max_user_connections=300 but no gobal max_connections setting. In my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 set-variable=max_connections=300 [mysql.server] user=mysql basedir=/var/lib set-variable = max_user_connections = 300 set-variable = table_cache=1200 set-variable = max_allowed_packet=1M set-variable = max_connect_errors=99 set-variable = log-warnings=2 Were waiting for a failure now. -Original Message- From: Filoo GmbH - Christopher Kunz [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 4:35 PM To: vchkpw@inter7.com Subject: Re: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again Michael Bellears schrieb: Just how busy is MySQL? Not very. The server is kinda big and the lost connection is almost instant. The reconnect, though, takes a couple seconds. Does restarting MySQL resolve the problem for a period? Not at all. I see the connections coming in, and when they're killed off by mysql after 5 minutes (our wait_timeout), the issues start again. Upping wait_timeout is not an option, since the server *can* get very busy with lots of other persistent connections. Regards, --ck -- php development | hosting | housing | professional game server hosting http://www.de-punkt.de [ [EMAIL PROTECTED] ]http://www.stormix.de Hotline: 07000-3378658 (12 Ct/min) | Fax: 01805-963951172 (12 Ct/min) PHP-Sicherheit - jetzt vorbestellen!http://www.php-sicherheit.de/
Re: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
Kevin Angus schrieb: Three days and no problems, I have to assume that the max_connections fix our problem. The 5.4.17 + authlib recompile hint did it for me, everything running well. Regards, --ck -- php development | hosting | housing | professional game server hosting http://www.de-punkt.de [ [EMAIL PROTECTED] ]http://www.stormix.de Hotline: 07000-3378658 (12 Ct/min) | Fax: 01805-963951172 (12 Ct/min) PHP-Sicherheit - jetzt vorbestellen!http://www.php-sicherheit.de/
Re: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
After recompiling vpopmail, did you remember to compile a new build of courier-authlib ? Michael. Uhm... no? Is that really necessary and if so, why? --ck -- php development | hosting | housing | professional game server hosting http://www.de-punkt.de [ [EMAIL PROTECTED] ]http://www.stormix.de Hotline: 07000-3378658 (12 Ct/min) | Fax: 01805-963951172 (12 Ct/min) PHP-Sicherheit - jetzt vorbestellen!http://www.php-sicherheit.de/
Re: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
vpopmail library is static,so MUST compile a new build of courier-authlib.On 7/25/06, Filoo GmbH - Christopher Kunz [EMAIL PROTECTED] wrote: After recompiling vpopmail, did you remember to compile a new build of courier-authlib ? Michael.Uhm... no? Is that really necessary and if so, why?--ck--php development | hosting |housing | professional game server hosting http://www.de-punkt.de [ [EMAIL PROTECTED] ]http://www.stormix.deHotline: 07000-3378658 (12 Ct/min) |Fax: 01805-963951172 (12 Ct/min) PHP-Sicherheit - jetzt vorbestellen!http://www.php-sicherheit.de/-- ===Jianbin Xiao http://www.xiaojb.com===
Re: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
Jianbin Xiao schrieb: vpopmail library is static,so MUST compile a new build of courier-authlib. Ah. That seems to have fixed it. I'm gonna watch the logfiles, but the steps I used yesterday to reproduce the problem don't work any more. Lookds good :) Thanks so much, this was a real bugger. Regards, --ck -- php development | hosting | housing | professional game server hosting http://www.de-punkt.de [ [EMAIL PROTECTED] ]http://www.stormix.de Hotline: 07000-3378658 (12 Ct/min) | Fax: 01805-963951172 (12 Ct/min) PHP-Sicherheit - jetzt vorbestellen!http://www.php-sicherheit.de/
RE: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
I have tracked down the problem to the mysql threads timing out after 5 minutes (we are using the database server that handles authentication for other purposes, too) Just how busy is MySQL?
Re: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
Michael Bellears schrieb: I have tracked down the problem to the mysql threads timing out after 5 minutes (we are using the database server that handles authentication for other purposes, too) Just how busy is MySQL? Not very. The server is kinda big and the lost connection is almost instant. The reconnect, though, takes a couple seconds. Regards, --ck -- php development | hosting | housing | professional game server hosting http://www.de-punkt.de [ [EMAIL PROTECTED] ]http://www.stormix.de Hotline: 07000-3378658 (12 Ct/min) | Fax: 01805-963951172 (12 Ct/min) PHP-Sicherheit - jetzt vorbestellen!http://www.php-sicherheit.de/
Re: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
Michael Bellears schrieb: Just how busy is MySQL? Not very. The server is kinda big and the lost connection is almost instant. The reconnect, though, takes a couple seconds. Does restarting MySQL resolve the problem for a period? Not at all. I see the connections coming in, and when they're killed off by mysql after 5 minutes (our wait_timeout), the issues start again. Upping wait_timeout is not an option, since the server *can* get very busy with lots of other persistent connections. Regards, --ck -- php development | hosting | housing | professional game server hosting http://www.de-punkt.de [ [EMAIL PROTECTED] ]http://www.stormix.de Hotline: 07000-3378658 (12 Ct/min) | Fax: 01805-963951172 (12 Ct/min) PHP-Sicherheit - jetzt vorbestellen!http://www.php-sicherheit.de/
RE: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
I did up the wait_timeout and that is not the issue, in my.cnf we had max_user_connections=300 but no gobal max_connections setting. In my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 set-variable=max_connections=300 [mysql.server] user=mysql basedir=/var/lib set-variable = max_user_connections = 300 set-variable = table_cache=1200 set-variable = max_allowed_packet=1M set-variable = max_connect_errors=99 set-variable = log-warnings=2 Were waiting for a failure now. -Original Message- From: Filoo GmbH - Christopher Kunz [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 4:35 PM To: vchkpw@inter7.com Subject: Re: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again Michael Bellears schrieb: Just how busy is MySQL? Not very. The server is kinda big and the lost connection is almost instant. The reconnect, though, takes a couple seconds. Does restarting MySQL resolve the problem for a period? Not at all. I see the connections coming in, and when they're killed off by mysql after 5 minutes (our wait_timeout), the issues start again. Upping wait_timeout is not an option, since the server *can* get very busy with lots of other persistent connections. Regards, --ck -- php development | hosting | housing | professional game server hosting http://www.de-punkt.de [ [EMAIL PROTECTED] ]http://www.stormix.de Hotline: 07000-3378658 (12 Ct/min) | Fax: 01805-963951172 (12 Ct/min) PHP-Sicherheit - jetzt vorbestellen!http://www.php-sicherheit.de/
Re: [vchkpw] vmysql: sql error[3]: Lost connection to MySQL server during query - once again
- Original Message - From: Filoo GmbH - Christopher Kunz [EMAIL PROTECTED] Hi all, after checking the threads, the intermittant VCLOSE patch and finally updating vpopmail to 5.4.17, I'm rapidly running out of ideas. After recompiling vpopmail, did you remember to compile a new build of courier-authlib ? Michael.
