stratos-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nirmal Fernando <nirmal070...@gmail.com>
Subject Re: SQL error in EC2 when subscribing to a cartridge
Date Fri, 30 Aug 2013 20:25:50 GMT
On Sat, Aug 31, 2013 at 1:38 AM, Sajith Kariyawasam <sajith@wso2.com> wrote:

> Well, it seems the mysql connector is there already, otherwise, SC would
> not even get started, because the datasource used for Userstore is
> initialized at the startup..
>

Exactly!

>
> But the datasource / connection details defined for Cartridge subscription
> schema is not initialized at server startup, so I think this error comes
> because of some misconfiguration in
> database parameters related to cartridge subscription schema..
>
> As I remember we recently moved those configuration to *-datasources.xml
> file.. didn't we?
>
>
>
Manula, is this the full stack trace?

>
>
> On Fri, Aug 30, 2013 at 11:42 AM, Isuru Haththotuwa <isuruh@wso2.com>wrote:
>
>> Hi Manula,
>>
>> Please check if you have the mysql connector jar (mysql-connector-java v.
>> 5.1.25) in the repository/components/lib of Stratos Controller. If not you
>> need to put it there.
>>
>>
>> On Sat, Aug 31, 2013 at 12:03 AM, Manula Chathurika Thantriwatte <
>> manulac@wso2.com> wrote:
>>
>>>
>>> Hi,
>>>
>>> I'm getting following error when subscribing a cartridge in ec2 with
>>> updated carbon packs.
>>>
>>>
>>> [2013-08-30 18:28:17,180] ERROR
>>> {org.apache.stratos.adc.mgt.service.ApplicationManagementService} -  Error
>>> when getting subscribed cartridges. com.mysql.jdbc.Driver
>>> java.sql.SQLException: com.mysql.jdbc.Driver
>>>     at
>>> org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:254)
>>>     at
>>> org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
>>>     at
>>> org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
>>>     at
>>> org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
>>>     at
>>> org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:488)
>>>     at
>>> org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144)
>>>     at
>>> org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
>>>     at
>>> org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
>>>     at
>>> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
>>>     at
>>> org.apache.stratos.adc.mgt.utils.StratosDBUtils.getConnection(StratosDBUtils.java:130)
>>>     at
>>> org.apache.stratos.adc.mgt.utils.PersistenceManager.retrieveSubscribedCartridges(PersistenceManager.java:170)
>>>     at
>>> org.apache.stratos.adc.mgt.service.ApplicationManagementService.getSubscribedCartridges(ApplicationManagementService.java:234)
>>>     at
>>> org.apache.stratos.adc.mgt.service.ApplicationManagementService.getPagedSubscribedCartridges(ApplicationManagementService.java:212)
>>>     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.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:212)
>>>     at
>>> org.apache.axis2.rpc.receivers.RPCMessageReceiver.invokeBusinessLogic(RPCMessageReceiver.java:117)
>>>     at
>>> org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)
>>>     at
>>> org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110)
>>>     at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180)
>>>     at
>>> org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:169)
>>>     at
>>> org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:82)
>>>     at
>>> org.wso2.carbon.core.transports.local.CarbonLocalTransportSender.finalizeSendWithToAddress(CarbonLocalTransportSender.java:45)
>>>     at
>>> org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:77)
>>>     at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442)
>>>     at
>>> org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:398)
>>>     at
>>> org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:224)
>>>     at
>>> org.apache.axis2.client.OperationClient.execute(OperationClient.java:149)
>>>     at
>>> org.apache.stratos.adc.mgt.stub.ApplicationManagementServiceStub.getPagedSubscribedCartridges(ApplicationManagementServiceStub.java:3142)
>>>     at
>>> org.apache.stratos.cartridge.mgt.ui.CartridgeAdminClient.getPagedSubscribedCartridges(CartridgeAdminClient.java:95)
>>>     at
>>> org.apache.jsp.cartridge_002dmgt.subscribed_005fcartridges_005fajaxprocessor_jsp._jspService(org.apache.jsp.cartridge_002dmgt.subscribed_005fcartridges_005fajaxprocessor_jsp:118)
>>>     at
>>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)
>>>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
>>>     at
>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:403)
>>>     at
>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:492)
>>>     at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:378)
>>>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
>>>     at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:155)
>>>     at
>>> org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:80)
>>>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
>>>     at
>>> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:37)
>>>     at
>>> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
>>>     at
>>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)
>>>     at
>>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68)
>>>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
>>>     at
>>> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68)
>>>     at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>     at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>     at
>>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
>>>     at
>>> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
>>>     at
>>> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
>>>     at
>>> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
>>>     at
>>> org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:30)
>>>     at
>>> org.apache.stratos.redirector.servlet.ui.filters.AllPagesFilter.doFilter(AllPagesFilter.java:159)
>>>     at
>>> org.eclipse.equinox.http.helper.FilterServletAdaptor.service(FilterServletAdaptor.java:37)
>>>     at
>>> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
>>>     at
>>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)
>>>     at
>>> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68)
>>>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
>>>     at
>>> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68)
>>>     at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>     at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>     at
>>> org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61)
>>>     at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
>>>     at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>     at
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>     at
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>     at
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
>>>     at
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>     at
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>     at
>>> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:177)
>>>     at
>>> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:161)
>>>     at
>>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
>>>     at
>>> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57)
>>>     at
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>     at
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
>>>     at
>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
>>>     at
>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>     at
>>> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653)
>>>     at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
>>>     at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
>>>     at java.lang.Thread.run(Thread.java:662)
>>>
>>>
>>> --
>>>  Regards,
>>> Manula Chathurika Thantriwatte
>>> Software Engineer
>>> WSO2 Inc. : http://wso2.com
>>> lean . enterprise . middleware
>>>
>>> email : manulac@wso2.com / manula@apache.org
>>> phone : +94 772492511
>>> blog : http://manulachathurika.blogspot.com/
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> Thanks and Regards,
>>
>> Isuru H.
>>
>>
>>
>
>
> --
> *Sajith Kariyawasam*
> *Senior Software Engineer; WSO2, Inc.*
> *AMIE (SL)*
> *Blog: http://sajithblogs.blogspot.com/*
> *Mobile: +94772269575*
>



-- 
Best Regards,
Nirmal

C.S.Nirmal J. Fernando
Senior Software Engineer,
WSO2 Inc.

Blog: http://nirmalfdo.blogspot.com/

Mime
View raw message