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]
