Hi all,
I am trying to facilitate tracing according to the instructions here. Here are
my several operations:
1. copy the phoenix-hadoop2-compat/bin/ attributes files into my hbase
classpath($HBASE_HOME/conf)
2. modify hbase-site.xml and adding the following properties:
<property>
<name>phoenix.trace.frequency</name>
<value>always</value>
</property>
3. restart hbase cluster and run phoenix through sqlline client:
./bin/sqlline.py zookeeper1,zookeeper2,zookeeper3 as
zookeeper1,zookeeper2,zookeeper3 are my zookeeper hosts
4. When I am trying to see the tracing feature thourgh sqlline query as the
following:
select count (*) from mytable;
I checked the regionserver log and found the following exception. Any
available hints?
2014-09-03 15:40:53,218 ERROR [tracing] impl.MetricsSinkAdapter: Got sink
exception and over retry limit, suppressing further error messages
java.lang.RuntimeException: java.sql.SQLException: ERROR 102 (08001): Malformed
connection url. jdbc:phoenix:zookeeper2:2181,zookeeper1:2181,zookeeper3:2181;
at
org.apache.phoenix.trace.PhoenixTableMetricsWriter.lazyInitialize(PhoenixTableMetricsWriter.java:110)
at
org.apache.phoenix.trace.PhoenixTableMetricsWriter.addMetrics(PhoenixTableMetricsWriter.java:185)
at
org.apache.phoenix.trace.PhoenixMetricsSink.putMetrics(PhoenixMetricsSink.java:92)
at
org.apache.hadoop.metrics2.impl.MetricsSinkAdapter.consume(MetricsSinkAdapter.java:173)
at
org.apache.hadoop.metrics2.impl.MetricsSinkAdapter.consume(MetricsSinkAdapter.java:41)
at org.apache.hadoop.metrics2.impl.SinkQueue.consumeAll(SinkQueue.java:87)
at
org.apache.hadoop.metrics2.impl.MetricsSinkAdapter.publishMetricsFromQueue(MetricsSinkAdapter.java:127)
at
org.apache.hadoop.metrics2.impl.MetricsSinkAdapter$1.run(MetricsSinkAdapter.java:86)
Caused by: java.sql.SQLException: ERROR 102 (08001): Malformed connection url.
jdbc:phoenix:zookeeper2:2181,zookeeper1:2181,zookeeper3:2181;
at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:333)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver$ConnectionInfo.getMalFormedUrlException(PhoenixEmbeddedDriver.java:183)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver$ConnectionInfo.create(PhoenixEmbeddedDriver.java:238)
at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:144)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:129)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at org.apache.phoenix.util.QueryUtil.getConnection(QueryUtil.java:213)
at
org.apache.phoenix.trace.PhoenixTableMetricsWriter.lazyInitialize(PhoenixTableMetricsWriter.java:100)
... 7 more
CertusNet
