<div dir="ltr">I've made the bug report: <a href="http://jira.pentaho.com/browse/MONDRIAN-1810">http://jira.pentaho.com/browse/MONDRIAN-1810</a></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Nov 15, 2013 at 7:05 PM, Hilario Fernandes <span dir="ltr"><<a href="mailto:hilario.fernandes@cortex-intelligence.com" target="_blank">hilario.fernandes@cortex-intelligence.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thanks for your input, i'll fill a bug report with all the information.<div><br></div><div>So, you think that the schema change on the single connection used by the application might cause the problem. Maybe if i create a connection per query would help? Basically i'd be using a pool of olap connections... But I've seen somewhere that creating multiple olapconnections to wasn't the best way to go... I'll give it a try nonetheless!</div>
</div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Nov 15, 2013 at 6:01 PM, Julian Hyde <span dir="ltr"><<a href="mailto:julianhyde@gmail.com" target="_blank">julianhyde@gmail.com</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">Can you log a jira case for this? We fixed the previous issue, and your scenario is sufficiently different that it's probably a separate bug. <div>
<br></div><div>I wonder whether the multi-threaded nature of your application is causing this. If the list of columns in a star is changing, say because one connection is using a star for a query while another one is building a schema and adding columns to the same star, then that might explain it. I don't have the solution to the bug, but hopefully these remarks would give an engineer a clue where to look.</div>
<span><font color="#888888"><div><br></div><div>Julian</div></font></span><div><div><div><br><div><div>On Nov 15, 2013, at 3:43 AM, Hilario Fernandes <<a href="mailto:hilario.fernandes@cortex-intelligence.com" target="_blank">hilario.fernandes@cortex-intelligence.com</a>> wrote:</div>
<br><blockquote type="cite"><div dir="ltr">So, i've been trying to isolate this issue and it has not been easy, but finally i've managed to get one run where i got the erros in a log i could use to present here. One thing to point out, this is not consistent. The sequence of queries that gave the error might not give it if i run it again on the same conditions with no change in the data. This is what is making it so hard to figure what's causing it.<div>
<br></div><div>The project i'm working is built uppon grails framework, there is a service in it that holds the olapConnection to run the queries. These are the startup parameters:</div><div><br></div><div><div>def connectionProperties = '' << 'jdbc:mondrian:'</div>
<div>connectionProperties << "Jdbc="jdbc:monetdb://host:50000/database;"</div><div>connectionProperties << "JdbcUser=username;"</div><div>connectionProperties << "JdbcPassword=password;"</div>
<div>connectionProperties << "JdbcDrivers=nl.cwi.monetdb.jdbc.MonetDriver;"</div><div>connectionProperties << "UseContentChecksum=true;"</div><div>connectionProperties << "CatalogContent=<Schema name=\"CUBES\"></Schema>"</div>
</div><div><br></div><div><div>Class.forName("mondrian.olap4j.MondrianOlap4jDriver")</div><div>def connection = DriverManager.getConnection(connectionProperties)</div><div>def olapConnection = connection.unwrap(OlapConnection.class)<br>
</div></div><div><br></div><div><br></div><div>The cube schema is generated per analysis so we add it before the query and remove it after its completed ("INFO mondrian.MondrianBridge CURRENT CUBES:[]" in the log indicates the cubes in the global schema at that time). This is the code we use for that:</div>
<div><br></div><div><div>RolapSchema schema = getServerSchema(olapConnection)</div><div>schema.createCube(xml)<br></div><div>...</div><div>schema.removeCube(cubeId)</div></div><div><div><br></div><div><br></div></div><div>
Query execution is done with this code:</div><div><br></div><div>OlapStatement statement = olapConnection.createStatement()<br></div><div>statement.executeOlapQuery(query)<br></div><div><br></div><div><br></div><div>As for the log, i've added it here so the email is shorter: <a href="http://pastebin.com/Y7Z0Hi0b" target="_blank">http://pastebin.com/Y7Z0Hi0b</a></div>
<div><br></div><div>Any ideas are appreciated!</div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 13, 2013 at 5:54 PM, Julian Hyde <span dir="ltr"><<a href="mailto:julianhyde@gmail.com" target="_blank">julianhyde@gmail.com</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">This looks very much like <a href="http://jira.pentaho.com/browse/MONDRIAN-1047" target="_blank">http://jira.pentaho.com/browse/MONDRIAN-1047</a>. Worth checking whether we have regressed.<span><font color="#888888"><div>
<br></div><div>Julian</div></font></span></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>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">Hilario Fernandes<br></div>
</div></div>
_______________________________________________<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><br></div></div></div></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>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div>Hilario Fernandes<br></div></div>
</div>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div>Hilario Fernandes<br></div></div>
</div>