Serious #1130 problem

MySQL & MariaDB Other MySQL® Questions
1

Hello,

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.

2

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

3

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.