Re: host blocked, but can't see errors
Hello. See: http://dev.mysql.com/doc/mysql/en/Debugging_server.html Scott Tanner [EMAIL PROTECTED] wrote: I've been having this issue as well, happening more frequently to our production web /ejb servers. I've increased the logging to warning level, but my logs don't contain much (if any) information. Is there a way to increase logging to debug level, or get more information as to what is causing the problem? I want to make sure the application is not mishandling the connections before increasing the max_connection_errors. Thank you, Scott - Original Message --- -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: host blocked, but can't see errors
I've been having this issue as well, happening more frequently to our production web /ejb servers. I've increased the logging to warning level, but my logs don't contain much (if any) information. Is there a way to increase logging to debug level, or get more information as to what is causing the problem? I want to make sure the application is not mishandling the connections before increasing the max_connection_errors. Thank you, Scott - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 25, 2004 12:06 AM Subject: Re: host blocked, but can't see errors Hello. In this context 'errors' means interrupted connections. Increase max_connect_errors. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Anne Ramey [EMAIL PROTECTED] wrote: Last week I got this message: Cannot connect DBI:mysql:formmail;myhost.net: Host 'myhost.net' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' I couldn't find the errors anywhere. Not in any of the apache logs and not in the mysql error log: 041103 20:09:11 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 041103 20:09:11 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 041103 20:09:12 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 041103 20:09:12 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 041103 20:09:13 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.21-max' socket: '/tmp/mysql.sock' port: 3306 Official MySQL-max binary I've also checked my syslog, messages log, and formmail log, nothing. It's only happening to this one host. it keeps happening over and over. I have to flush my host every day or so. Any ideas where to look? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 0448-1, 11/26/2004 Tested on: 11/29/2004 10:44:37 AM avast! - copyright (c) 2000-2004 ALWIL Software. http://www.avast.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: host blocked, but can't see errors
Scott Tanner wrote: I've been having this issue as well, happening more frequently to our production web /ejb servers. I've increased the logging to warning level, but my logs don't contain much (if any) information. Is there a way to increase logging to debug level, or get more information as to what is causing the problem? I want to make sure the application is not mishandling the connections before increasing the max_connection_errors. Scott: I believe this is as much logging as you can get. However, this particular error happens when too many network reads are timing out. There are two most likely causes I can think of: * Network problems * The client CPU load is very high. So some client process starts authenticating, then gets rescheduled, and takes forever to get another turn to finish authenticating. As Gleb has pointed out, increasing max_connect_errors will help. Also, try increasing connect_timeout. And set up a cron job that runs FLUSH HOSTS every so often. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: host blocked, but can't see errors
Hello. In this context 'errors' means interrupted connections. Increase max_connect_errors. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Anne Ramey [EMAIL PROTECTED] wrote: Last week I got this message: Cannot connect DBI:mysql:formmail;myhost.net: Host 'myhost.net' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' I couldn't find the errors anywhere. Not in any of the apache logs and not in the mysql error log: 041103 20:09:11 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 041103 20:09:11 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 041103 20:09:12 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 041103 20:09:12 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 041103 20:09:13 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.21-max' socket: '/tmp/mysql.sock' port: 3306 Official MySQL-max binary I've also checked my syslog, messages log, and formmail log, nothing. It's only happening to this one host. it keeps happening over and over. I have to flush my host every day or so. Any ideas where to look? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
host blocked, but can't see errors
Last week I got this message: Cannot connect DBI:mysql:formmail;myhost.net: Host 'myhost.net' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' I couldn't find the errors anywhere. Not in any of the apache logs and not in the mysql error log: 041103 20:09:11 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 041103 20:09:11 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 041103 20:09:12 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 041103 20:09:12 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 041103 20:09:13 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.21-max' socket: '/tmp/mysql.sock' port: 3306 Official MySQL-max binary I've also checked my syslog, messages log, and formmail log, nothing. It's only happening to this one host. it keeps happening over and over. I have to flush my host every day or so. Any ideas where to look? -- Anne Ramey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
