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
Host is blocked because of many connection errors #1818
Comments
Please refer to http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html |
Hi vipsoft I agree one solution is to increase the value in MySQL. However, it seems that if there are connection errors (not running out of connections), then we should fix the problem, instead of increasing the value. FYI, I tried to simulate it again, it occurred again even though NO ONE is logged in. Should I reopen this issue? |
You probably don't have privileges to re-open this ticket. I understand these are connection errors, but I don't currently believe this is within our scope of support, but I'll help you diagnose this as best I can. Execute "show global status like '%abort%';". |
The return result is : mysql> show global status like '%abort%'; |
I think the MySQL page is incomplete. The MySQL server increments Aborted_clients when:
The MySQL server increments Aborted_connects when:
|
Sorry. I don't understand what you mean by 'I think the MySQL page is incomplete.' Do you mean the info I provide is incomplete, or the documentation is incomplete? Either way, I believe somethin on the Piwik side is triggering this problem. All my other web apps currently using MySQL does not trigger this issue. How should I go about debugging Piwik? |
I take my statement back. I found something fishy in the server hosting Piwik, and am looking into it now. Thanks alot! |
Hi Piwik experts,
I'm getting
SQLSTATE[HY000] Host 'x.x.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
after leaving the admin user logged in for a few hours. Only the admin is in the database, and Piwik is monitoring 1 site.
I'm testing the 1.0 install, enabled GeoIP, and enabled most of the plugins.
How can I check what is wrong with the application?
The text was updated successfully, but these errors were encountered: