Hi,
I this related to this issue reported in github :
https://github.com/openlink/virtuoso-opensource/issues/80 ?
Best,
Julien
----- Mail original -----
> De: virtuoso-users-requ...@lists.sourceforge.net
> À: virtuoso-users@lists.sourceforge.net
> Envoyé: Lundi 23 Septembre 2013 03:16:48
> Objet: Virtuoso-users Digest, Vol 83, Issue 11
> Send Virtuoso-users mailing list submissions to
> virtuoso-users@lists.sourceforge.net
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> or, via email, send a message with subject or body 'help' to
> virtuoso-users-requ...@lists.sourceforge.net
> You can reach the person managing the list at
> virtuoso-users-ow...@lists.sourceforge.net
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Virtuoso-users digest..."
> Today's Topics:
> 1. Re: Odd behavior in Virtuoso 7.0.0 (Erich Bremer)
> 2. Re: Odd behavior in Virtuoso 7.0.0 (Kingsley Idehen)
> 3. Re: Odd behavior in Virtuoso 7.0.0 (Erich Bremer)
> ----------------------------------------------------------------------
> Message: 1
> Date: Sun, 22 Sep 2013 14:40:26 -0400
> From: Erich Bremer <er...@ebremer.com>
> Subject: Re: [Virtuoso-users] Odd behavior in Virtuoso 7.0.0
> To: Kingsley Idehen <kide...@openlinksw.com>,
> virtuoso-users@lists.sourceforge.net
> Message-ID: <523f399a.2050...@ebremer.com>
> Content-Type: text/plain; charset="iso-8859-1"
> Hi Kingsley,
> My statement about the triple count SPARQL query was only to state
> that my virtuoso wasn't frozen for other queries. Historically, for
> all
> of my virtuoso 6.x installs:
> select distinct ?g where {graph ?g {?s ?p ?o}}
> and
> select count(*) as ?cc where {?s ?p ?o}
> have always worked quick, so, I never bothered to optimize either as
> you
> specified :-)
> And since:
> select distinct ?g where {graph ?g {?s ?p ?o}}
> has always worked quicked for me in virtuoso 6.X, it just seemed
> natural/reasonable to think something weird was going on when it
> didn't
> work quick in virutoso 7 as it has and does in virtuoso 6 - Erich
> On 09/22/13 9:50 AM, Kingsley Idehen wrote:
> > On 9/22/13 8:32 AM, Hugh Williams wrote:
> >> a) select distinct ?g where {graph ?g {?s ?p ?o}}
> >>
> >> from the SPARQL endpoint and it timed out.
> >>
> >> however, the following query against http://www.geonames.org would
> >> work
> >> in a second:
> >>
> >> b) select count(*) as ?cc where {?s ?p ?o}
> >
> > The issue is that listing all the named graph IRIs in a quad store
> > is
> > much different from getting a count of all the triples in a named
> > graph.
> >
> > Count of named graph IRIs would be:
> >
> > SELECT COUNT(*) WHERE {GRAPH ?g {?s ?p ?o}} .
> >
> > You can reduce the cost of this quest using:
> >
> > SELECT COUNT(*) WHERE {GRAPH ?g {?s a ?o}} .
> >
> > Examples using the LOD cloud cache instance:
> >
> >
> > 1.
> > http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+COUNT%28*%29+WHERE+%7BGRAPH+%3Fg+%7B%3Fs+%3Fp+%3Fo%7D%7D+&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
> > -- count of all named graphs associated with any triple
> >
> > 2.
> > http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+COUNT%28*%29+WHERE+%7BGRAPH+%3Fg+%7B%3Fs+a+%3Fo%7D%7D+&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
> > -- count of all name graphs associate with isA relation based
> > triples.
> >
> >
> >
> > ------------------------------------------------------------------------------
> > LIMITED TIME SALE - Full Year of Microsoft Training For Just
> > $49.99!
> > 1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
> > SharePoint
> > 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power
> > Pack includes
> > Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends
> > 9/22/13.
> > http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
> >
> >
> > _______________________________________________
> > Virtuoso-users mailing list
> > Virtuoso-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> -------------- next part --------------
> An HTML attachment was scrubbed...
> ------------------------------
> Message: 2
> Date: Sun, 22 Sep 2013 19:35:39 -0400
> From: Kingsley Idehen <kide...@openlinksw.com>
> Subject: Re: [Virtuoso-users] Odd behavior in Virtuoso 7.0.0
> To: virtuoso-users@lists.sourceforge.net
> Message-ID: <523f7ecb.9060...@openlinksw.com>
> Content-Type: text/plain; charset="iso-8859-1"
> On 9/22/13 2:40 PM, Erich Bremer wrote:
> > Hi Kingsley,
> >
> > My statement about the triple count SPARQL query was only to state
> > that my virtuoso wasn't frozen for other queries. Historically, for
> > all of my virtuoso 6.x installs:
> >
> > select distinct ?g where {graph ?g {?s ?p ?o}}
> > and
> > select count(*) as ?cc where {?s ?p ?o}
> >
> > have always worked quick, so, I never bothered to optimize either
> > as
> > you specified :-)
> > And since:
> > select distinct ?g where {graph ?g {?s ?p ?o}}
> > has always worked quicked for me in virtuoso 6.X, it just seemed
> > natural/reasonable to think something weird was going on when it
> > didn't work quick in virutoso 7 as it has and does in virtuoso 6 -
> > Erich
> Ah!
> It should. We'll look into this matter.
> Kingsley
> >
> > On 09/22/13 9:50 AM, Kingsley Idehen wrote:
> >> On 9/22/13 8:32 AM, Hugh Williams wrote:
> >>> a) select distinct ?g where {graph ?g {?s ?p ?o}}
> >>>
> >>> from the SPARQL endpoint and it timed out.
> >>>
> >>> however, the following query against http://www.geonames.org
> >>> would work
> >>> in a second:
> >>>
> >>> b) select count(*) as ?cc where {?s ?p ?o}
> >>
> >> The issue is that listing all the named graph IRIs in a quad store
> >> is
> >> much different from getting a count of all the triples in a named
> >> graph.
> >>
> >> Count of named graph IRIs would be:
> >>
> >> SELECT COUNT(*) WHERE {GRAPH ?g {?s ?p ?o}} .
> >>
> >> You can reduce the cost of this quest using:
> >>
> >> SELECT COUNT(*) WHERE {GRAPH ?g {?s a ?o}} .
> >>
> >> Examples using the LOD cloud cache instance:
> >>
> >>
> >> 1.
> >> http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+COUNT%28*%29+WHERE+%7BGRAPH+%3Fg+%7B%3Fs+%3Fp+%3Fo%7D%7D+&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
> >> -- count of all named graphs associated with any triple
> >>
> >> 2.
> >> http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+COUNT%28*%29+WHERE+%7BGRAPH+%3Fg+%7B%3Fs+a+%3Fo%7D%7D+&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
> >> -- count of all name graphs associate with isA relation based
> >> triples.
> >>
> >>
> >>
> >> ------------------------------------------------------------------------------
> >> LIMITED TIME SALE - Full Year of Microsoft Training For Just
> >> $49.99!
> >> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
> >> SharePoint
> >> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power
> >> Pack includes
> >> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends
> >> 9/22/13.
> >> http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
> >>
> >>
> >> _______________________________________________
> >> Virtuoso-users mailing list
> >> Virtuoso-users@lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> >
> >
> >
> > ------------------------------------------------------------------------------
> > LIMITED TIME SALE - Full Year of Microsoft Training For Just
> > $49.99!
> > 1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
> > SharePoint
> > 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power
> > Pack includes
> > Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends
> > 9/22/13.
> > http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
> >
> >
> > _______________________________________________
> > Virtuoso-users mailing list
> > Virtuoso-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> --
> Regards,
> Kingsley Idehen
> Founder & CEO
> OpenLink Software
> Company Web: http://www.openlinksw.com
> Personal Weblog: http://www.openlinksw.com/blog/~kidehen
> Twitter/Identi.ca handle: @kidehen
> Google+ Profile: https://plus.google.com/112399767740508618350/about
> LinkedIn Profile: http://www.linkedin.com/in/kidehen
> -------------- next part --------------
> An HTML attachment was scrubbed...
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: smime.p7s
> Type: application/pkcs7-signature
> Size: 2029 bytes
> Desc: S/MIME Cryptographic Signature
> ------------------------------
> Message: 3
> Date: Sun, 22 Sep 2013 21:16:40 -0400
> From: Erich Bremer <er...@ebremer.com>
> Subject: Re: [Virtuoso-users] Odd behavior in Virtuoso 7.0.0
> To: Hugh Williams <hwilli...@openlinksw.com>
> Cc: virtuoso-users <virtuoso-users@lists.sourceforge.net>
> Message-ID: <523f9678.1040...@ebremer.com>
> Content-Type: text/plain; charset="iso-8859-1"
> The CPU utilization for the virtuoso-t process dropped back down once
> I
> returned after a while. As a quick experiment, I ran the SPARQL
> query:
> select distinct ?g where {graph ?g {?s ?p ?o}}
> which drove virtuoso-t to 100% utilization which then timed out
> returning the CPU back to baseline. Trying to list the graphs in
> Conductor-->Linked Data-->Graphs which seems to be the same thing
> (listing all of the named graphs) but "hangs" conductor much longer.
> Perhaps, there is no timeout on this mechanism on this conductor
> mechanism. Like before, shutting down virtuoso and then restarting,
> both the conductor listing of graphs and the above SPARQL query
> execute
> in approximately 1 second for the 120,000,000 triples and
> successfully
> list the 4 named graphs in the system which is the response time that
> I
> typically get with Virtuoso, but not until after the restart. - Erich
> Erich Bremer
> http://www.ebremer.com
> http://haylyn.io
> On 9/22/2013 8:32 AM, Hugh Williams wrote:
> > Hi Erich,
> >
> > Is this condition reproducible as a restart of the server seems to
> > have resolved it ? As it would be interesting to see what the
> > "status();" command reports as to the status of the Virtuoso server
> > when in this state ...
> >
> > Best Regards
> > Hugh Williams
> > Professional Services
> > OpenLink Software, Inc. // http://www.openlinksw.com/
> > Weblog -- http://www.openlinksw.com/blogs/
> > LinkedIn -- http://www.linkedin.com/company/openlink-software/
> > Twitter -- http://twitter.com/OpenLink
> > Google+ -- http://plus.google.com/100570109519069333827/
> > Facebook -- http://www.facebook.com/OpenLinkSoftware
> > Universal Data Access, Integration, and Management Technology
> > Providers
> >
> > On 22 Sep 2013, at 05:32, Erich Bremer <er...@ebremer.com
> > <mailto:er...@ebremer.com>> wrote:
> >
> >> Hi all,
> >>
> >> I'm working with Virtuoso 7.0.0 open source edition and did a load
> >> of
> >> geonames data using isql which was 123,020,822 triples into a
> >> named
> >> graph "http://www.geonames.org";.
> >>
> >> I did a second load of 13,349,346 triples into a different named
> >> graph.
> >> Both loads of turtle RDF completed quickly. When I went to check
> >> to see
> >> if Conductor could see the named graphs, Conductor hung when I
> >> clicked
> >> on Linked Data-->Graphs. I then tried to do:
> >>
> >> a) select distinct ?g where {graph ?g {?s ?p ?o}}
> >>
> >> from the SPARQL endpoint and it timed out.
> >>
> >> however, the following query against http://www.geonames.org would
> >> work
> >> in a second:
> >>
> >> b) select count(*) as ?cc where {?s ?p ?o}
> >>
> >> I initiated a shutdown using isql which took a few moments and
> >> then I
> >> restarted virtuoso. Now, Conductor quickly shows all named graphs
> >> including the new ones, and the above SPARQL query (a) runs nearly
> >> instantly.
> >>
> >> - Erich
> >>
> >> ------------------------------------------------------------------------------
> >> LIMITED TIME SALE - Full Year of Microsoft Training For Just
> >> $49.99!
> >> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
> >> SharePoint
> >> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power
> >> Pack
> >> includes
> >> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends
> >> 9/22/13.
> >> http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
> >> _______________________________________________
> >> Virtuoso-users mailing list
> >> Virtuoso-users@lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> ------------------------------
> ------------------------------------------------------------------------------
> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
> SharePoint
> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack
> includes
> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
> http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
> ------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> End of Virtuoso-users Digest, Vol 83, Issue 11
> **********************************************
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
