roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Finbar Dineen <atmen...@limlom.com>
Subject Re: MySql problem
Date Sun, 03 Sep 2006 07:13:51 GMT
Allen,

Thanks, I did think as much, but wanted to double check before hassling
my hosting company further. I also found this explanation on MySql in
case anyone else experiences this:
http://dev.mysql.com/doc/refman/5.1/en/blocked-host.html

Cheers

email         :  atmeneti@limlom.com
homepage      :  http://www.limlom.com/



Allen Gilliland wrote:
> 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?
>>
>>

Mime
View raw message