Hi Josh, I fixed it by specifying the host where the query server was running while doing python queryserver.py stop.
Something like this: python queryserver.py stop localhost:8765 And again started normally, it started working. Thanks a lot. Vaghawan On Fri, Dec 8, 2017 at 7:38 AM, Vaghawan Ojha <vaghawan...@gmail.com> wrote: > 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!/or >>> g/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 >>> >> >
