phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeffrey Zhong <jzh...@hortonworks.com>
Subject Re: problem about using tracing
Date Wed, 03 Sep 2014 20:22:22 GMT

I think the “hbase.zookeeper.quorum” in the hbase-site.xml with value like
"zookeeper2:2181,zookeeper1:2181,zookeeper3:2181” while Phoenix doesn’t
support this format. We had this discussion on the topic at
https://issues.apache.org/jira/browse/PHOENIX-883.

To resolve the following issue, user can just change the
hbase.zookeeper.quorum to zookeeper2,zookeeper1,zookeeper3

From:  Mujtaba Chohan <mujtaba@apache.org>
Reply-To:  <user@phoenix.apache.org>
Date:  Wednesday, September 3, 2014 at 1:05 PM
To:  <user@phoenix.apache.org>
Subject:  Re: problem about using tracing

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 <http://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(PhoenixTabl
>> eMetricsWriter.java:110)
>> at 
>> org.apache.phoenix.trace.PhoenixTableMetricsWriter.addMetrics(PhoenixTableMet
>> ricsWriter.java:185)
>> at 
>> org.apache.phoenix.trace.PhoenixMetricsSink.putMetrics(PhoenixMetricsSink.jav
>> a: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(Me
>> tricsSinkAdapter.java:127)
>> at 
>> org.apache.hadoop.metrics2.impl.MetricsSinkAdapter$1.run(MetricsSinkAdapter.j
>> ava: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(SQLExcep
>> tionCode.java:333)
>> at 
>> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo
>> .java:133) 
>> at 
>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver$ConnectionInfo.getMalFormedUrlE
>> xception(PhoenixEmbeddedDriver.java:183)
>> at 
>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver$ConnectionInfo.create(PhoenixEm
>> beddedDriver.java:238)
>> at 
>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDrive
>> r.java:144) 
>> at 
>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.j
>> ava: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(PhoenixTabl
>> eMetricsWriter.java:100)
>> ... 7 more
>> 
>> 
>> 
>> CertusNet 
>> 
>> 
> 




-- 
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to 
which it is addressed and may contain information that is confidential, 
privileged and exempt from disclosure under applicable law. If the reader 
of this message is not the intended recipient, you are hereby notified that 
any printing, copying, dissemination, distribution, disclosure or 
forwarding of this communication is strictly prohibited. If you have 
received this communication in error, please contact the sender immediately 
and delete it from your system. Thank You.

Mime
View raw message