phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jesse Yates <jesse.k.ya...@gmail.com>
Subject Re: problem about using tracing
Date Wed, 03 Sep 2014 19:11:03 GMT
It looks like the connection string that the tracing module is using isn't
configured correctly. Is 2181 the client port on which you are running
zookeeper?

@James Taylor - phoenix can connect to multiple ZK nodes this way, right?

-------------------
Jesse Yates
@jesse_yates
jyates.github.com


On Wed, Sep 3, 2014 at 12:59 AM, sunfl@certusnet.com.cn <
sunfl@certusnet.com.cn> wrote:

> Hi all,
> I am trying to facilitate tracing according to the instructions here
> <http://phoenix.apache.org/tracing.html>. 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
>
>
>

Mime
View raw message