Hi Erich, What does the DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() function return if run as this point:
http://docs.openlinksw.com/virtuoso/fn_sparql_select_known_graphs.html
What datasets are you loading when this issue occurs as if they can be provided
we would like to attempt to recreate in-house ?
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 23 Sep 2013, at 02:16, Erich Bremer <[email protected]> wrote:
> 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 <[email protected]> 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
>>> [email protected]
>>> 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/20/13.
> http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
