posting the temporary solution just for future reference.
cqlsh in to EVENT_KS key space and run follwoing cql
CREATE INDEX ON org_wso2_social_activity ("payload_context.id")
On Mon, May 19, 2014 at 10:09 PM, Amani Soysa <[email protected]> wrote:
> 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
>
--
With regards,
*Manu*ranga Perera.
phone : 071 7 70 20 50
mail : [email protected]
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
