thanks manjula, we were able to temporary avoid this issue by indexing org_wso2_social_activity CF with payload_context.id
On Mon, May 19, 2014 at 9:49 PM, Manjula Rathnayake <[email protected]>wrote: > Hi Amani, > > These are known intermittent bugs that we have reported at [1], [2]. We > are working with Udara and Manu to get these fixed after moving social > component into turing branch. > > [1]. https://wso2.org/jira/browse/APPFAC-1874 > [2]. https://wso2.org/jira/browse/APPFAC-1862 > > thank you. > > > On Mon, May 19, 2014 at 8:00 PM, Amani Soysa <[email protected]> wrote: > >> Hi All, >> >> We are continuously seeing this error[1] from AF in our cloud deployment, >> and we are using Apache Cassandra 2.0.6 and WSO2 BAM 2.4.1 to publish >> social activity events. Is this a known issue? if so is it possible to get >> a fix for this? >> >> [1] >> TID: [0] [AF] [2014-05-19 07:24:02,614] ERROR >> {org.wso2.carbon.social.ActivityBrowser} - Can't retrieve activities form >> cassandra. {org.wso2.carbon.social.ActivityBrowser} >> java.sql.SQLSyntaxErrorException: No indexed columns present in >> by-columns clause with "equals" operator >> at >> org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.doExecute(CassandraPreparedStatement.java:155) >> at >> org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.executeQuery(CassandraPreparedStatement.java:199) >> at >> org.wso2.carbon.social.ActivityBrowser.listActivities(ActivityBrowser.java:72) >> at >> org.wso2.carbon.social.ActivityBrowser.listActivitiesChronologically(ActivityBrowser.java:123) >> at >> org.wso2.carbon.social.SocialActivityServiceImpl.listActivities(SocialActivityServiceImpl.java:28) >> at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:606) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:42) >> at >> org.jaggeryjs.rhino.appmgt.modules.events.listen.c0._c_anonymous_1(/appmgt/modules/events/listen/listen.jag:21) >> at >> org.jaggeryjs.rhino.appmgt.modules.events.listen.c0.call(/appmgt/modules/events/listen/listen.jag) >> at >> org.mozilla.javascript.ScriptRuntime.applyOrCall(ScriptRuntime.java:2430) >> at >> org.mozilla.javascript.BaseFunction.execIdCall(BaseFunction.java:269) >> at >> org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:97) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:42) >> at >> org.jaggeryjs.rhino.appmgt.modules.events.c0._c_anonymous_2(/appmgt/modules/events/module.jag:8) >> at >> org.jaggeryjs.rhino.appmgt.modules.events.c0.call(/appmgt/modules/events/module.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32) >> at >> org.jaggeryjs.rhino.appmgt.site.blocks.events.listen.ajax.c0._c_anonymous_1(/appmgt/site/blocks/events/listen/ajax/listen.jag:16) >> at >> org.jaggeryjs.rhino.appmgt.site.blocks.events.listen.ajax.c0.call(/appmgt/site/blocks/events/listen/ajax/listen.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.appmgt.site.blocks.events.listen.ajax.c0._c_script_0(/appmgt/site/blocks/events/listen/ajax/listen.jag:5) >> at >> org.jaggeryjs.rhino.appmgt.site.blocks.events.listen.ajax.c0.call(/appmgt/site/blocks/events/listen/ajax/listen.jag) >> at >> org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394) >> at >> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091) >> at >> org.jaggeryjs.rhino.appmgt.site.blocks.events.listen.ajax.c0.call(/appmgt/site/blocks/events/listen/ajax/listen.jag) >> at >> org.jaggeryjs.rhino.appmgt.site.blocks.events.listen.ajax.c0.exec(/appmgt/site/blocks/events/listen/ajax/listen.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:570) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:432) >> at >> org.jaggeryjs.jaggery.core.JaggeryServlet.doPost(JaggeryServlet.java:29) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:755) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> 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:379) >> at >> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339) >> at >> org.jaggeryjs.jaggery.core.JaggeryFilter.doFilter(JaggeryFilter.java:21) >> 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.continueInvocation(CompositeValve.java:178) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:56) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:141) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52) >> 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.runWorker(ThreadPoolExecutor.java:1145) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:744) >> >> >> -- >> Amani Soysa >> Associate Technical Lead >> Mobile: +94772325528 >> WSO2, Inc. | http://wso2.com/ >> Lean . Enterprise . Middleware >> > > > > -- > Manjula Rathnayaka > Software Engineer > WSO2, Inc. > Mobile:+94 77 743 1987 > -- Amani Soysa Associate Technical Lead Mobile: +94772325528 WSO2, Inc. | http://wso2.com/ Lean . Enterprise . Middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
