Bug #60538 MySQL fails to start when max_connect_errors is set to 18446744073709547520
Submitted: 18 Mar 2011 20:29 Modified: 19 Mar 2011 4:36
Reporter: David Nguyen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.1.55, 5.1.57 OS:Any
Assigned to: CPU Architecture:Any
Tags: 18446744073709547520, max_connect_errors
Triage: Needs Triage: D3 (Medium)

[18 Mar 2011 20:29] David Nguyen
Description:
MySQL fails to start when max_connect_errors is set to 18446744073709547520.  

110318 19:20:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110318 19:20:28 [ERROR] Incorrect integer value: '18446744073709547520'
110318 19:20:28 [Warning] option 'max_connect_errors': unsigned value 0 adjusted to 1
110318 19:20:28 [ERROR] /usr/sbin/mysqld: Error while setting value '18446744073709547520' to 'max_connect_errors'
110318 19:20:28 [ERROR] Aborting

How to repeat:
According to the documentation the range = 1-18446744073709547520.

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_connect_err...

Repeated Steps:
1) set max_connect_errors = 18446744073709547520
2) Start up the database

Suggested fix:
Fix the maximum value to be 18446744073709547520 or update the docs to the new maximum value.
[19 Mar 2011 4:36] Valeriy Kravchuk
Verified with current mysql-5.1 from bzr on Mac OS X (32-bit binaries):

macbook-pro:5.1 openxs$ bin/mysqld_safe --max_connect_errors=18446744073709547520 &
[3] 22129
macbook-pro:5.1 openxs$ 110319 06:28:40 mysqld_safe Logging to '/Users/openxs/dbs/5.1/var/macbook-pro.err'.
chown: /Users/openxs/dbs/5.1/var/macbook-pro.err: Operation not permitted
110319 06:28:41 mysqld_safe Starting mysqld daemon with databases from /Users/openxs/dbs/5.1/var
110319 06:28:41 mysqld_safe mysqld from pid file /Users/openxs/dbs/5.1/var/macbook-pro.pid ended

[3]-  Done                    bin/mysqld_safe --max_connect_errors=18446744073709547520
macbook-pro:5.1 openxs$ tail var/macbook-pro.err 
110319  6:27:37 [Note] /Users/openxs/dbs/5.1/libexec/mysqld: Shutdown complete

110319 06:27:37 mysqld_safe mysqld from pid file /Users/openxs/dbs/5.1/var/macbook-pro.pid ended
110319 06:28:41 mysqld_safe Starting mysqld daemon with databases from /Users/openxs/dbs/5.1/var
110319  6:28:41 [ERROR] Incorrect integer value: '18446744073709547520'
110319  6:28:41 [Warning] option 'max_connect_errors': unsigned value 0 adjusted to 1
110319  6:28:41 [ERROR] /Users/openxs/dbs/5.1/libexec/mysqld: Error while setting value '18446744073709547520' to 'max_connect_errors'
110319  6:28:41 [ERROR] Aborting

110319 06:28:41 mysqld_safe mysqld from pid file /Users/openxs/dbs/5.1/var/macbook-pro.pid ended
...

When I started server with --max_connect_errors=184467440737095475 ("20" removed at the end), I've got the following:

macbook-pro:5.1 openxs$ bin/mysql -uroot testReading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.57-debug Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like 'max_conn%';
+--------------------+------------+
| Variable_name      | Value      |
+--------------------+------------+
| max_connect_errors | 4294967295 |
| max_connections    | 151        |
+--------------------+------------+
2 rows in set (0.00 sec)
[19 Mar 2011 8:46] Peter Laursen
Same with 5.5.10 Windows 64 bit server.

Peter
(not a MySQL person)