<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Did not change that and confirmed that it was 10 (I was hoping to find a 1 hardcoded somewhere :-) )</div><div><br></div><div>The thread is waiting on task.get (line 131 on RolapResultShepherd).</div><div><br></div><div>Added a screenshot with call stack to MONDRIAN-1161</div><div><br></div><div><br></div><div>thanks,</div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Pedro Vale <a href="mailto:pedro.alves@webdetails.pt">pedro.vale@webdetails.pt</a><br>WebDetails Consulting <a href="http://www.webdetails.pt/">http://www.webdetails.pt</a></div><div><br></div></div></span><br class="Apple-interchange-newline"></span><br class="Apple-interchange-newline">
</div>
<br><div><div>A 2012/06/08, ās 16:18, Luc Boudreau escreveu:</div><br class="Apple-interchange-newline"><blockquote type="cite">Can you confirm that the user thread is waiting on the RolapResultShepherd executor? Did you override the value of "mondrian.rolap.maxQueryThreads"? It defaults to 10 (meaning that 10 user queries can be processed simultaneously per mondrian instance). <br>
<br><div class="gmail_quote">On Fri, Jun 8, 2012 at 11:15 AM, Pedro Vale <span dir="ltr"><<a href="mailto:pedro.vale@webdetails.pt" target="_blank">pedro.vale@webdetails.pt</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">Hi, Luc.<div><br></div><div>Here's the detail for the test case we have so far (tested against Mondrian trunk):</div><div><br></div><div>Open Analysis View - Create connection over steel-wheels and issue a top count query. We have a breakpoint set in RolapNativeTopCount so execution stops there.</div>
<div><br></div><div>Open another analysis View - Create connection over SampleData (another cube which should rule out cache sharing, I guess) . </div><div>Mondrian is called to get that first screen, execution goes into RolapConnection.execute, shepherdExecution method is called but the executeInternal (line 628) is not called - only after execution is resumed on the previous breakpoint.</div>
<div><br></div><div><br></div><div>hmmm.... actually, let me rephrase that last sentence. Apparently, if I wait long enough (about 4 minutes), the second thread will go into executeInternal due to a new request coming in from JPivot... weird...</div>
<div><br></div><div>As Pedro said in another email, this does not happen in Mondrian 3.3.</div><div><br></div><div>I'll file a JIRA with this info so you guys can analyze this. Let me know if you need more info.</div>
<div><br><div>cheers,</div><div><br><div>
<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><div style="word-wrap:break-word">
<div>Pedro Vale <a href="mailto:pedro.alves@webdetails.pt" target="_blank">pedro.vale@webdetails.pt</a><br>WebDetails Consulting <a href="http://www.webdetails.pt/" target="_blank">http://www.webdetails.pt</a></div>
<div><br></div></div></span><br></span><br>
</div>
<br><div><div>A 2012/06/08, ās 15:13, Luc Boudreau escreveu:</div><div><div class="h5"><br><blockquote type="cite">My guess is that dashboard B waits on some cells that are fetched by dashboard A before rendering. As of Mondrian 3.4, we do a more efficient cell sharing scheme; the cells are only loaded once, whereas before, two concurrent queries could end up executing the same request if both were issued before the cells were written to cache.<br>
<br>Luc<br><br><div class="gmail_quote">On Fri, Jun 8, 2012 at 9:31 AM, Pedro Alves <span dir="ltr"><<a href="mailto:pmgalves@gmail.com" target="_blank">pmgalves@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
I don't think that's the case (as we actually increased that number a<br>
lot) but no harm done trying<br>
<br>
<br>
However - We just tested adding a breakpoint to a topcount def fun,<br>
stopping there and then opening another analysis view - It was stuck<br>
there until we pressed continue !!<br>
<br>
<br>
I'll test this in 3.3.0 or whatever was on pentaho 4.0<br>
<span><font color="#888888"><br>
<br>
<br>
-pedro<br>
</font></span><div><div><br>
<br>
<br>
On 06/08/2012 02:27 PM, Brian Hagan wrote:<br>
> Pedro,<br>
><br>
> It does ring a bell. See <a href="http://jira.pentaho.com/browse/MONDRIAN-1080" target="_blank">http://jira.pentaho.com/browse/MONDRIAN-1080</a>. Maybe you can try 3.4.3.<br>
><br>
> - Brian<br>
> On Jun 8, 2012, at 9:02 AM, Pedro Alves wrote:<br>
><br>
>><br>
>><br>
>> Hey there.<br>
>><br>
>><br>
>> I really don't know how to ask this. I'm not even sure there's an issue,<br>
>> just a set of coincidences.<br>
>><br>
>><br>
>> As most of you know, we develop a lot of dashboards that rely on mdx.<br>
>> Lately, we've been having a few complains that the dashboards are<br>
>> incredibly slow.<br>
>><br>
>><br>
>> And we can't find, in the mondrian / sql logs reasons for that to be slow.<br>
>><br>
>><br>
>> Until we noticed somethng weird:<br>
>><br>
>> 1. User A accesses a dashboard that is not on cache<br>
>> 2. User B accesses a dashboard that should be on cache<br>
>> 3. We see on the logs the queries for user A<br>
>> 4. User B is stuck, no activity<br>
>> 5. User A's queries end, dashboard rendered<br>
>> 6. User B's dashboard is immediately rendered<br>
>><br>
>><br>
>> I saw this the first time 2 weeks ago in a mondrian over lucid. I<br>
>> thought it had to do with lucid's connection polling.<br>
>><br>
>><br>
>> I saw this again *today* with mondrian with mysql.<br>
>><br>
>><br>
>> Common factor: They were both on pentaho 4.5 (with mondrian 3.4.1).<br>
>><br>
>><br>
>> Commented this with Jan Aertsen and he said "weird - someone mentioned<br>
>> something very similar a few days ago".<br>
>><br>
>><br>
>> I'm not saying this is a regression cause I don't know what it is. I<br>
>> know some work has been done on query execution. But it's definitely<br>
>> something that was not there before (or all our dashboards would be<br>
>> basically unusable).<br>
>><br>
>><br>
>> Does this ring any bells to anyone? We'll try to see if we can somehow<br>
>> reproduce this, but it's incredibly hard to reproduce concurrency<br>
>> issues.... :(<br>
>><br>
>><br>
>><br>
>> -pedro<br>
>> _______________________________________________<br>
>> Mondrian mailing list<br>
>> <a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
>> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
><br>
> _______________________________________________<br>
> Mondrian mailing list<br>
> <a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</div></div></blockquote></div><br>
_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</blockquote></div></div></div><br></div></div></div><br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>
_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>http://lists.pentaho.org/mailman/listinfo/mondrian<br></blockquote></div><br></body></html>