Hi Jorge, I would like to add a comment about one of the errors[1] you have mentioned in your mail.
[1] TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR {org.apache.hadoop.util.Shell} - Failed to locate the winutils binary in the hadoop binary path {org.apache.hadoop.util.Shell} java.io.IOException: Could not locate executable null\bin\winutils.exe in the Hadoop binaries. Above error is related to Hadoop.The error says some files that required for hadoop to run on your OS are missing.According to what i have found out about this, if you are using binary distribution of Apache Hadoop 2.2.0 on windows environment, this issue arises. Please go through the below post[2] to find out more about this error. [2]http://blog.intelligencecomputing.io/big_data/13878/repost-error-util-shell-failed-to-locate-the-winutils-binary-in-the-hadoop-binary-path Regards, Nayomi Nayomi Dayarathne Software Engineer-QA Mobile : +94 (0) 775246619 nay...@wso2.com On Mon, Nov 9, 2015 at 6:57 PM, Jorge <isildur...@gmail.com> wrote: > Hi Niranda, any idea about this issue? > > Regards, > Jorge. > > 2015-11-03 19:43 GMT-05:00 Jorge <isildur...@gmail.com>: >> >> Hi Niranda, >> I try with this query: SELECT COUNT(temp) FROM >> temperaturasfechadesagregada >> >> And the result = 20596 >> >> Attached the log with the errors and warnings, the main issues: >> >> The errors: >> >> TID: [-1234] [] [2015-11-03 18:36:55,956] ERROR >> {org.apache.hadoop.util.Shell} - Failed to locate the winutils binary >> in the hadoop binary path {org.apache.hadoop.util.Shell} >> java.io.IOException: Could not locate executable null\bin\winutils.exe >> in the Hadoop binaries. >> >> TID: [-1234] [] [2015-11-03 18:40:15,960] INFO >> {org.apache.axis2.transport.http.HTTPSender} - Unable to sendViaPost >> to url[https://169.254.56.94:9443/services/AnalyticsWebService] >> {org.apache.axis2.transport.http.HTTPSender} >> java.net.SocketTimeoutException: Read timed out >> at java.net.SocketInputStream.socketRead0(Native Method) >> at java.net.SocketInputStream.read(SocketInputStream.java:150) >> at java.net.SocketInputStream.read(SocketInputStream.java:121) >> at sun.security.ssl.InputRecord.readFully(InputRecord.java:442) >> at sun.security.ssl.InputRecord.read(InputRecord.java:480) >> at >> sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927) >> at >> sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:884) >> at sun.security.ssl.AppInputStream.read(AppInputStream.java:102) >> at java.io.BufferedInputStream.fill(BufferedInputStream.java:235) >> at java.io.BufferedInputStream.read(BufferedInputStream.java:254) >> at >> org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78) >> at >> org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106) >> at >> org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) >> at >> org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) >> at >> org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) >> at >> org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) >> at >> org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) >> at >> org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) >> at >> org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) >> at >> org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) >> at >> org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:630) >> at >> org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:195) >> at >> org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:451) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:278) >> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) >> at >> org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:430) >> at >> org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:225) >> at >> org.apache.axis2.client.OperationClient.execute(OperationClient.java:149) >> at >> org.wso2.carbon.analytics.webservice.stub.AnalyticsWebServiceStub.getByRange(AnalyticsWebServiceStub.java:1762) >> at >> org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector.getRecordsByRange(AnalyticsWebServiceConnector.java:424) >> at >> org.wso2.carbon.analytics.jsservice.AnalyticsCachedWebServiceConnector.getRecordsByRange(AnalyticsCachedWebServiceConnector.java:101) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2._c_anonymous_1(/portal/controllers/apis/analytics.jag:194) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2.call(/portal/controllers/apis/analytics.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2._c_script_0(/portal/controllers/apis/analytics.jag:2) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2.call(/portal/controllers/apis/analytics.jag) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2.exec(/portal/controllers/apis/analytics.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.java:148) >> at sun.reflect.GeneratedMethodAccessor95.invoke(Unknown Source) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:63) >> at >> org.jaggeryjs.rhino.portal.routers.c2._c_anonymous_1(/portal/routers/apis.jag:22) >> at >> org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.portal.routers.c2._c_script_0(/portal/routers/apis.jag:4) >> at >> org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) >> at >> org.jaggeryjs.rhino.portal.routers.c2.exec(/portal/routers/apis.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.java:148) >> at sun.reflect.GeneratedMethodAccessor95.invoke(Unknown Source) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:63) >> at >> org.jaggeryjs.rhino.portal.routers.c1._c_anonymous_1(/portal/routers/tenant.jag:67) >> at >> org.jaggeryjs.rhino.portal.routers.c1.call(/portal/routers/tenant.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.portal.routers.c1._c_script_0(/portal/routers/tenant.jag:11) >> at >> org.jaggeryjs.rhino.portal.routers.c1.call(/portal/routers/tenant.jag) >> at >> org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394) >> at >> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091) >> at >> org.jaggeryjs.rhino.portal.routers.c1.call(/portal/routers/tenant.jag) >> at >> org.jaggeryjs.rhino.portal.routers.c1.exec(/portal/routers/tenant.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.exec(WebAppManager.java:587) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:507) >> at >> org.jaggeryjs.jaggery.core.JaggeryServlet.doGet(JaggeryServlet.java:24) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) >> at >> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) >> at >> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) >> at >> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) >> at >> org.jaggeryjs.jaggery.core.JaggeryFilter.doFilter(JaggeryFilter.java:21) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:57) >> at >> org.wso2.carbon.event.receiver.core.internal.tenantmgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:48) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:62) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:159) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1739) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1698) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >> at java.lang.Thread.run(Thread.java:722) >> TID: [-1234] [] [2015-11-03 18:40:15,961] ERROR >> {org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector} - >> failed to get records from table: 'TEMPERATURAS_FECHA_DESAGREGADA', >> Read timed out >> {org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector} >> org.apache.axis2.AxisFault: Read timed out >> at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430) >> at >> org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:199) >> at >> org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:451) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:278) >> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) >> at >> org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:430) >> at >> org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:225) >> at >> org.apache.axis2.client.OperationClient.execute(OperationClient.java:149) >> at >> org.wso2.carbon.analytics.webservice.stub.AnalyticsWebServiceStub.getByRange(AnalyticsWebServiceStub.java:1762) >> at >> org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector.getRecordsByRange(AnalyticsWebServiceConnector.java:424) >> at >> org.wso2.carbon.analytics.jsservice.AnalyticsCachedWebServiceConnector.getRecordsByRange(AnalyticsCachedWebServiceConnector.java:101) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2._c_anonymous_1(/portal/controllers/apis/analytics.jag:194) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2.call(/portal/controllers/apis/analytics.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2._c_script_0(/portal/controllers/apis/analytics.jag:2) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2.call(/portal/controllers/apis/analytics.jag) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c2.exec(/portal/controllers/apis/analytics.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.java:148) >> at sun.reflect.GeneratedMethodAccessor95.invoke(Unknown Source) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:63) >> at >> org.jaggeryjs.rhino.portal.routers.c2._c_anonymous_1(/portal/routers/apis.jag:22) >> at >> org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.portal.routers.c2._c_script_0(/portal/routers/apis.jag:4) >> at >> org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) >> at >> org.jaggeryjs.rhino.portal.routers.c2.exec(/portal/routers/apis.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.java:148) >> at sun.reflect.GeneratedMethodAccessor95.invoke(Unknown Source) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:63) >> at >> org.jaggeryjs.rhino.portal.routers.c1._c_anonymous_1(/portal/routers/tenant.jag:67) >> at >> org.jaggeryjs.rhino.portal.routers.c1.call(/portal/routers/tenant.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.portal.routers.c1._c_script_0(/portal/routers/tenant.jag:11) >> at >> org.jaggeryjs.rhino.portal.routers.c1.call(/portal/routers/tenant.jag) >> at >> org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394) >> at >> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091) >> at >> org.jaggeryjs.rhino.portal.routers.c1.call(/portal/routers/tenant.jag) >> at >> org.jaggeryjs.rhino.portal.routers.c1.exec(/portal/routers/tenant.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.exec(WebAppManager.java:587) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:507) >> at >> org.jaggeryjs.jaggery.core.JaggeryServlet.doGet(JaggeryServlet.java:24) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) >> at >> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) >> at >> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) >> at >> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) >> at >> org.jaggeryjs.jaggery.core.JaggeryFilter.doFilter(JaggeryFilter.java:21) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:57) >> at >> org.wso2.carbon.event.receiver.core.internal.tenantmgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:48) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:62) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:159) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1739) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1698) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >> at java.lang.Thread.run(Thread.java:722) >> Caused by: java.net.SocketTimeoutException: Read timed out >> at java.net.SocketInputStream.socketRead0(Native Method) >> at java.net.SocketInputStream.read(SocketInputStream.java:150) >> at java.net.SocketInputStream.read(SocketInputStream.java:121) >> at sun.security.ssl.InputRecord.readFully(InputRecord.java:442) >> at sun.security.ssl.InputRecord.read(InputRecord.java:480) >> at >> sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927) >> at >> sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:884) >> at sun.security.ssl.AppInputStream.read(AppInputStream.java:102) >> at java.io.BufferedInputStream.fill(BufferedInputStream.java:235) >> at java.io.BufferedInputStream.read(BufferedInputStream.java:254) >> at >> org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78) >> at >> org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106) >> at >> org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) >> at >> org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) >> at >> org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) >> at >> org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) >> at >> org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) >> at >> org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) >> at >> org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) >> at >> org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) >> at >> org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:630) >> at >> org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:195) >> ... 101 more >> >> >> >> The WARNs: >> >> TID: [-1234] [] [2015-11-03 18:39:44,189] WARN >> {org.apache.shindig.gadgets.features.FeatureResourceLoader} - The >> remote library from http://www.google-analytics.com/urchin.js cannot >> be retrieved. {org.apache.shindig.gadgets.features.FeatureResourceLoader} >> >> TID: [-1234] [] [2015-11-03 18:39:44,192] WARN >> {org.apache.shindig.gadgets.features.FeatureResourceLoader} - The >> remote library from http://www.google.com/ig/lib/libanalytics.js >> cannot be retrieved. >> {org.apache.shindig.gadgets.features.FeatureResourceLoader} >> >> TID: [-1234] [] [2015-11-03 18:39:44,194] WARN >> {org.apache.shindig.gadgets.features.FeatureResourceLoader} - The >> remote library from http://www.google.com/ig/lib/libga.js cannot be >> retrieved. {org.apache.shindig.gadgets.features.FeatureResourceLoader} >> >> TID: [-1234] [] [2015-11-03 18:39:44,808] WARN >> {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 >> object references was reached while attempting to calculate the size >> of the object graph. This can be avoided by adding stop points with >> @IgnoreSizeOf annotations. Since the CacheManger or Cache >> <sizeOfPolicy> elements maxDepthExceededBehavior is set to "abort", >> the sizing operation has stopped and the reported cache size is not >> accurate. If performance degradation is NOT an issue at the configured >> limit, raise the limit value using the CacheManager or Cache >> <sizeOfPolicy> elements maxDepth attribute. For more information, see >> the Ehcache configuration documentation. >> {net.sf.ehcache.pool.sizeof.SizeOf} >> >> TID: [-1234] [] [2015-11-03 18:39:44,815] WARN >> {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 >> object references was reached while attempting to calculate the size >> of the object graph. This can be avoided by adding stop points with >> @IgnoreSizeOf annotations. Since the CacheManger or Cache >> <sizeOfPolicy> elements maxDepthExceededBehavior is set to "abort", >> the sizing operation has stopped and the reported cache size is not >> accurate. If performance degradation is NOT an issue at the configured >> limit, raise the limit value using the CacheManager or Cache >> <sizeOfPolicy> elements maxDepth attribute. For more information, see >> the Ehcache configuration documentation. >> {net.sf.ehcache.pool.sizeof.SizeOf} >> >> TID: [-1234] [] [2015-11-03 18:39:45,077] WARN >> {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 >> object references was reached while attempting to calculate the size >> of the object graph. This can be avoided by adding stop points with >> @IgnoreSizeOf annotations. Since the CacheManger or Cache >> <sizeOfPolicy> elements maxDepthExceededBehavior is set to "abort", >> the sizing operation has stopped and the reported cache size is not >> accurate. If performance degradation is NOT an issue at the configured >> limit, raise the limit value using the CacheManager or Cache >> <sizeOfPolicy> elements maxDepth attribute. For more information, see >> the Ehcache configuration documentation. >> {net.sf.ehcache.pool.sizeof.SizeOf} >> >> TID: [-1234] [] [2015-11-03 18:39:45,080] WARN >> {net.sf.ehcache.pool.sizeof.SizeOf} - The configured limit of 1.000 >> object references was reached while attempting to calculate the size >> of the object graph. This can be avoided by adding stop points with >> @IgnoreSizeOf annotations. Since the CacheManger or Cache >> <sizeOfPolicy> elements maxDepthExceededBehavior is set to "abort", >> the sizing operation has stopped and the reported cache size is not >> accurate. If performance degradation is NOT an issue at the configured >> limit, raise the limit value using the CacheManager or Cache >> <sizeOfPolicy> elements maxDepth attribute. For more information, see >> the Ehcache configuration documentation. >> {net.sf.ehcache.pool.sizeof.SizeOf} >> >> Thanks, >> Jorge >> >> De: Niranda Perera [mailto:nira...@wso2.com] >> Enviado el: sábado, 31 de octubre de 2015 23:49 >> Para: Jorge <isildur...@gmail.com> >> CC: WSO2 Developers' List <dev@wso2.org> >> Asunto: Re: [Dev] WSO2 DAS 3.0.0 issue: failed to get records from table >> >> Hi Jorge, >> >> Do you have an idea about how big the 'TEMPERATURAS_FECHA_DESAGREGADA' >> table is? the number of rows the table may be? >> >> rgds >> >> On Sun, Nov 1, 2015 at 4:15 AM, Jorge <isildur...@gmail.com> wrote: >> Hi all. >> I´m facing a issue similar to this one: >> http://mail.wso2.org/mailarchive/dev/2015-August/054016.html >> >> I can see the data in my table and when I created the gadget I saw the >> data in the preview. but after stored the gadget I try to see the >> dashboard and this error appears in DAS console: >> >> >> [2015-10-31 18:35:47,642] ERROR >> {org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector} - >> failed to get records from table: 'TEMPERATURAS_FECHA_DESAGREGADA', >> Read timed o >> ut >> org.apache.axis2.AxisFault: Read timed out >> at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430) >> at >> org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:199) >> at >> org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:77) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:451) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:278) >> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) >> at >> org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:430) >> at >> org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:225) >> at >> org.apache.axis2.client.OperationClient.execute(OperationClient.java:149) >> at >> org.wso2.carbon.analytics.webservice.stub.AnalyticsWebServiceStub.getByRange(AnalyticsWebServiceStub.java:1762) >> at >> org.wso2.carbon.analytics.jsservice.AnalyticsWebServiceConnector.getRecordsByRange(AnalyticsWebServiceConnector.java:424) >> at >> org.wso2.carbon.analytics.jsservice.AnalyticsCachedWebServiceConnector.getRecordsByRange(AnalyticsCachedWebServiceConnector.java:101) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c1._c_anonymous_1(/portal/controllers/apis/analytics.jag:194) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c1.call(/portal/controllers/apis/analytics.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c1._c_script_0(/portal/controllers/apis/analytics.jag:2) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c1.call(/portal/controllers/apis/analytics.jag) >> at >> org.jaggeryjs.rhino.portal.controllers.apis.c1.exec(/portal/controllers/apis/analytics.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.java:148) >> at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:63) >> at >> org.jaggeryjs.rhino.portal.routers.c2._c_anonymous_1(/portal/routers/apis.jag:22) >> at >> org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.portal.routers.c2._c_script_0(/portal/routers/apis.jag:4) >> at >> org.jaggeryjs.rhino.portal.routers.c2.call(/portal/routers/apis.jag) >> at >> org.jaggeryjs.rhino.portal.routers.c2.exec(/portal/routers/apis.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.executeScript(WebAppManager.java:308) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.include(WebAppManager.java:148) >> at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126) >> at >> org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:63) >> at >> org.jaggeryjs.rhino.portal.routers.c1._c_anonymous_1(/portal/routers/tenant.jag:67) >> at >> org.jaggeryjs.rhino.portal.routers.c1.call(/portal/routers/tenant.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23) >> at >> org.jaggeryjs.rhino.portal.routers.c1._c_script_0(/portal/routers/tenant.jag:11) >> at >> org.jaggeryjs.rhino.portal.routers.c1.call(/portal/routers/tenant.jag) >> at >> org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394) >> at >> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091) >> at >> org.jaggeryjs.rhino.portal.routers.c1.call(/portal/routers/tenant.jag) >> at >> org.jaggeryjs.rhino.portal.routers.c1.exec(/portal/routers/tenant.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:567) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:273) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.exec(WebAppManager.java:587) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:507) >> at >> org.jaggeryjs.jaggery.core.JaggeryServlet.doGet(JaggeryServlet.java:24) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) >> at >> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) >> at >> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) >> at >> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) >> at >> org.jaggeryjs.jaggery.core.JaggeryFilter.doFilter(JaggeryFilter.java:21) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:57) >> at >> org.wso2.carbon.event.receiver.core.internal.tenantmgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:48) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:62) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:159) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1739) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1698) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >> at java.lang.Thread.run(Thread.java:722) >> Caused by: java.net.SocketTimeoutException: Read timed out >> at java.net.SocketInputStream.socketRead0(Native Method) >> at java.net.SocketInputStream.read(SocketInputStream.java:150) >> at java.net.SocketInputStream.read(SocketInputStream.java:121) >> at sun.security.ssl.InputRecord.readFully(InputRecord.java:442) >> at sun.security.ssl.InputRecord.read(InputRecord.java:480) >> at >> sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927) >> at >> sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:884) >> at sun.security.ssl.AppInputStream.read(AppInputStream.java:102) >> at java.io.BufferedInputStream.fill(BufferedInputStream.java:235) >> at java.io.BufferedInputStream.read(BufferedInputStream.java:254) >> at >> org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78) >> at >> org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106) >> at >> org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) >> at >> org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) >> at >> org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) >> at >> org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) >> at >> org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) >> at >> org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) >> at >> org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) >> at >> org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) >> at >> org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.java:630) >> at >> org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:195) >> ... 101 more >> >> >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> >> >> >> -- >> Niranda Perera >> Software Engineer, WSO2 Inc. >> Mobile: +94-71-554-8430 >> Twitter: @n1r44 >> https://pythagoreanscript.wordpress.com/ > > > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > _______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev