Hi Evanthika,
This seems to be a MySQL connection related issue.
Thanks,
Senaka.
On Wed, Jun 8, 2011 at 2:02 PM, Evanthika Amarasiri <evanth...@wso2.com>wrote:
> Hi,
>
> I see the following exception when executing G-Reg performance tests on
> Windows. Is this simply because the connection has been lost with mySQL DB?
> Note that I have connected the user store DB to mySQL.
>
>
> ***************************************************************************************************************************************
> The last packet successfully received from the server was 984 milliseconds
> ago. The last packet sent successfully to the server was 984 milliseconds
> ago.
> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
> link failure
>
> The last packet successfully received from the server was 984 milliseconds
> ago. The last packet sent successfully to the server was 984 milliseconds
> ago.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
> at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214)
> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
> at sun.reflect.GeneratedConstructorAccessor102.newInstance(Unknown
> Source)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
> at
> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
>
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
>
> at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1121)
>
> at
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
>
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
>
> at
> org.wso2.carbon.user.core.hybrid.HybridRoleManager.getDBConnection(HybridRoleManager.java:389)
>
> at
> org.wso2.carbon.user.core.hybrid.HybridRoleManager.getHybridRoleListOfUser(HybridRoleManager.java:218)
>
> at
> org.wso2.carbon.user.core.ldap.LDAPUserStoreManager.getRoleListOfUser(LDAPUserStoreManager.java:516)
>
> at
> org.wso2.carbon.user.core.authorization.JDBCAuthorizationManager.isUserAuthorized(JDBCAuthorizationManager.java:132)
>
> at
> org.wso2.carbon.registry.core.jdbc.realm.RegistryAuthorizationManager.isUserAuthorized(RegistryAuthorizationManager.java:169)
>
> at
> org.wso2.carbon.registry.core.utils.AuthorizationUtils.authorize(AuthorizationUtils.java:51)
>
> at
> org.wso2.carbon.registry.app.RegistryResolver.resolve(RegistryResolver.java:505)
>
> at
> org.wso2.carbon.registry.app.RegistryResolver.resolve(RegistryResolver.java:62)
>
> at
> org.apache.abdera.protocol.server.impl.AbstractProvider.resolveTarget(AbstractProvider.java:99)
>
> at
> org.apache.abdera.protocol.server.context.AbstractRequestContext.initTarget(AbstractRequestContext.java:72)
>
> at
> org.apache.abdera.protocol.server.servlet.ServletRequestContext.<init>(ServletRequestContext.java:62)
>
> at
> org.apache.abdera.protocol.server.servlet.AbderaServlet.service(AbderaServlet.java:86)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
> at
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
>
> at
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
>
> at
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
> at
> org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:155)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
>
> at
> org.wso2.carbon.server.TomcatServer$1.invoke(TomcatServer.java:241)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:396)
>
> at
> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:356)
>
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1534)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>
> at java.lang.Thread.run(Thread.java:662)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> Communications link failure
>
> The last packet successfully received from the server was 984 milliseconds
> ago. The last packet sent successfully to the server was 984 mil
> liseconds ago.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3052)
> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2938)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3481)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
> at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
> ... 49 more
> Caused by: java.io.EOFException: Can not read response from server.
> Expected to read 4 bytes, read 0 bytes before connection was unexpectedl
> y lost.
> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2497)
> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2949)
> ... 55 more
> [2011-06-08 11:47:23,093] ERROR
> {org.wso2.carbon.registry.core.utils.AuthorizationUtils} - Could not check
> authorization.
> Caused by Communications link failure
>
> The last packet successfully received from the server was 984 milliseconds
> ago. The last packet sent successfully to the server was 984 mil
> liseconds ago.
> org.wso2.carbon.user.core.UserStoreException: Communications link failure
>
> The last packet successfully received from the server was 984 milliseconds
> ago. The last packet sent successfully to the server was 984 mil
> liseconds ago.
> at
> org.wso2.carbon.user.core.hybrid.HybridRoleManager.getHybridRoleListOfUser(HybridRoleManager.java:235)
>
> at
> org.wso2.carbon.user.core.ldap.LDAPUserStoreManager.getRoleListOfUser(LDAPUserStoreManager.java:516)
>
> at
> org.wso2.carbon.user.core.authorization.JDBCAuthorizationManager.isUserAuthorized(JDBCAuthorizationManager.java:132)
>
> at
> org.wso2.carbon.registry.core.jdbc.realm.RegistryAuthorizationManager.isUserAuthorized(RegistryAuthorizationManager.java:169)
>
> at
> org.wso2.carbon.registry.core.utils.AuthorizationUtils.authorize(AuthorizationUtils.java:51)
>
> at
> org.wso2.carbon.registry.app.RegistryResolver.resolve(RegistryResolver.java:505)
>
> at
> org.wso2.carbon.registry.app.RegistryResolver.resolve(RegistryResolver.java:62)
>
> at
> org.apache.abdera.protocol.server.impl.AbstractProvider.resolveTarget(AbstractProvider.java:99)
>
> at
> org.apache.abdera.protocol.server.context.AbstractRequestContext.initTarget(AbstractRequestContext.java:72)
>
> at
> org.apache.abdera.protocol.server.servlet.ServletRequestContext.<init>(ServletRequestContext.java:62)
>
> at
> org.apache.abdera.protocol.server.servlet.AbderaServlet.service(AbderaServlet.java:86)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
> at
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
>
> at
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
>
> at
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
> at
> org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:155)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
>
> at
> org.wso2.carbon.server.TomcatServer$1.invoke(TomcatServer.java:241)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:396)
>
> at
> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:356)
>
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1534)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>
> at java.lang.Thread.run(Thread.java:662)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> Communications link failure
>
> The last packet successfully received from the server was 984 milliseconds
> ago. The last packet sent successfully to the server was 984 mil
> liseconds ago.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
> at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214)
> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
> at sun.reflect.GeneratedConstructorAccessor102.newInstance(Unknown
> Source)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
> at
> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
>
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
>
> at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1121)
>
> at
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
>
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
>
> at
> org.wso2.carbon.user.core.hybrid.HybridRoleManager.getDBConnection(HybridRoleManager.java:389)
>
> at
> org.wso2.carbon.user.core.hybrid.HybridRoleManager.getHybridRoleListOfUser(HybridRoleManager.java:218)
>
> ... 34 more
> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> Communications link failure
>
> The last packet successfully received from the server was 984 milliseconds
> ago. The last packet sent successfully to the server was 984 mil
> liseconds ago.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3052)
> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2938)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3481)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
> at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
> ... 49 more
> Caused by: java.io.EOFException: Can not read response from server.
> Expected to read 4 bytes, read 0 bytes before connection was unexpectedl
> y lost.
> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2497)
> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2949)
> ... 55 more
>
> Regards,
> Evanthika
>
> _______________________________________________
> Carbon-dev mailing list
> Carbon-dev@wso2.org
> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>
>
--
*Senaka Fernando*
Product Manager - WSO2 Governance Registry;
Associate Technical Lead; WSO2 Inc.; http://wso2.com*
Member; Apache Software Foundation; http://apache.org
E-mail: senaka AT wso2.com
**P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818
Linked-In: http://linkedin.com/in/senakafernando
*Lean . Enterprise . Middleware
_______________________________________________
Carbon-dev mailing list
Carbon-dev@wso2.org
http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
