Hi, It was an error on my side. I didn't remove the configs specified in the release notes: https://phoenix.apache.org/release_notes.html
<property> <name>hbase.master.loadbalancer.class</name> <value>org.apache.phoenix.hbase.index.balancer.IndexLoadBalancer</value> </property> <property> <name>hbase.coprocessor.master.classes</name> <value>org.apache.phoenix.hbase.index.master.IndexMasterObserver</value> </property> <property> <name>hbase.coprocessor.regionserver.classes</name> <value>org.apache.hadoop.hbase.regionserver.LocalIndexMerger</value> </property> I was able to connect upon removing those. Thanks! On Mon, Apr 3, 2017 at 11:39 PM, Josh Elser <[email protected]> wrote: > The root cause of your exception is a ConnectionRefusedException. This > means that your client was unable to make an network connection to > 192.168.1.147:52540 (from earlier in your stacktrace). > > Typically, this is an OS or HBase level issue. I'd first try to rule out a > networking level issue using telnet from the same host your client is > running on (e.g. `telnet 192.168.1.147 52540`). If telnet cannot > successfully connect to that host&port, you have a system-level issue. > > You might also want to check the HBase services on that host for any > exceptions in their log. > > > Bernard Quizon wrote: > >> Hi, >> >> I tried to upgrade my phoenix-core-4.4.0-HBase-1.1.jar to >> phoenix-core-4.8.0-HBase-1.1.jar on my local setup, basically just >> replacing it from my hbase/lib. >> >> When I use sqlline, this error shows up: >> >> $ ./sqlline.py localhost >> Setting property: [incremental, false] >> Setting property: [isolation, TRANSACTION_READ_COMMITTED] >> issuing: !connect jdbc:phoenix:localhost none none >> org.apache.phoenix.jdbc.PhoenixDriver >> Connecting to jdbc:phoenix:localhost >> 17/04/03 10:00:52 WARN util.NativeCodeLoader: Unable to load >> native-hadoop library for your platform... using builtin-java classes >> where applicable >> Error: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed >> after attempts=36, exceptions: >> Mon Apr 03 10:01:41 PHT 2017, null, java.net.SocketTimeoutException: >> callTimeout=60000, callDuration=68281: row 'SYSTEM:CATALOG,,' on table >> 'hbase:meta' at region=hbase:meta,,1.1588230740, >> hostname=192.168.1.147,52540,1490932622981, seqNum=0 (state=,code=0) >> java.sql.SQLException: >> org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after >> attempts=36, exceptions: >> Mon Apr 03 10:01:41 PHT 2017, null, java.net.SocketTimeoutException: >> callTimeout=60000, callDuration=68281: row 'SYSTEM:CATALOG,,' on table >> 'hbase:meta' at region=hbase:meta,,1.1588230740, >> hostname=192.168.1.147,52540,1490932622981, seqNum=0 >> >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl$13. >> call(ConnectionQueryServicesImpl.java:2575) >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl$13. >> call(ConnectionQueryServicesImpl.java:2300) >> at >> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixC >> ontextExecutor.java:78) >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(Co >> nnectionQueryServicesImpl.java:2300) >> at >> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServ >> ices(PhoenixDriver.java:231) >> at >> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnecti >> on(PhoenixEmbeddedDriver.java:144) >> at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202) >> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) >> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) >> at sqlline.Commands.connect(Commands.java:1064) >> at sqlline.Commands.connect(Commands.java:996) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce >> ssorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >> thodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:606) >> at >> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa >> ndler.java:36) >> at sqlline.SqlLine.dispatch(SqlLine.java:803) >> at sqlline.SqlLine.initArgs(SqlLine.java:588) >> at sqlline.SqlLine.begin(SqlLine.java:656) >> at sqlline.SqlLine.start(SqlLine.java:398) >> at sqlline.SqlLine.main(SqlLine.java:292) >> Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: >> Failed after attempts=36, exceptions: >> Mon Apr 03 10:01:41 PHT 2017, null, java.net.SocketTimeoutException: >> callTimeout=60000, callDuration=68281: row 'SYSTEM:CATALOG,,' on table >> 'hbase:meta' at region=hbase:meta,,1.1588230740, >> hostname=192.168.1.147,52540,1490932622981, seqNum=0 >> >> at >> org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadRepl >> icas.throwEnrichedException(RpcRetryingCallerWithReadReplicas.java:271) >> at >> org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.c >> all(ScannerCallableWithReplicas.java:199) >> at >> org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.c >> all(ScannerCallableWithReplicas.java:59) >> at >> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithout >> Retries(RpcRetryingCaller.java:200) >> at org.apache.hadoop.hbase.client.ClientScanner.call(ClientScan >> ner.java:320) >> at >> org.apache.hadoop.hbase.client.ClientScanner.nextScanner( >> ClientScanner.java:295) >> at >> org.apache.hadoop.hbase.client.ClientScanner.initializeScann >> erInConstruction(ClientScanner.java:160) >> at >> org.apache.hadoop.hbase.client.ClientScanner.<init>(ClientSc >> anner.java:155) >> at org.apache.hadoop.hbase.client.HTable.getScanner(HTable.java:821) >> at >> org.apache.hadoop.hbase.MetaTableAccessor.fullScan(MetaTable >> Accessor.java:602) >> at >> org.apache.hadoop.hbase.MetaTableAccessor.tableExists(MetaTa >> bleAccessor.java:366) >> at >> org.apache.hadoop.hbase.client.HBaseAdmin.tableExists(HBaseA >> dmin.java:392) >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl$13. >> call(ConnectionQueryServicesImpl.java:2333) >> ... 20 more >> Caused by: java.net.SocketTimeoutException: callTimeout=60000, >> callDuration=68281: row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at >> region=hbase:meta,,1.1588230740, >> hostname=192.168.1.147,52540,1490932622981, seqNum=0 >> at >> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRet >> ries(RpcRetryingCaller.java:159) >> at >> org.apache.hadoop.hbase.client.ResultBoundedCompletionServic >> e$QueueingFuture.run(ResultBoundedCompletionService.java:64) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool >> Executor.java:1145) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo >> lExecutor.java:615) >> at java.lang.Thread.run(Thread.java:745) >> Caused by: java.net.ConnectException: Connection refused >> at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) >> at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:744) >> at >> org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWi >> thTimeout.java:206) >> at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:531) >> at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:495) >> at >> org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupCo >> nnection(RpcClientImpl.java:411) >> at >> org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupIO >> streams(RpcClientImpl.java:717) >> at >> org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.writeRe >> quest(RpcClientImpl.java:897) >> at >> org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.tracedW >> riteRequest(RpcClientImpl.java:866) >> at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl >> .java:1209) >> at >> org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMe >> thod(AbstractRpcClient.java:217) >> at >> org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcCha >> nnelImplementation.callBlockingMethod(AbstractRpcClient.java:318) >> at >> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ >> ClientService$BlockingStub.scan(ClientProtos.java:32831) >> at >> org.apache.hadoop.hbase.client.ScannerCallable.openScanner( >> ScannerCallable.java:373) >> at >> org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerC >> allable.java:200) >> at >> org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerC >> allable.java:62) >> at >> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithout >> Retries(RpcRetryingCaller.java:200) >> at >> org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$R >> etryingRPC.call(ScannerCallableWithReplicas.java:350) >> at >> org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$R >> etryingRPC.call(ScannerCallableWithReplicas.java:324) >> at >> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRet >> ries(RpcRetryingCaller.java:126) >> ... 4 more >> sqlline version 1.1.9 >> >> Is there something else I should fix? Configs? >> Btw, I haven't encountered this problem using >> phoenix-core-4.7.0-HBase-1.1.jar. >> >> >> Thanks! >> >
