This is due to the changes done by Sajith to the DB schema recently. We need to update the schema to reflect the new changes. For the moment as a workaround you can add the missing column manually.
On Mon, Nov 25, 2013 at 8:32 PM, Dinesh Bandara <[email protected]> wrote: > Hi, > > I got the following error when subscribe to a cartridge. > > [2013-11-25 14:54:31,368] INFO > {org.apache.stratos.cartridge.mgt.ui.CartridgeAdminClient} - Subscribing > to a Cartridge: php, Alias: php > [2013-11-25 14:54:31,379] INFO > {org.apache.stratos.adc.mgt.service.ApplicationManagementService} - Tenant > dinesh.org is authorized to access Application Management Service! > [2013-11-25 14:54:31,462] INFO > {org.apache.stratos.adc.mgt.subscription.CartridgeSubscription} - External > REPO URL is provided as [https://github.com/sajhak/mytestphp.git]. > Therefore not creating a new repo. > [2013-11-25 14:54:32,484] INFO > {org.apache.stratos.adc.mgt.manager.CartridgeSubscriptionManager} - > Generated key : aijX52veOv2IU25Q > [2013-11-25 14:54:32,485] INFO > {org.apache.stratos.adc.mgt.manager.CartridgeSubscriptionManager} - Tenant > [1] with username [admin subscribed to ] Cartridge Alias php, Cartridge > Type: php, Repo URL: https://github.com/sajhak/mytestphp.git, Policy: > single > [2013-11-25 14:54:32,485] INFO > {org.apache.stratos.adc.mgt.payload.Payload} - ** Payload ** > HOST_NAME=php.php.STRATOS_DOMAIN,TENANT_ID=1,TENANT_RANGE=*,TENANT_CONTEXT= > dinesh.org > ,CARTRIDGE_ALIAS=php,MB_IP=10.134.225.56,MB_PORT=5677,CEP_IP=10.134.225.56,CEP_PORT=7615,CLUSTER_ID=php.php.STRATOS_DOMAIN.php.domain,CARTRIDGE_KEY=aijX52veOv2IU25Q,SERVICE_NAME=php,REPO_INFO_EPR= > https://10.138.50.94:9445/services/RepositoryInformationService,CARTRIDGE_AGENT_EPR=https://10.138.50.94:9447/services/CartridgeAgentService,APP_PATH=/var/www,PORTS=80|443,GIT_REPO=https://github.com/sajhak/mytestphp.git,BAM_IP=10.138.50.94,BAM_PORT=7714,MIN=1,MAX=1,ALARMING_LOWER_RATE=0.2,ALARMING_UPPER_RATE=0.7,MAX_REQUESTS_PER_SEC=5,ROUNDS_TO_AVERAGE=2,SCALE_DOWN_FACTOR=0.25 > [2013-11-25 14:54:32,486] INFO > {org.apache.stratos.adc.mgt.utils.ApplicationManagementUtil} - Register > service.. > > > *[2013-11-25 14:54:32,588] ERROR > {org.apache.stratos.adc.mgt.utils.PersistenceManager} - Unknown column > 'SUBSCRIPTION_KEY' in 'field list' [2013-11-25 14:54:32,588] ERROR > {org.apache.stratos.adc.mgt.utils.PersistenceManager} - Exception : > Unknown column 'SUBSCRIPTION_KEY' in 'field > list'com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown > column 'SUBSCRIPTION_KEY' in 'field list'* > 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:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359) > at > org.apache.stratos.adc.mgt.utils.PersistenceManager.persistSubscription(PersistenceManager.java:392) > at > org.apache.stratos.adc.mgt.manager.CartridgeSubscriptionManager.registerCartridgeSubscription(CartridgeSubscriptionManager.java:282) > at > org.apache.stratos.adc.mgt.service.ApplicationManagementService.subscribe(ApplicationManagementService.java:428) > 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.subscribe(ApplicationManagementServiceStub.java:500) > at > org.apache.stratos.cartridge.mgt.ui.CartridgeAdminClient.subscribeToCartridge(CartridgeAdminClient.java:240) > at > org.apache.jsp.cartridge_002dmgt.subscribe_005fajaxprocessor_jsp._jspService(org.apache.jsp.cartridge_002dmgt.subscribe_005fajaxprocessor_jsp:107) > 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:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:662) > [2013-11-25 14:54:32,591] ERROR > {org.apache.stratos.adc.mgt.manager.CartridgeSubscriptionManager} - Error > saving subscription for tenant dinesh.org, alias php > [2013-11-25 14:54:32,594] ERROR > {org.apache.stratos.cartridge.mgt.ui.CartridgeAdminClient} - Subscribe > unsuccessful > org.apache.stratos.adc.mgt.stub.ApplicationManagementServiceADCExceptionException: > ApplicationManagementServiceADCExceptionException > 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 java.lang.Class.newInstance0(Class.java:355) > at java.lang.Class.newInstance(Class.java:308) > at > org.apache.stratos.adc.mgt.stub.ApplicationManagementServiceStub.subscribe(ApplicationManagementServiceStub.java:525) > at > org.apache.stratos.cartridge.mgt.ui.CartridgeAdminClient.subscribeToCartridge(CartridgeAdminClient.java:240) > at > org.apache.jsp.cartridge_002dmgt.subscribe_005fajaxprocessor_jsp._jspService(org.apache.jsp.cartridge_002dmgt.subscribe_005fajaxprocessor_jsp:107) > 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:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:662) > > > -- > *Dinesh Bandara* > Software Engineer > WSO2 Inc.; http://wso2.com > lean.enterprise.middleware > > -- Thanks and Regards, Isuru H. Software Engineer, WSO2 Inc. +94 716 358 048* <http://wso2.com/>*
