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 <vaghawan...@gmail.com
<mailto: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
<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 <els...@apache.org
<mailto: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://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
