phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <els...@apache.org>
Subject Re: Phoenix CsvBulkLoadTool fails with java.sql.SQLException: ERROR 103 (08004): Unable to establish connection
Date Mon, 20 Aug 2018 20:24:21 GMT
(-cc user@hbase, +bcc user@hbase)

How about the rest of the stacktrace? You didn't share the cause.

On 8/20/18 1:35 PM, Mich Talebzadeh wrote:
> 
> This was working fine before my Hbase upgrade to 1.2.6
> 
> I have Hbase version 1.2.6 and Phoenix 
> version apache-phoenix-4.8.1-HBase-1.2-bin
> 
> This command bulkloading into Hbase through phoenix failsnow fails
> 
> HADOOP_CLASSPATH=${HOME}/jars/hbase-protocol-1.2.6.jar:${HBASE_HOME}/conf hadoop 
> jar ${HBASE_HOME}/lib/phoenix-4.8.1-HBase-1.2-client.jar 
> org.apache.phoenix.mapreduce.CsvBulkLoadTool --table ${TABLE_NAME} 
> --input hdfs://rhes75:9000/${REFINED_HBASE_SUB_DIR}/${FILE_NAME}_${dir}.txt
> 
> hadoop jar 
> /data6/hduser/hbase-1.2.6/lib/phoenix-4.8.1-HBase-1.2-client.jar 
> org.apache.phoenix.mapreduce.CsvBulkLoadTool --table 
> MARKETDATAHBASEBATCH --input 
> hdfs://rhes75:9000//data/prices/2018-08-20_refined/populate_Phoenix_table_MARKETDATAHBASEBATCH_2018-08-20.txt
> + 
> HADOOP_CLASSPATH=/home/hduser/jars/hbase-protocol-1.2.6.jar:/data6/hduser/hbase-1.2.6/conf
> 
> 
> With the following error
> 
> 2018-08-20 18:29:47,248 INFO  [main] zookeeper.ZooKeeper: Client 
> environment:java.library.path=/home/hduser/hadoop-3.1.0/lib
> 2018-08-20 18:29:47,248 INFO  [main] zookeeper.ZooKeeper: Client 
> environment:java.io.tmpdir=/tmp
> 2018-08-20 18:29:47,248 INFO  [main] zookeeper.ZooKeeper: Client 
> environment:java.compiler=<NA>
> 2018-08-20 18:29:47,248 INFO  [main] zookeeper.ZooKeeper: Client 
> environment:os.name <http://os.name>=Linux
> 2018-08-20 18:29:47,248 INFO  [main] zookeeper.ZooKeeper: Client 
> environment:os.arch=amd64
> 2018-08-20 18:29:47,248 INFO  [main] zookeeper.ZooKeeper: Client 
> environment:os.version=3.10.0-862.3.2.el7.x86_64
> 2018-08-20 18:29:47,248 INFO  [main] zookeeper.ZooKeeper: Client 
> environment:user.name <http://user.name>=hduser
> 2018-08-20 18:29:47,248 INFO  [main] zookeeper.ZooKeeper: Client 
> environment:user.home=/home/hduser
> 2018-08-20 18:29:47,248 INFO  [main] zookeeper.ZooKeeper: Client 
> environment:user.dir=/data6/hduser/streaming_data/2018-08-20
> 2018-08-20 18:29:47,249 INFO  [main] zookeeper.ZooKeeper: Initiating 
> client connection, connectString=rhes75:2181 sessionTimeout=90000 
> watcher=hconnection-0x493d44230x0, quorum=rhes75:2181, baseZNode=/hbase
> 2018-08-20 18:29:47,261 INFO  [main-SendThread(rhes75:2181)] 
> zookeeper.ClientCnxn: Opening socket connection to server 
> rhes75/50.140.197.220:2181 <http://50.140.197.220:2181>. Will not 
> attempt to authenticate using SASL (unknown error)
> 2018-08-20 18:29:47,264 INFO  [main-SendThread(rhes75:2181)] 
> zookeeper.ClientCnxn: Socket connection established to 
> rhes75/50.140.197.220:2181 <http://50.140.197.220:2181>, initiating session
> 2018-08-20 18:29:47,281 INFO  [main-SendThread(rhes75:2181)] 
> zookeeper.ClientCnxn: Session establishment complete on server 
> rhes75/50.140.197.220:2181 <http://50.140.197.220:2181>, sessionid = 
> 0x1002ea99eed0077, negotiated timeout = 40000
> Exception in thread "main" java.sql.SQLException: ERROR 103 (08004): 
> Unable to establish connection.
>          at 
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:455)
> 
> Any thoughts?
> 
> Thanks
> 
> Dr Mich Talebzadeh
> 
> LinkedIn 
> /https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw/
> 
> http://talebzadehmich.wordpress.com
> 
> 
> *Disclaimer:* Use it at your own risk.Any and all responsibility for any 
> loss, damage or destruction of data or any other property which may 
> arise from relying on this email's technical content is explicitly 
> disclaimed. The author will in no case be liable for any monetary 
> damages arising from such loss, damage or destruction.
> 

Mime
View raw message