Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

if mysql cannot login for: ERROR 1129 (HY000): Host 'xx.xx.xx.xx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts', dble cannot start up #527

Closed
irene-coming opened this issue Apr 28, 2018 · 2 comments
Assignees
Labels
protocol resolve problem has been fixed by developer
Milestone

Comments

@irene-coming
Copy link
Member

version:5.6.29-dble-2.18.02.1-dev-20180428023831

yanhuqing666 added a commit that referenced this issue May 3, 2018
@irene-coming
Copy link
Member Author

irene-coming commented May 9, 2018

Host 'host_name' is blocked info:
https://dev.mysql.com/doc/refman/8.0/en/blocked-host.html

a possible way to repeat the err:
(ps: 10.186.30.93 is dble resides host, mysql and dble installed in different servers)
step1:
login the mysqld and execute:
set global max_connect_errors=1;

step2, in mysql host do:
[root@zhj]# tc qdisc add dev eth0 handle 1: root prio
[root@zhj]# tc qdisc add dev eth0 handle 70: parent 1:3 netem loss 90%
[root@zhj]# tc filter add dev eth0 protocol ip parent 1: prio 2 u32 match ip dst 10.186.30.93 flowid 1:3

step3:
from 10.186.30.93 create a mysql connection to mysqld ( 10% chance need retry this step for netem loss 90%)
then get:
mysql: [Warning] Using a password on the command line interface can be insecure.
ctrl+c quit the login before you get:(wait about 1min with net.ipv4.tcp_syn_retries = 6)
ERROR 2003 (HY000): Can't connect to MySQL server on '10.186.30.86' (110)

step4, in mysql host do:
[root@zhj]# tc filter del dev eth0 protocol ip parent 1: prio 2 u32 match ip dst 10.186.30.93 flowid 1:3
[root@zhj]# tc qdisc del dev eth0 handle 70: parent 1:3 netem loss 90%
[root@zhj]# tc qdisc del dev eth0 handle 1: root prio

step5:
login the mysqld from '10.186.30.93' and get:
ERROR 1129 (HY000): Host '10.186.30.93' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

if the block err does not occur, retry step2~step5

@yanhuqing666
Copy link
Member

commit: 0c2eb61 and 1b5c502

@yanhuqing666 yanhuqing666 added this to the 2.18.06.0 milestone May 10, 2018
@yanhuqing666 yanhuqing666 added the resolve problem has been fixed by developer label Jun 4, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
protocol resolve problem has been fixed by developer
Projects
None yet
Development

No branches or pull requests

3 participants