Serious #1130 problem

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #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.