This doesn't look like a mysql problem per-se. It looks like the problem lies with connection pooling somewhere in your Java stack; it looks like Pentaho's connection pooling is misconfigured alloing stale connections to remain in the pool. I suggest that you take this query to a Pentaho support group.
- michael dykman On Thu, Jan 13, 2011 at 5:16 AM, Rafael Valenzuela <rav...@gmail.com> wrote: > Hi everybody: > > I've this problem but i don't konw why? i use MySQL Server 5.5 and my > application it's Pentaho > > > 2011-01-13 11:00:44,156 WARN > [org.pentaho.reporting.libraries.base.boot.PackageState] Unable to > initialize the module ext-datasources-sampledata > 2011-01-13 11:03:53,406 ERROR [org.pentaho.platform.util.logging.Logger] > misc-org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener: > PooledDatasourceSystemListener.ERROR_0003 - Unable to pool datasource > object: hibernate caused by com.mysql.jdbc.CommunicationsException: > Communications link failure due to underlying exception: > > ** BEGIN NESTED EXCEPTION ** > > java.net.ConnectException > MESSAGE: Connection timed out: connect > > STACKTRACE: > > java.net.ConnectException: Connection timed out: connect > at java.net.PlainSocketImpl.socketConnect(Native Method) > at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) > at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) > at java.net.Socket.connect(Socket.java:529) > at java.net.Socket.connect(Socket.java:478) > at java.net.Socket.<init>(Socket.java:375) > at java.net.Socket.<init>(Socket.java:218) > at > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271) > at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771) > at com.mysql.jdbc.Connection.<init>(Connection.java:1555) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) > at java.sql.DriverManager.getConnection(DriverManager.java:582) > at java.sql.DriverManager.getConnection(DriverManager.java:185) > at > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) > at > org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:996) > at > org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:133) > at > org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener.startup(PooledDatasourceSystemListener.java:57) > at > org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340) > at > org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:322) > at > org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:289) > at > org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:206) > at > org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137) > at > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4544) > at > org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5016) > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:812) > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:787) > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:570) > at > org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1010) > at > org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:933) > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:468) > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1267) > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:308) > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > at > org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:89) > at > org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:328) > at > org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:308) > at > org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1043) > at > org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:738) > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) > at > org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1035) > at > org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:289) > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) > at > org.apache.catalina.core.StandardService.startInternal(StandardService.java:442) > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) > at > org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:674) > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140) > at org.apache.catalina.startup.Catalina.start(Catalina.java:596) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:303) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:431) > > > ** END NESTED EXCEPTION ** > > > > Last packet sent to the server was 0 ms ago. > > > -- > Mit forever > My Blog <http://www.redcloverbi.wordpress.com> > My Faborite > Web<http://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm> > http://www.technologyreview.com/ > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org