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?
--
email : [EMAIL PROTECTED]
homepage : http://www.limlom.com/
