You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Finbar Dineen <at...@limlom.com> on 2006/09/02 23:42:16 UTC
MySql problem
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 : atmeneti@limlom.com
homepage : http://www.limlom.com/
Re: MySql problem
Posted by Finbar Dineen <at...@limlom.com>.
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?
>>
>>
Re: MySql problem
Posted by Allen Gilliland <al...@sun.com>.
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?
>
>