I created MONDRIAN-585 for the bug, fixed with checkin 12976, MONDRIAN-586 is the reminder to revisit the workaround when the next version of httpclient is available.<br><br><div class="gmail_quote">On Mon, Jul 20, 2009 at 12:05 PM, Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><span><font color="#000080" face="Lucida Sans" size="2">That sounds fine, Matt. Can you log a jira request to remind
us to revisit this.</font></span></div>
<div><span><font color="#000080" face="Lucida Sans" size="2"></font></span> </div>
<div><span><font color="#000080" face="Lucida Sans" size="2">Julian</font></span></div><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><div class="im"><b>From:</b> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Matt
Campbell<br></div><b>Sent:</b> Monday, July 20, 2009 8:42 AM<div class="im"><br><b>To:</b> Mondrian
developer mailing list<br></div><b>Subject:</b> Re: [Mondrian] VFS
issue<br></font><br></div><div><div></div><div class="h5">
<div></div>Thanks for sending the jar, Will. Same problem, though.
I also tried grabbing the latest release of the commons httpclient. That
also failed to help.<br><br>If no one objects, how about I revert back to
using the readURL method for http requests, leaving the existing VFS option
for other file reads? When the commons httpclient 4.0 is released we
could re-visit this.<br><br><br><br>
<div class="gmail_quote">On Sat, Jul 18, 2009 at 12:51 AM, Will Gorman <span dir="ltr"><<a href="mailto:wgorman@pentaho.com" target="_blank">wgorman@pentaho.com</a>></span>
wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">Hey Guys,<br><br>We are still using VFS in Kettle and
Mondrian, Kettle 3.2.0 ended up<br>building from source the latest VFS
because they haven't released 2.0 of<br>VFS yet. I'm not sure if that
would solve these issues or not.<br><br>In Pentaho's BI Platform, we access
our schema files using a custom VFS<br>provider so that it can access our
solution repository, so we rely on<br>VFS.<br><br>Here is a link to Kettle's
custom built VFS 2.0 jar if you want to see<br>if it resolves the
issues:<br><a href="http://source.pentaho.org/svnkettleroot/Kettle/trunk/libext/commons/commons-vfs-2.0-20090205.jar" target="_blank">http://source.pentaho.org/svnkettleroot/Kettle/trunk/libext/commons/commons-vfs-2.0-20090205.jar</a><br>
<font color="#888888"><br>Will<br></font>
<div>
<div></div>
<div><br>On Fri, 2009-07-17 at 15:08 -0400, Matt Campbell
wrote:<br>> I did do a fair amount of searching when we first encountered
this<br>> problem and couldn't find much helpful information at all.
When I get<br>> a chance I'll see if there is a newer version of
VFS.<br>><br>> On Fri, Jul 17, 2009 at 2:25 PM, Julian Hyde <<a href="mailto:jhyde@pentaho.com" target="_blank">jhyde@pentaho.com</a>><br>>
wrote:<br>> Has anyone done a google search
for the issue you are<br>> experiencing? Is
there a newer version of VFS that might fix<br>>
the problem?<br>><br>> Will, what
was the other technology you used?<br>><br>>
I'm OK with switching technology as long as it doesn't break<br>>
existing apps.<br>><br>>
Julian<br>><br>><br>>
______________________________________________________<br>>
From: <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a><br>>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>]
On Behalf Of<br>>
Matt Campbell<br>>
Sent: Friday, July 17, 2009 8:16 AM<br>>
To: Mondrian developer mailing
list<br>>
Subject: [Mondrian] VFS issue<br>><br>><br>><br>>
Awhile back we discovered that
Util.readVirtualFile()<br>>
can throw exceptions when large numbers of requests<br>>
for an HTTP resource
happen. Awhile back I added a<br>>
call to file.close() at the end of that method,
which<br>> had
seemed to make things a bit better in testing.<br>>
I'm still seeing socketConnect exceptions
when<br>>
requesting more than a few hundred http requests. In<br>>
practice this can happen
when we have as few as 15<br>>
concurrent users running reports.<br>><br>>
There appears to be no such
problem with the pre-VFS<br>>
method that Mondrian used for loading a URL. I<br>>
created a Unit test
which loads 100,000 pages via the<br>>
old Util.readURL method. That runs fine with
no<br>>
exceptions. The VFS method fails with fewer than 1000<br>>
requests.<br>><br>>
Would anyone object
to reverting back to the old<br>>
Util.readURL for http requests? Alternatively,
I<br>> think Will
Gorman said at one point that they<br>>
abandoned VFS for other Pentaho projects in
favor of<br>>
some other library--would that be worth considering<br>>
for
Mondrian?<br>><br>><br>><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>><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>
</div></div></blockquote></div><br></div></div></blockquote></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>