List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:January 13 2011 2:57pm
Subject:Re: Error
View as plain text  
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 <ravamo@stripped> 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
 - mdykman@stripped

 May the Source be with you.
Thread
ErrorRafael Valenzuela13 Jan
  • Re: ErrorMichael Dykman13 Jan
    • Re: ErrorRafael Valenzuela13 Jan