Hi, Yeah, check [1] for more info. Seems the same H2 database is used by two JVMs, so the second one tries to connect using a network connection.
[1] http://h2database.com/html/features.html#auto_mixed_mode Cheers, Anjana. On Wed, Mar 16, 2016 at 12:29 PM, Niranda Perera <[email protected]> wrote: > + anjana > > Hi Charitha, > > looks like this is a concurrency issue in H2. > > the IP of the H2 db will be governed by the datasource, which is > configured in the analytic-datasources.xml > @anjana, I remember, there was a configuration in H2, to handle concurrent > db calls? isn't that so? > > best > > > On Wed, Mar 16, 2016 at 12:18 PM, Charitha Goonetilleke < > [email protected]> wrote: > >> Hi All, >> >> In IoT Server we are having following intermittent error. Seems IoT >> server tries to connect to 198.105.254.11 during summarization task. I'm >> wondering how this IP is in there and why. >> >> [2016-03-16 12:10:17,044] ERROR >> {org.wso2.carbon.analytics.spark.core.sources.AnalyticsRelation} - Error >> while inserting data into table DEVICE_ACCELEROMETER_SUMMARY : Error in >> deleting table: Exception opening port "H2 TCP Server (tcp:// >> 198.105.254.11:40762)" (port may be in use), cause: "timeout" [90061-140] >> org.wso2.carbon.analytics.datasource.commons.exception.AnalyticsException: >> Error in deleting table: Exception opening port "H2 TCP Server (tcp:// >> 198.105.254.11:40762)" (port may be in use), cause: "timeout" [90061-140] >> at >> org.wso2.carbon.analytics.datasource.rdbms.RDBMSAnalyticsRecordStore.deleteTable(RDBMSAnalyticsRecordStore.java:582) >> at >> org.wso2.carbon.analytics.dataservice.core.AnalyticsDataServiceImpl.deleteTable(AnalyticsDataServiceImpl.java:542) >> at >> org.wso2.carbon.analytics.spark.core.sources.AnalyticsRelation.insert(AnalyticsRelation.java:157) >> at >> org.apache.spark.sql.sources.InsertIntoDataSource.run(commands.scala:53) >> at >> org.apache.spark.sql.execution.ExecutedCommand.sideEffectResult$lzycompute(commands.scala:57) >> at >> org.apache.spark.sql.execution.ExecutedCommand.sideEffectResult(commands.scala:57) >> at >> org.apache.spark.sql.execution.ExecutedCommand.doExecute(commands.scala:68) >> at >> org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:88) >> at >> org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:88) >> at >> org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:147) >> at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:87) >> at >> org.apache.spark.sql.SQLContext$QueryExecution.toRdd$lzycompute(SQLContext.scala:950) >> at >> org.apache.spark.sql.SQLContext$QueryExecution.toRdd(SQLContext.scala:950) >> at org.apache.spark.sql.DataFrame.<init>(DataFrame.scala:144) >> at org.apache.spark.sql.DataFrame.<init>(DataFrame.scala:128) >> at org.apache.spark.sql.DataFrame$.apply(DataFrame.scala:51) >> at org.apache.spark.sql.SQLContext.sql(SQLContext.scala:755) >> at >> org.wso2.carbon.analytics.spark.core.internal.SparkAnalyticsExecutor.executeQueryLocal(SparkAnalyticsExecutor.java:766) >> at >> org.wso2.carbon.analytics.spark.core.internal.SparkAnalyticsExecutor.executeQuery(SparkAnalyticsExecutor.java:742) >> at >> org.wso2.carbon.analytics.spark.core.CarbonAnalyticsProcessorService.executeQuery(CarbonAnalyticsProcessorService.java:201) >> at >> org.wso2.carbon.analytics.spark.core.CarbonAnalyticsProcessorService.executeScript(CarbonAnalyticsProcessorService.java:151) >> at >> org.wso2.carbon.analytics.spark.core.AnalyticsTask.execute(AnalyticsTask.java:59) >> at >> org.wso2.carbon.ntask.core.impl.TaskQuartzJobAdapter.execute(TaskQuartzJobAdapter.java:67) >> at org.quartz.core.JobRunShell.run(JobRunShell.java:213) >> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) >> at java.util.concurrent.FutureTask.run(FutureTask.java:262) >> 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:745) >> >> -- >> *Charitha Goonetilleke* >> Software Engineer >> WSO2 Inc.; http://wso2.com >> lean.enterprise.middleware >> >> mobile: +94 77 751 3669 <%2B94777513669> >> Twitter:@CharithaWs <https://twitter.com/CharithaWs>, fb: charithag >> <https://www.facebook.com/charithag>, linkedin: charithag >> <http://www.linkedin.com/in/charithag> >> > > > > -- > *Niranda Perera* > Software Engineer, WSO2 Inc. > Mobile: +94-71-554-8430 > Twitter: @n1r44 <https://twitter.com/N1R44> > https://pythagoreanscript.wordpress.com/ > -- *Anjana Fernando* Senior Technical Lead WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
