You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by Ayola Jayamaha <ra...@gmail.com> on 2015/05/25 12:25:33 UTC

Issue in Phoenix Tracing

Hi All,

I am using phoenix-4.3.1. I have setup "hbase-0.98.12.1-hadoop2" and
zookeeper
According to this article [1]. My setup is in the given blogposts[2]. When
I'm starting Phoenix I'm getting the below warning

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
details.
15/05/25 15:38:16 WARN util.NativeCodeLoader: Unable to load native-hadoop
library for your platform... using builtin-java classes where applicable
15/05/25 15:38:16 WARN impl.MetricsConfig: Cannot locate configuration:
tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
Connected to: Phoenix (version 4.3)

The tracing table was not to be found.

[1] http://phoenix.apache.org/tracing.html
[2]
http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
-- 
Best Regards,
Nishani Jayamaha
http://ayolajayamaha.blogspot.com/

Re: Issue in Phoenix Tracing

Posted by Ayola Jayamaha <ra...@gmail.com>.
Hi,

Thanks Jesse and Nick. The problem was sqlline class path. Now the tracing
table is shown. And the blog post is
http://ayolajayamaha.blogspot.com/2015/05/enabling-tracing-for-apache-phoenix.html
.

On Wed, May 27, 2015 at 9:16 PM, Nick Dimiduk <nd...@gmail.com> wrote:

> Performing the steps in your blog will populate a and query data, but I
> didn't see any place where you enabled tracing for a request. Enabling
> collection of trace spans via [2] is required. With that done, you also
> need to execute queries with tracing initiated. To experiment, try
> setting phoenix.trace.frequency=always in hbase-site.xml that's on the
> sqlline class path and see if the tracing table shows up.
>
> On Wed, May 27, 2015 at 7:53 AM, Ayola Jayamaha <ra...@gmail.com>
> wrote:
>
>> Hi,
>>
>> I created a table and entered data into it. I viewed the data through
>> phoenix. But tracing table was not there. Creating a table would be a
>> request that would create the tracing table.
>> The steps I followed are in my blog[1]. Afterwards I configured phoenix
>> and
>> hbase according to the post [2].
>>
>>
>> [1]
>> http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
>> [2] http://phoenix.apache.org/tracing.html
>>
>> On Tue, May 26, 2015 at 10:38 PM, Jesse Yates <je...@gmail.com>
>> wrote:
>>
>> > IIRC, it should be created by the first request that has traces. So when
>> > you just start the cluster/client you won't see anything. Make a request
>> > with tracing enabled and it should automatically create the tracing
>> table
>> > and insert the information about the trace.
>> >
>> > Try stepping through the code with a debugger - it should make it much
>> > clearer what is happening in what order.
>> >
>> > On Tue, May 26, 2015, 9:07 AM Ayola Jayamaha <ra...@gmail.com>
>> > wrote:
>> >
>> >> Hi,
>> >>
>> >> I copied the hadoop-metrics2-phoenix.properties and
>> hadoop-metrics2.properties
>> >> to 'phoenix-4.3.1-bin'. Now I'm not getting any warnings for the
>> property
>> >> files. But is it the correct way since still the tracing table is
>> missing.
>> >> Do we need to create is manually or is it created automatically when
>> >> configured correctly.
>> >> Thanks.
>> >>
>> >> On Mon, May 25, 2015 at 10:55 PM, Jesse Yates <jesse.k.yates@gmail.com
>> >
>> >> wrote:
>> >>
>> >>> You are missing either the
>> >>> hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties on the
>> >>> classpath. The setup of these files should be discussed on the
>> tracing page
>> >>> of the website.
>> >>>
>> >>> On Mon, May 25, 2015, 12:26 AM Ayola Jayamaha <raphaelanne2@gmail.com
>> >
>> >>> wrote:
>> >>>
>> >>>> Hi All,
>> >>>>
>> >>>> I am using phoenix-4.3.1. I have setup "hbase-0.98.12.1-hadoop2" and
>> >>>> zookeeper
>> >>>> According to this article [1]. My setup is in the given blogposts[2].
>> >>>> When
>> >>>> I'm starting Phoenix I'm getting the below warning
>> >>>>
>> >>>> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
>> >>>> SLF4J: Defaulting to no-operation (NOP) logger implementation
>> >>>> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for
>> >>>> further
>> >>>> details.
>> >>>> 15/05/25 15:38:16 WARN util.NativeCodeLoader: Unable to load
>> >>>> native-hadoop
>> >>>> library for your platform... using builtin-java classes where
>> applicable
>> >>>> 15/05/25 15:38:16 WARN impl.MetricsConfig: Cannot locate
>> configuration:
>> >>>> tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
>> >>>> Connected to: Phoenix (version 4.3)
>> >>>>
>> >>>> The tracing table was not to be found.
>> >>>>
>> >>>> [1] http://phoenix.apache.org/tracing.html
>> >>>> [2]
>> >>>>
>> >>>>
>> http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
>> >>>> --
>> >>>> Best Regards,
>> >>>> Nishani Jayamaha
>> >>>> http://ayolajayamaha.blogspot.com/
>> >>>>
>> >>>
>> >>
>> >>
>> >> --
>> >> Best Regards,
>> >> Ayola Jayamaha
>> >> http://ayolajayamaha.blogspot.com/
>> >>
>> >>
>> >>
>>
>>
>> --
>> Best Regards,
>> Ayola Jayamaha
>> http://ayolajayamaha.blogspot.com/
>>
>
>


-- 
Best Regards,
Ayola Jayamaha
http://ayolajayamaha.blogspot.com/

Re: Issue in Phoenix Tracing

Posted by Nick Dimiduk <nd...@gmail.com>.
Performing the steps in your blog will populate a and query data, but I
didn't see any place where you enabled tracing for a request. Enabling
collection of trace spans via [2] is required. With that done, you also
need to execute queries with tracing initiated. To experiment, try
setting phoenix.trace.frequency=always in hbase-site.xml that's on the
sqlline class path and see if the tracing table shows up.

On Wed, May 27, 2015 at 7:53 AM, Ayola Jayamaha <ra...@gmail.com>
wrote:

> Hi,
>
> I created a table and entered data into it. I viewed the data through
> phoenix. But tracing table was not there. Creating a table would be a
> request that would create the tracing table.
> The steps I followed are in my blog[1]. Afterwards I configured phoenix and
> hbase according to the post [2].
>
>
> [1]
> http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
> [2] http://phoenix.apache.org/tracing.html
>
> On Tue, May 26, 2015 at 10:38 PM, Jesse Yates <je...@gmail.com>
> wrote:
>
> > IIRC, it should be created by the first request that has traces. So when
> > you just start the cluster/client you won't see anything. Make a request
> > with tracing enabled and it should automatically create the tracing table
> > and insert the information about the trace.
> >
> > Try stepping through the code with a debugger - it should make it much
> > clearer what is happening in what order.
> >
> > On Tue, May 26, 2015, 9:07 AM Ayola Jayamaha <ra...@gmail.com>
> > wrote:
> >
> >> Hi,
> >>
> >> I copied the hadoop-metrics2-phoenix.properties and
> hadoop-metrics2.properties
> >> to 'phoenix-4.3.1-bin'. Now I'm not getting any warnings for the
> property
> >> files. But is it the correct way since still the tracing table is
> missing.
> >> Do we need to create is manually or is it created automatically when
> >> configured correctly.
> >> Thanks.
> >>
> >> On Mon, May 25, 2015 at 10:55 PM, Jesse Yates <je...@gmail.com>
> >> wrote:
> >>
> >>> You are missing either the
> >>> hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties on the
> >>> classpath. The setup of these files should be discussed on the tracing
> page
> >>> of the website.
> >>>
> >>> On Mon, May 25, 2015, 12:26 AM Ayola Jayamaha <ra...@gmail.com>
> >>> wrote:
> >>>
> >>>> Hi All,
> >>>>
> >>>> I am using phoenix-4.3.1. I have setup "hbase-0.98.12.1-hadoop2" and
> >>>> zookeeper
> >>>> According to this article [1]. My setup is in the given blogposts[2].
> >>>> When
> >>>> I'm starting Phoenix I'm getting the below warning
> >>>>
> >>>> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
> >>>> SLF4J: Defaulting to no-operation (NOP) logger implementation
> >>>> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for
> >>>> further
> >>>> details.
> >>>> 15/05/25 15:38:16 WARN util.NativeCodeLoader: Unable to load
> >>>> native-hadoop
> >>>> library for your platform... using builtin-java classes where
> applicable
> >>>> 15/05/25 15:38:16 WARN impl.MetricsConfig: Cannot locate
> configuration:
> >>>> tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
> >>>> Connected to: Phoenix (version 4.3)
> >>>>
> >>>> The tracing table was not to be found.
> >>>>
> >>>> [1] http://phoenix.apache.org/tracing.html
> >>>> [2]
> >>>>
> >>>>
> http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
> >>>> --
> >>>> Best Regards,
> >>>> Nishani Jayamaha
> >>>> http://ayolajayamaha.blogspot.com/
> >>>>
> >>>
> >>
> >>
> >> --
> >> Best Regards,
> >> Ayola Jayamaha
> >> http://ayolajayamaha.blogspot.com/
> >>
> >>
> >>
>
>
> --
> Best Regards,
> Ayola Jayamaha
> http://ayolajayamaha.blogspot.com/
>

Re: Issue in Phoenix Tracing

Posted by Ayola Jayamaha <ra...@gmail.com>.
Hi,

I created a table and entered data into it. I viewed the data through
phoenix. But tracing table was not there. Creating a table would be a
request that would create the tracing table.
The steps I followed are in my blog[1]. Afterwards I configured phoenix and
hbase according to the post [2].


[1]
http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
[2] http://phoenix.apache.org/tracing.html

On Tue, May 26, 2015 at 10:38 PM, Jesse Yates <je...@gmail.com>
wrote:

> IIRC, it should be created by the first request that has traces. So when
> you just start the cluster/client you won't see anything. Make a request
> with tracing enabled and it should automatically create the tracing table
> and insert the information about the trace.
>
> Try stepping through the code with a debugger - it should make it much
> clearer what is happening in what order.
>
> On Tue, May 26, 2015, 9:07 AM Ayola Jayamaha <ra...@gmail.com>
> wrote:
>
>> Hi,
>>
>> I copied the hadoop-metrics2-phoenix.properties and hadoop-metrics2.properties
>> to 'phoenix-4.3.1-bin'. Now I'm not getting any warnings for the property
>> files. But is it the correct way since still the tracing table is missing.
>> Do we need to create is manually or is it created automatically when
>> configured correctly.
>> Thanks.
>>
>> On Mon, May 25, 2015 at 10:55 PM, Jesse Yates <je...@gmail.com>
>> wrote:
>>
>>> You are missing either the
>>> hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties on the
>>> classpath. The setup of these files should be discussed on the tracing page
>>> of the website.
>>>
>>> On Mon, May 25, 2015, 12:26 AM Ayola Jayamaha <ra...@gmail.com>
>>> wrote:
>>>
>>>> Hi All,
>>>>
>>>> I am using phoenix-4.3.1. I have setup "hbase-0.98.12.1-hadoop2" and
>>>> zookeeper
>>>> According to this article [1]. My setup is in the given blogposts[2].
>>>> When
>>>> I'm starting Phoenix I'm getting the below warning
>>>>
>>>> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
>>>> SLF4J: Defaulting to no-operation (NOP) logger implementation
>>>> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for
>>>> further
>>>> details.
>>>> 15/05/25 15:38:16 WARN util.NativeCodeLoader: Unable to load
>>>> native-hadoop
>>>> library for your platform... using builtin-java classes where applicable
>>>> 15/05/25 15:38:16 WARN impl.MetricsConfig: Cannot locate configuration:
>>>> tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
>>>> Connected to: Phoenix (version 4.3)
>>>>
>>>> The tracing table was not to be found.
>>>>
>>>> [1] http://phoenix.apache.org/tracing.html
>>>> [2]
>>>>
>>>> http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
>>>> --
>>>> Best Regards,
>>>> Nishani Jayamaha
>>>> http://ayolajayamaha.blogspot.com/
>>>>
>>>
>>
>>
>> --
>> Best Regards,
>> Ayola Jayamaha
>> http://ayolajayamaha.blogspot.com/
>>
>>
>>


-- 
Best Regards,
Ayola Jayamaha
http://ayolajayamaha.blogspot.com/

Re: Issue in Phoenix Tracing

Posted by Jesse Yates <je...@gmail.com>.
IIRC, it should be created by the first request that has traces. So when
you just start the cluster/client you won't see anything. Make a request
with tracing enabled and it should automatically create the tracing table
and insert the information about the trace.

Try stepping through the code with a debugger - it should make it much
clearer what is happening in what order.

On Tue, May 26, 2015, 9:07 AM Ayola Jayamaha <ra...@gmail.com> wrote:

> Hi,
>
> I copied the hadoop-metrics2-phoenix.properties and hadoop-metrics2.properties
> to 'phoenix-4.3.1-bin'. Now I'm not getting any warnings for the property
> files. But is it the correct way since still the tracing table is missing.
> Do we need to create is manually or is it created automatically when
> configured correctly.
> Thanks.
>
> On Mon, May 25, 2015 at 10:55 PM, Jesse Yates <je...@gmail.com>
> wrote:
>
>> You are missing either the
>> hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties on the
>> classpath. The setup of these files should be discussed on the tracing page
>> of the website.
>>
>> On Mon, May 25, 2015, 12:26 AM Ayola Jayamaha <ra...@gmail.com>
>> wrote:
>>
>>> Hi All,
>>>
>>> I am using phoenix-4.3.1. I have setup "hbase-0.98.12.1-hadoop2" and
>>> zookeeper
>>> According to this article [1]. My setup is in the given blogposts[2].
>>> When
>>> I'm starting Phoenix I'm getting the below warning
>>>
>>> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
>>> SLF4J: Defaulting to no-operation (NOP) logger implementation
>>> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for
>>> further
>>> details.
>>> 15/05/25 15:38:16 WARN util.NativeCodeLoader: Unable to load
>>> native-hadoop
>>> library for your platform... using builtin-java classes where applicable
>>> 15/05/25 15:38:16 WARN impl.MetricsConfig: Cannot locate configuration:
>>> tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
>>> Connected to: Phoenix (version 4.3)
>>>
>>> The tracing table was not to be found.
>>>
>>> [1] http://phoenix.apache.org/tracing.html
>>> [2]
>>> http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
>>> --
>>> Best Regards,
>>> Nishani Jayamaha
>>> http://ayolajayamaha.blogspot.com/
>>>
>>
>
>
> --
> Best Regards,
> Ayola Jayamaha
> http://ayolajayamaha.blogspot.com/
>
>
>

Re: Issue in Phoenix Tracing

Posted by Ayola Jayamaha <ra...@gmail.com>.
Hi,

I copied the hadoop-metrics2-phoenix.properties and hadoop-metrics2.properties
to 'phoenix-4.3.1-bin'. Now I'm not getting any warnings for the property
files. But is it the correct way since still the tracing table is missing.
Do we need to create is manually or is it created automatically when
configured correctly.
Thanks.

On Mon, May 25, 2015 at 10:55 PM, Jesse Yates <je...@gmail.com>
wrote:

> You are missing either the
> hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties on the
> classpath. The setup of these files should be discussed on the tracing page
> of the website.
>
> On Mon, May 25, 2015, 12:26 AM Ayola Jayamaha <ra...@gmail.com>
> wrote:
>
>> Hi All,
>>
>> I am using phoenix-4.3.1. I have setup "hbase-0.98.12.1-hadoop2" and
>> zookeeper
>> According to this article [1]. My setup is in the given blogposts[2]. When
>> I'm starting Phoenix I'm getting the below warning
>>
>> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
>> SLF4J: Defaulting to no-operation (NOP) logger implementation
>> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
>> details.
>> 15/05/25 15:38:16 WARN util.NativeCodeLoader: Unable to load native-hadoop
>> library for your platform... using builtin-java classes where applicable
>> 15/05/25 15:38:16 WARN impl.MetricsConfig: Cannot locate configuration:
>> tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
>> Connected to: Phoenix (version 4.3)
>>
>> The tracing table was not to be found.
>>
>> [1] http://phoenix.apache.org/tracing.html
>> [2]
>> http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
>> --
>> Best Regards,
>> Nishani Jayamaha
>> http://ayolajayamaha.blogspot.com/
>>
>


-- 
Best Regards,
Ayola Jayamaha
http://ayolajayamaha.blogspot.com/

Re: Issue in Phoenix Tracing

Posted by Jesse Yates <je...@gmail.com>.
You are missing either the
hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties on the
classpath. The setup of these files should be discussed on the tracing page
of the website.

On Mon, May 25, 2015, 12:26 AM Ayola Jayamaha <ra...@gmail.com>
wrote:

> Hi All,
>
> I am using phoenix-4.3.1. I have setup "hbase-0.98.12.1-hadoop2" and
> zookeeper
> According to this article [1]. My setup is in the given blogposts[2]. When
> I'm starting Phoenix I'm getting the below warning
>
> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
> SLF4J: Defaulting to no-operation (NOP) logger implementation
> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
> details.
> 15/05/25 15:38:16 WARN util.NativeCodeLoader: Unable to load native-hadoop
> library for your platform... using builtin-java classes where applicable
> 15/05/25 15:38:16 WARN impl.MetricsConfig: Cannot locate configuration:
> tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
> Connected to: Phoenix (version 4.3)
>
> The tracing table was not to be found.
>
> [1] http://phoenix.apache.org/tracing.html
> [2]
> http://ayolajayamaha.blogspot.com/2015/05/apache-phoenix-quick-start.html
> --
> Best Regards,
> Nishani Jayamaha
> http://ayolajayamaha.blogspot.com/
>