[Mondrian] retrieve currently executing sql queries

Luc Boudreau lucboudreau at gmail.com
Mon Mar 18 11:40:40 EDT 2013


I have checked in a small patch to so that the SqlStatementInfo objects
include the actual SQL getting executed.

See:
https://github.com/pentaho/mondrian/commit/dbf3ff2abe26425ecefcbcb99586d4d210f92feb

Luc


On Mon, Mar 11, 2013 at 11:02 AM, Luc Boudreau <lucboudreau at gmail.com>wrote:

> The SqlStatementInfo should include the SQL query. Please add a jira case
> for this feature.
>
> Luc
>
> On Mon, Mar 11, 2013 at 10:58 AM, Matt Campbell <mcampbell at pentaho.com>wrote:
>
>> I believe the statement ID you retrieve from the monitor is the same one
>> that gets logged.  So you should be able to check the ID of any queries
>> still executing and locate them in the logs.  ****
>>
>> ** **
>>
>> E.g. id 202 in this logged entry:****
>>
>>    DEBUG [mdx] 202: select [Gender].[Gender].Members ON COLUMNS****
>>
>> ** **
>>
>> Alternatively, just look at the logs for queries that have started but
>> not finished.  ****
>>
>> ** **
>>
>> ** **
>>
>> *From:* mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
>> *On Behalf Of *Domen Pogacnik
>> *Sent:* Monday, March 11, 2013 10:10 AM
>> *To:* mondrian at pentaho.org
>>
>> *Subject:* Re: [Mondrian] retrieve currently executing sql queries****
>>
>> ** **
>>
>> I know about sql and mdx log, but I would actually like to get the
>> current state of Mondrian i.e. which queries / mdx statements / tasks are
>> currently in execution.****
>>
>> ** **
>>
>> To better understand my problem, I often get the following error:****
>>
>> ** **
>>
>> Mondrian Error:The number of concurrent MDX statements which can be
>> processed simultaneously by this Mondrian server instance has been reached.
>> Set 'mondrian.rolap.maxQueryThreads' to change the current limit.****
>>
>> ** **
>>
>> All the consequential mdx queries after that error fails to execute (even
>> if I wait for 300s). I suspect that there are MDX queries which fail to
>> finish and I would like to see which.****
>>
>> ** **
>>
>> Best,****
>>
>> Domen****
>>
>> ** **
>>
>> Date: Fri, 8 Mar 2013 13:10:01 -0600
>> From: Matt Campbell <mcampbell at pentaho.com>
>> Subject: Re: [Mondrian] retrieve currently executing sql queries
>> To: Mondrian developer mailing list <mondrian at pentaho.org>
>> Message-ID:
>>         <
>> 60DAC7BD8D63084E8252254DF3F1102009B4206981 at MBX36.exg5.exghost.com>
>> Content-Type: text/plain; charset="us-ascii"
>>
>> A simple option is to turn on DEBUG logging in your log4j.xml.  Setting
>> both mondrian.sql and mondrian.mdx to DEBUG is often useful.
>>
>>    <category name="mondrian.sql">
>>       <priority value="DEBUG"/>
>>       <appender-ref ref="SQLLOG"/>
>>    </category>
>>
>>    <category name="mondrian.mdx">
>>       <priority value="DEBUG"/>
>>       <appender-ref ref="MDXLOG"/>
>>    </category> ****
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130318/2ca1e134/attachment.html 


More information about the Mondrian mailing list