phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jaanai Zhang <cloud.pos...@gmail.com>
Subject Re: Query logging - PHOENIX-2715
Date Tue, 23 Apr 2019 09:49:56 GMT
Log level has four levels: OFF, INFO, DEBUG, and TRACE, the default value
of log level is OFF.  we can config by setting "phoenix.log.level" to log
each query on the client side.

----------------------------------------
   Jaanai Zhang
   Best regards!



M. Aaron Bossert <mabossert@gmail.com> 于2019年4月20日周六 上午8:12写道:

> Sorry if I have missed something obvious, but I saw that this was
> implemented (according to JIRA) in 4.14 and 5.0.0.  I need to set this up
> to log each query in that SYSTEM:LOG table, but cannot seem to find the
> official instructions for how to configure this through LOG4J settings or
> whatever it is now.  Could someone please point me in the right direction?
>
> On Tue, Nov 20, 2018 at 9:31 PM Jaanai Zhang <cloud.poster@gmail.com>
> wrote:
>
>> yep!  That configuration options do not exist.
>>
>> ----------------------------------------
>>    Jaanai Zhang
>>    Best regards!
>>
>>
>>
>> Curtis Howard <curtis.james.howard@gmail.com> 于2018年11月20日周二 下午11:42写道:
>>
>>> Hi Jaanai,
>>>
>>> Thanks for your suggestion.  Just confirming then - it sounds like this
>>> would involve adding custom code, as there are no current configuration
>>> options to enable logging/capture of all query statements (including
>>> DDL/DML) from clients?
>>>
>>> Thanks for your help
>>> Curtis
>>>
>>> On Tue, Nov 20, 2018 at 8:33 AM Jaanai Zhang <cloud.poster@gmail.com>
>>> wrote:
>>>
>>>> We can't capture some detail information about the DDL/DML operations
>>>> by TRACE log. I suggest that you can print logs of these operations on the
>>>> logic layer.
>>>>
>>>> ----------------------------------------
>>>>    Jaanai Zhang
>>>>    Best regards!
>>>>
>>>>
>>>>
>>>> Curtis Howard <curtis.james.howard@gmail.com> 于2018年11月20日周二
上午11:20写道:
>>>>
>>>>> Hi,
>>>>>
>>>>> Is the expected behavior for this new feature to capture all
>>>>> operations (UPSERT / DROP / CREATE / ...)?  After enabling
>>>>> phoenix.log.level=TRACE, I see only SELECT queries populated in the
>>>>> SYSTEM.LOG table.
>>>>>
>>>>> Thanks!
>>>>> Curtis
>>>>>
>>>>>

Mime
View raw message