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 23:33:29 GMT
Filed https://issues.apache.org/jira/browse/PHOENIX-1234 and attached what
I think is the fix.

With this patch you still need to ensure that "hbase.zookeeper.quorum" gets
set to just the hostnames, not the host:port combination, as per the HBase
ref guide.

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


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

> Actually, in hbase-site.xml, you would have
>
>   <property>
>       <name>hbase.zookeeper.property.clientPort</name>
>       <value>2222</value>
>     </property>
>     <property>
>       <name>hbase.zookeeper.quorum</name>
>       <value>rs1.example.com,rs2.example.com,rs3.example.com,rs4.example.com,rs5.example.com</value>
>     </property>
>
> from the ref guide, zookeeper
> <http://hbase.apache.org/book.html#zookeeper> section
>
> which then gets resolved to something like: "rs1.example.com:2222,
> rs2.example.com:2222,rs3.example.com:2222,rs4.example.com:2222,
> rs5.example.com:2222" from ZKConfig. Then when phoenix tries to parse it
> in QueryUtil, it gets:
>
>> server=rs1.example.com:2222,rs2.example.com:2222,rs3.example.com:2222,
>> rs4.example.com:2222,rs5.example.com:2222
>
>  port=2222
>
>
> Which will not create a correct connection.
>
>
> -------------------
> Jesse Yates
> @jesse_yates
> jyates.github.com
>
>
> On Wed, Sep 3, 2014 at 1:22 PM, Jeffrey Zhong <jzhong@hortonworks.com>
> wrote:
>
>>
>> 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
>>>
>>>
>>> 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
>>>>
>>>>
>>>>
>>>
>>
>> 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