Error

Error

am 13.01.2011 11:16:43 von Rafael Valenzuela

--00163628410c7d19c20499b79ee9
Content-Type: text/plain; charset=ISO-8859-1

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.datasou rce.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.ja va: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.(Socket.java:375)
at java.net.Socket.(Socket.java:218)
at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketF actory.java:256)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
at com.mysql.jdbc.Connection.(Connection.java:1555)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDr iver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at
org.apache.commons.dbcp.DriverManagerConnectionFactory.creat eConnection(DriverManagerConnectionFactory.java:48)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java:290)
at
org.apache.commons.pool.impl.GenericObjectPool.addObject(Gen ericObjectPool.java:996)
at
org.pentaho.platform.engine.services.connection.datasource.d bcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatas ourceHelper.java:133)
at
org.pentaho.platform.engine.services.connection.datasource.d bcp.PooledDatasourceSystemListener.startup(PooledDatasourceS ystemListener.java:57)
at
org.pentaho.platform.engine.core.system.PentahoSystem.notify SystemListenersOfStartup(PentahoSystem.java:340)
at
org.pentaho.platform.engine.core.system.PentahoSystem.notify SystemListenersOfStartup(PentahoSystem.java:322)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(P entahoSystem.java:289)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(P entahoSystem.java:206)
at
org.pentaho.platform.web.http.context.SolutionContextListene r.contextInitialized(SolutionContextListener.java:137)
at
org.apache.catalina.core.StandardContext.listenerStart(Stand ardContext.java:4544)
at
org.apache.catalina.core.StandardContext.startInternal(Stand ardContext.java:5016)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
at
org.apache.catalina.core.ContainerBase.addChildInternal(Cont ainerBase.java:812)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBas e.java:787)
at org.apache.catalina.core.StandardHost.addChild(StandardHost. java:570)
at
org.apache.catalina.startup.HostConfig.deployDirectory(HostC onfig.java:1010)
at
org.apache.catalina.startup.HostConfig.deployDirectories(Hos tConfig.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(HostCo nfig.java:308)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (LifecycleSupport.java:119)
at
org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(Li fecycleBase.java:89)
at
org.apache.catalina.util.LifecycleBase.setState(LifecycleBas e.java:328)
at
org.apache.catalina.util.LifecycleBase.setState(LifecycleBas e.java:308)
at
org.apache.catalina.core.ContainerBase.startInternal(Contain erBase.java:1043)
at
org.apache.catalina.core.StandardHost.startInternal(Standard Host.java:738)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
at
org.apache.catalina.core.ContainerBase.startInternal(Contain erBase.java:1035)
at
org.apache.catalina.core.StandardEngine.startInternal(Standa rdEngine.java:289)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
at
org.apache.catalina.core.StandardService.startInternal(Stand ardService.java:442)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
at
org.apache.catalina.core.StandardServer.startInternal(Standa rdServer.java:674)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
at org.apache.catalina.startup.Catalina.start(Catalina.java:596 )
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:3 03)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:43 1)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.


--
Mit forever
My Blog
My Faborite Web
http://www.technologyreview.com/

--00163628410c7d19c20499b79ee9--

Re: Error

am 13.01.2011 15:57:45 von Michael Dykman

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 wrote=
:
> Hi everybody:
>
> I've this problem but i don't konw why? =A0i 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.datasou rce.dbcp.Pool=
edDatasourceSystemListener:
> 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
> =A0 =A0at java.net.PlainSocketImpl.socketConnect(Native Method)
> =A0 =A0at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
> =A0 =A0at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.ja va:=
195)
> =A0 =A0at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
> =A0 =A0at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
> =A0 =A0at java.net.Socket.connect(Socket.java:529)
> =A0 =A0at java.net.Socket.connect(Socket.java:478)
> =A0 =A0at java.net.Socket.(Socket.java:375)
> =A0 =A0at java.net.Socket.(Socket.java:218)
> =A0 =A0at
> com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketF actory.java:2=
56)
> =A0 =A0at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)
> =A0 =A0at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
> =A0 =A0at com.mysql.jdbc.Connection.(Connection.java:1555)
> =A0 =A0at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDr iver.java:285=
)
> =A0 =A0at java.sql.DriverManager.getConnection(DriverManager.java:582)
> =A0 =A0at java.sql.DriverManager.getConnection(DriverManager.java:185)
> =A0 =A0at
> org.apache.commons.dbcp.DriverManagerConnectionFactory.creat eConnection(D=
riverManagerConnectionFactory.java:48)
> =A0 =A0at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject (PoolableConn=
ectionFactory.java:290)
> =A0 =A0at
> org.apache.commons.pool.impl.GenericObjectPool.addObject(Gen ericObjectPoo=
l.java:996)
> =A0 =A0at
> org.pentaho.platform.engine.services.connection.datasource.d bcp.PooledDat=
asourceHelper.setupPooledDataSource(PooledDatasourceHelper.j ava:133)
> =A0 =A0at
> org.pentaho.platform.engine.services.connection.datasource.d bcp.PooledDat=
asourceSystemListener.startup(PooledDatasourceSystemListener .java:57)
> =A0 =A0at
> org.pentaho.platform.engine.core.system.PentahoSystem.notify SystemListene=
rsOfStartup(PentahoSystem.java:340)
> =A0 =A0at
> org.pentaho.platform.engine.core.system.PentahoSystem.notify SystemListene=
rsOfStartup(PentahoSystem.java:322)
> =A0 =A0at
> org.pentaho.platform.engine.core.system.PentahoSystem.init(P entahoSystem.=
java:289)
> =A0 =A0at
> org.pentaho.platform.engine.core.system.PentahoSystem.init(P entahoSystem.=
java:206)
> =A0 =A0at
> org.pentaho.platform.web.http.context.SolutionContextListene r.contextInit=
ialized(SolutionContextListener.java:137)
> =A0 =A0at
> org.apache.catalina.core.StandardContext.listenerStart(Stand ardContext.ja=
va:4544)
> =A0 =A0at
> org.apache.catalina.core.StandardContext.startInternal(Stand ardContext.ja=
va:5016)
> =A0 =A0at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava=
:140)
> =A0 =A0at
> org.apache.catalina.core.ContainerBase.addChildInternal(Cont ainerBase.jav=
a:812)
> =A0 =A0at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBas e.java:787)
> =A0 =A0at org.apache.catalina.core.StandardHost.addChild(StandardHost. jav=
a:570)
> =A0 =A0at
> org.apache.catalina.startup.HostConfig.deployDirectory(HostC onfig.java:10=
10)
> =A0 =A0at
> org.apache.catalina.startup.HostConfig.deployDirectories(Hos tConfig.java:=
933)
> =A0 =A0at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig .java:468)
> =A0 =A0at org.apache.catalina.startup.HostConfig.start(HostConfig.java :12=
67)
> =A0 =A0at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostCo nfig.java:308=
)
> =A0 =A0at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (LifecycleSup=
port.java:119)
> =A0 =A0at
> org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(Li fecycleBase.j=
ava:89)
> =A0 =A0at
> org.apache.catalina.util.LifecycleBase.setState(LifecycleBas e.java:328)
> =A0 =A0at
> org.apache.catalina.util.LifecycleBase.setState(LifecycleBas e.java:308)
> =A0 =A0at
> org.apache.catalina.core.ContainerBase.startInternal(Contain erBase.java:1=
043)
> =A0 =A0at
> org.apache.catalina.core.StandardHost.startInternal(Standard Host.java:738=
)
> =A0 =A0at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava=
:140)
> =A0 =A0at
> org.apache.catalina.core.ContainerBase.startInternal(Contain erBase.java:1=
035)
> =A0 =A0at
> org.apache.catalina.core.StandardEngine.startInternal(Standa rdEngine.java=
:289)
> =A0 =A0at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava=
:140)
> =A0 =A0at
> org.apache.catalina.core.StandardService.startInternal(Stand ardService.ja=
va:442)
> =A0 =A0at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava=
:140)
> =A0 =A0at
> org.apache.catalina.core.StandardServer.startInternal(Standa rdServer.java=
:674)
> =A0 =A0at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava=
:140)
> =A0 =A0at org.apache.catalina.startup.Catalina.start(Catalina.java:596 )
> =A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> =A0 =A0at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java=
:39)
> =A0 =A0at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorI=
mpl.java:25)
> =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597)
> =A0 =A0at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:3 03)
> =A0 =A0at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:43 1)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 0 ms ago.
>
>
> --
> Mit forever
> My Blog
> My Faborite Web uter-Science/index.htm>
> http://www.technologyreview.com/
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May 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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Error

am 13.01.2011 16:03:09 von Rafael Valenzuela

--0016363b8fbcd1ceff0499bb9ed6
Content-Type: text/plain; charset=ISO-8859-1

I'm sorry Michael and list mysql ,
I had realised that my mistake
not happen again




2011/1/13 Michael Dykman

> 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
> 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.datasou rce.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.ja va: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.(Socket.java:375)
> > at java.net.Socket.(Socket.java:218)
> > at
> >
> com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketF actory.java:256)
> > at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)
> > at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
> > at com.mysql.jdbc.Connection.(Connection.java:1555)
> > at
> >
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDr iver.java:285)
> > at java.sql.DriverManager.getConnection(DriverManager.java:582)
> > at java.sql.DriverManager.getConnection(DriverManager.java:185)
> > at
> >
> org.apache.commons.dbcp.DriverManagerConnectionFactory.creat eConnection(DriverManagerConnectionFactory.java:48)
> > at
> >
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java:290)
> > at
> >
> org.apache.commons.pool.impl.GenericObjectPool.addObject(Gen ericObjectPool.java:996)
> > at
> >
> org.pentaho.platform.engine.services.connection.datasource.d bcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatas ourceHelper.java:133)
> > at
> >
> org.pentaho.platform.engine.services.connection.datasource.d bcp.PooledDatasourceSystemListener.startup(PooledDatasourceS ystemListener.java:57)
> > at
> >
> org.pentaho.platform.engine.core.system.PentahoSystem.notify SystemListenersOfStartup(PentahoSystem.java:340)
> > at
> >
> org.pentaho.platform.engine.core.system.PentahoSystem.notify SystemListenersOfStartup(PentahoSystem.java:322)
> > at
> >
> org.pentaho.platform.engine.core.system.PentahoSystem.init(P entahoSystem.java:289)
> > at
> >
> org.pentaho.platform.engine.core.system.PentahoSystem.init(P entahoSystem.java:206)
> > at
> >
> org.pentaho.platform.web.http.context.SolutionContextListene r.contextInitialized(SolutionContextListener.java:137)
> > at
> >
> org.apache.catalina.core.StandardContext.listenerStart(Stand ardContext.java:4544)
> > at
> >
> org.apache.catalina.core.StandardContext.startInternal(Stand ardContext.java:5016)
> > at
> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
> > at
> >
> org.apache.catalina.core.ContainerBase.addChildInternal(Cont ainerBase.java:812)
> > at
> > org.apache.catalina.core.ContainerBase.addChild(ContainerBas e.java:787)
> > at
> org.apache.catalina.core.StandardHost.addChild(StandardHost. java:570)
> > at
> >
> org.apache.catalina.startup.HostConfig.deployDirectory(HostC onfig.java:1010)
> > at
> >
> org.apache.catalina.startup.HostConfig.deployDirectories(Hos tConfig.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(HostCo nfig.java:308)
> > at
> >
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (LifecycleSupport.java:119)
> > at
> >
> org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(Li fecycleBase.java:89)
> > at
> > org.apache.catalina.util.LifecycleBase.setState(LifecycleBas e.java:328)
> > at
> > org.apache.catalina.util.LifecycleBase.setState(LifecycleBas e.java:308)
> > at
> >
> org.apache.catalina.core.ContainerBase.startInternal(Contain erBase.java:1043)
> > at
> >
> org.apache.catalina.core.StandardHost.startInternal(Standard Host.java:738)
> > at
> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
> > at
> >
> org.apache.catalina.core.ContainerBase.startInternal(Contain erBase.java:1035)
> > at
> >
> org.apache.catalina.core.StandardEngine.startInternal(Standa rdEngine.java:289)
> > at
> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
> > at
> >
> org.apache.catalina.core.StandardService.startInternal(Stand ardService.java:442)
> > at
> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
> > at
> >
> org.apache.catalina.core.StandardServer.startInternal(Standa rdServer.java:674)
> > at
> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.j ava:140)
> > at org.apache.catalina.startup.Catalina.start(Catalina.java:596 )
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
> > at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:597)
> > at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:3 03)
> > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:43 1)
> >
> >
> > ** END NESTED EXCEPTION **
> >
> >
> >
> > Last packet sent to the server was 0 ms ago.
> >
> >
> > --
> > Mit forever
> > My Blog
> > My Faborite Web<
> http://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Compute r-Science/index.htm
> >
> > http://www.technologyreview.com/
> >
>
>
>
> --
> - michael dykman
> - mdykman@gmail.com
>
> May the Source be with you.
>



--
Mit forever
My Blog
My Faborite Web
http://www.technologyreview.com/

--0016363b8fbcd1ceff0499bb9ed6--