phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <els...@apache.org>
Subject Re: Problem With QueryServer In SQL Line Thin Client.
Date Tue, 12 Dec 2017 00:40:36 GMT
Weird, but glad you got it figured out.

PQS pulls the (thick) PhoenixDriver from the phoenix-client.jar you have 
in your Phoenix installation. Perhaps you had accidentally moved the jar 
aside and restarted PQS leaving PQS running without that jar? Hard to 
say, but that's my only guess.

On 12/8/17 7:18 AM, Vaghawan Ojha wrote:
> 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 <vaghawan781@gmail.com 
> <mailto:vaghawan781@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
>     <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
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.Server.handle(Server.java:499)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.io
>     <http://eclipse.jetty.io>.AbstractConnection$2.run(AbstractConnection.java:544)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
>     at org.apache.phoenix.shaded.org
>     <http://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
>     <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
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.Server.handle(Server.java:499)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.io
>     <http://eclipse.jetty.io>.AbstractConnection$2.run(AbstractConnection.java:544)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
>     at org.apache.phoenix.shaded.org
>     <http://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
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.Server.handle(Server.java:499)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.io
>     <http://eclipse.jetty.io>.AbstractConnection$2.run(AbstractConnection.java:544)
>     at org.apache.phoenix.shaded.org
>     <http://org.apache.phoenix.shaded.org>.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
>     at org.apache.phoenix.shaded.org
>     <http://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 <elserj@apache.org
>     <mailto:elserj@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://localhost:8765;serialization=PROTOBUF
>             none none org.apache.phoenix.queryserver.client.Driver
>             Connecting to
>             jdbc:phoenix:thin:url=http://localhost: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
>             <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
> 
> 
> 

Mime
View raw message