phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>
Subject problem about using tracing
Date Wed, 03 Sep 2014 07:59:28 GMT
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 

Mime
View raw message