Hi Josh, Here's the full stacktrace from PQS, I think its saying the PQS at localhost has an error.
python sqlline-thin.py bigdata-namenode:8765 Failed to extract serialization from hbase-site.xml, defaulting to PROTOBUF. Setting property: [incremental, false] Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:thin:url=http://bigdata-namenode:8765;serialization=PROTOBUF none none org.apache.phoenix.queryserver.client.Driver Connecting to jdbc:phoenix:thin:url=http://bigdata-namenode:8765;serialization=PROTOBUF SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/saque/hadoopec/phoenix/apache-phoenix-4.12.0-HBase-1.2-bin/phoenix-4.12.0-HBase-1.2-thin-client.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/saque/hadoopec/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. AvaticaClientRuntimeException: Remote driver error: RuntimeException: java.sql.SQLException: No suitable driver found for localhost -> SQLException: No suitable driver found for localhost. Error -1 (00000) null java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for localhost at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:621) at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:285) at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1771) at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1751) at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:94) at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:46) at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:127) at org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.apache.phoenix.shaded.org.eclipse.jetty.server.Server.handle(Server.java:499) at org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311) at org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) at org.apache.phoenix.shaded.org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544) at org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: No suitable driver found for localhost at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:618) ... 15 more at org.apache.calcite.avatica.remote.Service$ErrorResponse.toException(Service.java:2476) at org.apache.calcite.avatica.remote.RemoteProtobufService._apply(RemoteProtobufService.java:63) at org.apache.calcite.avatica.remote.ProtobufService.apply(ProtobufService.java:81) at org.apache.calcite.avatica.remote.Driver.connect(Driver.java:176) 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(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:809) at sqlline.SqlLine.initArgs(SqlLine.java:588) at sqlline.SqlLine.begin(SqlLine.java:661) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) at org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93) sqlline version 1.2.0 0: jdbc:phoenix:thin:url=http://bigdata-namen> !quit AvaticaClientRuntimeException: Remote driver error: RuntimeException: java.sql.SQLException: No suitable driver found for localhost -> SQLException: No suitable driver found for localhost. Error -1 (00000) null java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for localhost at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:621) at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:285) at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1771) at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1751) at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:94) at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:46) at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:127) at org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.apache.phoenix.shaded.org.eclipse.jetty.server.Server.handle(Server.java:499) at org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311) at org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) at org.apache.phoenix.shaded.org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544) at org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: No suitable driver found for localhost at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:618) ... 15 more at org.apache.calcite.avatica.remote.Service$ErrorResponse.toException(Service.java:2476) at org.apache.calcite.avatica.remote.RemoteProtobufService._apply(RemoteProtobufService.java:63) at org.apache.calcite.avatica.remote.ProtobufService.apply(ProtobufService.java:81) at org.apache.calcite.avatica.remote.Driver.connect(Driver.java:176) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) at sqlline.Commands.close(Commands.java:906) at sqlline.Commands.quit(Commands.java:870) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:809) at sqlline.SqlLine.begin(SqlLine.java:686) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) at org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93) AvaticaClientRuntimeException: Remote driver error: RuntimeException: java.sql.SQLException: No suitable driver found for localhost -> SQLException: No suitable driver found for localhost. Error -1 (00000) null java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for localhost at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:621) at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:285) at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1771) at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1751) at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:94) at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:46) at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:127) at org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.apache.phoenix.shaded.org.eclipse.jetty.server.Server.handle(Server.java:499) at org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311) at org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) at org.apache.phoenix.shaded.org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544) at org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: No suitable driver found for localhost at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:618) ... 15 more at org.apache.calcite.avatica.remote.Service$ErrorResponse.toException(Service.java:2476) at org.apache.calcite.avatica.remote.RemoteProtobufService._apply(RemoteProtobufService.java:63) at org.apache.calcite.avatica.remote.ProtobufService.apply(ProtobufService.java:81) at org.apache.calcite.avatica.remote.Driver.connect(Driver.java:176) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) at sqlline.Commands.close(Commands.java:906) at sqlline.Commands.closeall(Commands.java:880) at sqlline.SqlLine.begin(SqlLine.java:714) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) at org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93) Here the bigdata-namenode is like localhost, it's a host name with a local ip. It neither works with localhost nor with the local ip. Thank you On Thu, Dec 7, 2017 at 10:26 PM, Josh Elser <els...@apache.org> wrote: > I can't seem to track down that error message to any specific line of code. > > Do you have a stacktrace in the PQS log? I'm not sure the the message is > implying that "localhost" is being interpreted as a class name or if it's > saying the PQS at localhost had an error. The more details you can provide, > the better. > > > On 12/7/17 12:55 AM, Vaghawan Ojha wrote: > >> Hi, >> >> I'm facing a weird problem with queryserver. When I start the >> queryserver, the log says that the service is listening in the port 8765, >> everything looks fine. >> >> But when I try to use the queryserver, the error like this prompts up. >> >> n$ python sqlline-thin.py localhost:8765 >> Failed to extract serialization from hbase-site.xml, defaulting to >> PROTOBUF. >> Setting property: [incremental, false] >> Setting property: [isolation, TRANSACTION_READ_COMMITTED] >> issuing: !connect jdbc:phoenix:thin:url=http://l >> ocalhost:8765;serialization=PROTOBUF none none >> org.apache.phoenix.queryserver.client.Driver >> Connecting to jdbc:phoenix:thin:url=http://l >> ocalhost:8765;serialization=PROTOBUF >> SLF4J: Class path contains multiple SLF4J bindings. >> SLF4J: Found binding in [jar:file:/home/saque/hadoopec >> /phoenix/apache-phoenix-4.12.0-HBase-1.2-bin/phoenix-4.12. >> 0-HBase-1.2-thin-client.jar!/org/slf4j/impl/StaticLoggerBinder.class] >> SLF4J: Found binding in [jar:file:/home/saque/hadoopec >> /hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/ >> org/slf4j/impl/StaticLoggerBinder.class] >> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an >> explanation. >> AvaticaClientRuntimeException: Remote driver error: RuntimeException: >> java.sql.SQLException: No suitable driver found for localhost -> >> SQLException: No suitable driver found for localhost. Error -1 (00000) null >> >> java.lang.RuntimeException: java.sql.SQLException: No suitable driver >> found for localhost >> >> The same queryserver was running before the server was restarted. This >> happens all the time, when I restart the server. The hadoop classpath and >> hbase classpath are there. The sqlline with zookeper port works fine. >> >> When I do: python sqlline.py localhost:2181. It works. However when I do >> python sqlline-thin.py localhost:8765, it throws such errors. >> >> Any help would be great, I'm using apache-phoenix-4.12.0-HBase-1.2 . >> >> Thanks in advance >> Vaghawan >> >
