phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mujtaba Chohan <mujt...@apache.org>
Subject Re: problem about using tracing
Date Wed, 03 Sep 2014 20:05:22 GMT
Phoenix connection URL should be of this form
jdbc:phoenix:zookeeper2,zookeeper1,zookeeper3:2181



On Wed, Sep 3, 2014 at 12:11 PM, Jesse Yates <jesse.k.yates@gmail.com>
wrote:

> 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