That message doesn't suggest anything to do with Roller itself, it
sounds like mysql has simply banned your host from connections for some
reason. You are probably better off check out this problem on the mysql
forums.
-- Allen
Finbar Dineen wrote:
After working fine for months I've got a problem of three different
installations of Roller (all on the same host). I'm using Tomcat 5.5.7
and MySql 4.1
I'm getting the following error message showing in my log files:
INFO 2006-09-01 00:00:00,012 TurnoverReferersTask:run - task started
INFO 2006-09-01 00:00:02,905 TurnoverReferersTask:run - task completed
INFO 2006-09-01 00:00:41,752 HibernatePlanetManagerImpl:getAggregation -
Generated aggregation in 6.18 seconds
ERROR 2006-09-01 00:50:02,633 JDBCExceptionReporter:logExceptions - Server connection
failure during transaction. Due to underlying exception: 'java.sql.SQLException: null,
message from server: "Host 'www.myhost.com' is blocked because of many connection
errors; unblock with 'mysqladmin flush-hosts'"'.
** BEGIN NESTED EXCEPTION **
java.sql.SQLException
MESSAGE: null, message from server: "Host 'www8.kc.aoindustries.com' is blocked
because of many connection errors; unblock with 'mysqladmin flush-hosts'"
STACKTRACE:
java.sql.SQLException: null, message from server: "Host 'www8.kc.aoindustries.com'
is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:991)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2669)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at
org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
at
org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:74)
at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at
org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at
org.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperty(HibernatePropertiesManagerImpl.java:52)
at
org.roller.config.RollerRuntimeConfig.getProperty(RollerRuntimeConfig.java:51)
at
org.roller.config.RollerRuntimeConfig.getBooleanProperty(RollerRuntimeConfig.java:68)
at
org.roller.config.PingConfig.getSuspendPingProcessing(PingConfig.java:150)
at
org.roller.presentation.pings.PingQueueProcessor.processQueue(PingQueueProcessor.java:73)
at
org.roller.presentation.pings.PingQueueTask.run(PingQueueTask.java:65)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
================================================
The only help I can find on this is from:
http://lists.mysql.com/win32/16598
But I'm still having problems transalting this into a solution for my blog.
What exactly has happened and how do I go about solving this?
