Serious #1130 problem


I’ve got strange problem, and can’t google right answer.

Every 5-10 minutes mysql declines to accept 1-2 connections, showing the error code 1130: Host ‘X.X.X.X’ is not allowed to connect to this MySQL server, and successfully accepts the rest.

To replicate this issue, i’m using php script, with 30 forks that connects/disconnects to selected Percona server with all the same login/password/db.

And usually, every 5-10 minutes i see 2-3 errors at a time. At the same time, the rest of the threads are connecting fine.

There’s no errors in /var/log/messages, or at mysql .err log.

It’s Debian Squeeze server, Percona 5.1.54 built from sources.

If you have ANY ideas what could it be, please let me know.

DNS issue? See if you can still reproduce it after putting the hostname and ip address in the hosts file of the MySQL server.

Due to the nature of setup, both IPs are already in /etc/hosts, so its not DNS issue.

Ps. All accounts on theese servers were created with % as hostname.