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, su...@certusnet.com.cn < su...@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 > > >