Hi, When a port offset is applied to BAM 2.5.0, it'll automatically increment the ports of all Cassandra data sources if they have been pointed to embedded Cassandra instance. So there's no need to manually edit <BAM_HOME>/repository/conf/bam-datasources.xml file anymore.
For more information on BAM 2.5.0 port offset configuration, refer [1] For BAM 2.4.1 port offset configurations, refer [2] [1] https://docs.wso2.com/display/BAM250/Port+Offset [2] https://docs.wso2.com/display/BAM241/Port+Offset Regards, Dunith On Wed, Oct 22, 2014 at 4:03 PM, Lakshman Udayakantha <[email protected]> wrote: > Hi All, > > As per the offline discussion with Maninda, after changing the port offset > to another value rather than zero, it shouldn't change the port for > WSO2BAM_CASSANDRA_DATASOURCE in bam-datasource.xml in BAM 2.5.0. with that > change setup is working properly > > Thanks > > On Wed, Oct 22, 2014 at 1:55 PM, Lakshman Udayakantha <[email protected]> > wrote: > >> Hi All, >> >> I am trying to integrate BAM 2.5.0 with APIM 1.8.0. I followed >> https://docs.wso2.com/display/AM170/Publishing+API+Runtime+Statistics to >> do this. After I configured BAM and started it, got the following exception >> and can’t publish the data. anyone has any idea about this error? >> >> >> [2014-10-22 13:42:00,008] INFO >> {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Running >> script executor task for script am_stats_analyzer. [Wed Oct 22 13:42:00 >> GMT+05:30 2014] >> >> Hive history >> file=/Users/lakshman/Documents/wso2_products/BAM/wso2bam-2.5.0/tmp/hive/root-querylogs/hive_job_log_lakshman_201410221342_1864185710.txt >> >> 2014-10-22 13:42:00.943 java[15403:9407] Unable to load realm info from >> SCDynamicStore >> >> [2014-10-22 13:42:01,367] ERROR >> {org.apache.hadoop.hive.cassandra.CassandraProxyClient} - Error while >> trying to connect to cassandra host:localhost >> >> org.apache.hadoop.hive.cassandra.CassandraException: unable to connect to >> server >> >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:65) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:40) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.createConnection(CassandraProxyClient.java:200) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:226) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) >> >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) >> >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225) >> >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:129) >> >> at >> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) >> >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) >> >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) >> >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) >> >> at >> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:201) >> >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:578) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> Caused by: org.apache.thrift.transport.TTransportException: >> java.net.ConnectException: Connection refused >> >> at org.apache.thrift.transport.TSocket.open(TSocket.java:183) >> >> at >> org.apache.thrift.transport.TFramedTransport.open(TFramedTransport.java:81) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:63) >> >> ... 25 more >> >> Caused by: java.net.ConnectException: Connection refused >> >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> >> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:382) >> >> at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:241) >> >> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228) >> >> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:431) >> >> at java.net.Socket.connect(Socket.java:527) >> >> at org.apache.thrift.transport.TSocket.open(TSocket.java:178) >> >> ... 27 more >> >> FAILED: Error in metadata: java.lang.NullPointerException >> >> [2014-10-22 13:42:01,370] ERROR {org.apache.hadoop.hive.ql.exec.Task} - >> FAILED: Error in metadata: java.lang.NullPointerException >> >> org.apache.hadoop.hive.ql.metadata.HiveException: >> java.lang.NullPointerException >> >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:546) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225) >> >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:129) >> >> at >> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) >> >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) >> >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) >> >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) >> >> at >> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:201) >> >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:578) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> Caused by: java.lang.NullPointerException >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:242) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) >> >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) >> >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) >> >> ... 17 more >> >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask >> >> [2014-10-22 13:42:01,371] ERROR {org.apache.hadoop.hive.ql.Driver} - >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask >> >> [2014-10-22 13:42:01,381] ERROR >> {org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl} - Error >> while executing Hive script. >> >> Query returned non-zero code: 9, cause: FAILED: Execution Error, return >> code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> >> java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: >> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:578) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> [2014-10-22 13:42:01,382] ERROR >> {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while >> executing script : am_stats_analyzer >> >> org.wso2.carbon.analytics.hive.exception.HiveExecutionException: Error >> while executing Hive script.Query returned non-zero code: 9, cause: FAILED: >> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl.execute(HiveExecutorServiceImpl.java:115) >> >> at >> org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask.execute(HiveScriptExecutorTask.java:70) >> >> 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:439) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> [2014-10-22 13:44:00,003] INFO >> {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Running >> script executor task for script am_stats_analyzer. [Wed Oct 22 13:44:00 >> GMT+05:30 2014] >> >> Hive history >> file=/Users/lakshman/Documents/wso2_products/BAM/wso2bam-2.5.0/tmp/hive/root-querylogs/hive_job_log_lakshman_201410221342_967516897.txt >> >> [2014-10-22 13:44:00,054] ERROR >> {org.apache.hadoop.hive.cassandra.CassandraProxyClient} - Error while >> trying to connect to cassandra host:localhost >> >> org.apache.hadoop.hive.cassandra.CassandraException: unable to connect to >> server >> >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:65) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:40) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.createConnection(CassandraProxyClient.java:200) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:226) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) >> >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) >> >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225) >> >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:129) >> >> at >> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) >> >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) >> >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) >> >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) >> >> at >> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:201) >> >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:578) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> Caused by: org.apache.thrift.transport.TTransportException: >> java.net.ConnectException: Connection refused >> >> at org.apache.thrift.transport.TSocket.open(TSocket.java:183) >> >> at >> org.apache.thrift.transport.TFramedTransport.open(TFramedTransport.java:81) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:63) >> >> ... 25 more >> >> Caused by: java.net.ConnectException: Connection refused >> >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> >> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:382) >> >> at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:241) >> >> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228) >> >> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:431) >> >> at java.net.Socket.connect(Socket.java:527) >> >> at org.apache.thrift.transport.TSocket.open(TSocket.java:178) >> >> ... 27 more >> >> FAILED: Error in metadata: java.lang.NullPointerException >> >> [2014-10-22 13:44:00,056] ERROR {org.apache.hadoop.hive.ql.exec.Task} - >> FAILED: Error in metadata: java.lang.NullPointerException >> >> org.apache.hadoop.hive.ql.metadata.HiveException: >> java.lang.NullPointerException >> >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:546) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225) >> >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:129) >> >> at >> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) >> >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) >> >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) >> >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) >> >> at >> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:201) >> >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:578) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> Caused by: java.lang.NullPointerException >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:242) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) >> >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) >> >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) >> >> ... 17 more >> >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask >> >> [2014-10-22 13:44:00,056] ERROR {org.apache.hadoop.hive.ql.Driver} - >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask >> >> [2014-10-22 13:44:00,057] ERROR >> {org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl} - Error >> while executing Hive script. >> >> Query returned non-zero code: 9, cause: FAILED: Execution Error, return >> code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> >> java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: >> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:578) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> [2014-10-22 13:44:00,058] ERROR >> {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while >> executing script : am_stats_analyzer >> >> org.wso2.carbon.analytics.hive.exception.HiveExecutionException: Error >> while executing Hive script.Query returned non-zero code: 9, cause: FAILED: >> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl.execute(HiveExecutorServiceImpl.java:115) >> >> at >> org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask.execute(HiveScriptExecutorTask.java:70) >> >> 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:439) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> [2014-10-22 13:46:00,001] INFO >> {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Running >> script executor task for script am_stats_analyzer. [Wed Oct 22 13:46:00 >> GMT+05:30 2014] >> >> Hive history >> file=/Users/lakshman/Documents/wso2_products/BAM/wso2bam-2.5.0/tmp/hive/root-querylogs/hive_job_log_lakshman_201410221342_776696658.txt >> >> [2014-10-22 13:46:00,041] ERROR >> {org.apache.hadoop.hive.cassandra.CassandraProxyClient} - Error while >> trying to connect to cassandra host:localhost >> >> org.apache.hadoop.hive.cassandra.CassandraException: unable to connect to >> server >> >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:65) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:40) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.createConnection(CassandraProxyClient.java:200) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:226) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) >> >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) >> >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225) >> >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:129) >> >> at >> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) >> >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) >> >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) >> >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) >> >> at >> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:201) >> >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:578) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> Caused by: org.apache.thrift.transport.TTransportException: >> java.net.ConnectException: Connection refused >> >> at org.apache.thrift.transport.TSocket.open(TSocket.java:183) >> >> at >> org.apache.thrift.transport.TFramedTransport.open(TFramedTransport.java:81) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:63) >> >> ... 25 more >> >> Caused by: java.net.ConnectException: Connection refused >> >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> >> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:382) >> >> at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:241) >> >> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228) >> >> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:431) >> >> at java.net.Socket.connect(Socket.java:527) >> >> at org.apache.thrift.transport.TSocket.open(TSocket.java:178) >> >> ... 27 more >> >> FAILED: Error in metadata: java.lang.NullPointerException >> >> [2014-10-22 13:46:00,042] ERROR {org.apache.hadoop.hive.ql.exec.Task} - >> FAILED: Error in metadata: java.lang.NullPointerException >> >> org.apache.hadoop.hive.ql.metadata.HiveException: >> java.lang.NullPointerException >> >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:546) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479) >> >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225) >> >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:129) >> >> at >> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) >> >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) >> >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) >> >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) >> >> at >> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:201) >> >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:578) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> Caused by: java.lang.NullPointerException >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:242) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) >> >> at >> org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) >> >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) >> >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) >> >> ... 17 more >> >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask >> >> [2014-10-22 13:46:00,042] ERROR {org.apache.hadoop.hive.ql.Driver} - >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask >> >> [2014-10-22 13:46:00,042] ERROR >> {org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl} - Error >> while executing Hive script. >> >> Query returned non-zero code: 9, cause: FAILED: Execution Error, return >> code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> >> java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: >> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:578) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> [2014-10-22 13:46:00,043] ERROR >> {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while >> executing script : am_stats_analyzer >> >> org.wso2.carbon.analytics.hive.exception.HiveExecutionException: Error >> while executing Hive script.Query returned non-zero code: 9, cause: FAILED: >> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl.execute(HiveExecutorServiceImpl.java:115) >> >> at >> org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask.execute(HiveScriptExecutorTask.java:70) >> >> 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:439) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> >> at java.lang.Thread.run(Thread.java:695) >> >> Thanks >> -- >> Lakshman Udayakantha >> WSO2 Inc. www.wso2.com >> lean.enterprise.middleware >> Mobile: *0711241005* >> >> > > > -- > Lakshman Udayakantha > WSO2 Inc. www.wso2.com > lean.enterprise.middleware > Mobile: *0711241005* > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Regards, Dunith Dhanushka, Senior Software Engineer - BAM, WSO2 Inc, Mobile - +94 71 8615744 Blog - dunithd.wordpress.com <http://blog.dunith.com> Twitter - @dunithd <http://twitter.com/dunithd>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
