That last isql "lockup" completed and correctly but it took a long time: SQL> SQL> DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS(); GRAPH_IRI VARCHAR _______________________________________________________________________________
http://www.openlinksw.com/schemas/virtrdf# http://localhost:8890/sparql http://localhost:8890/DAV/ http://www.w3.org/2002/07/owl# http://www.geonames.org 5 Rows. -- 583356 msec. SQL> - Erich On 09/23/13 10:29 AM, Erich Bremer wrote: > My original "locked" isql session just spit out the rest of the named > graphs including the geonames graph: > http://localhost:8890/DAV/ > http://www.w3.org/2002/07/owl# > http://www.geonames.org > > 5 Rows. -- 644278 msec. > SQL> SQL> DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS(); > > Running DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS(); again "froze" isql once > more. - Erich > > On 09/23/13 10:28 AM, Erich Bremer wrote: >> Hi Hugh, >> >> The dataset is geonames.org's ~120million triple data set. I >> converted the quasi-RDF/XML dump they have (URI, RDF/XML. URI, RDF/XML, >> URI, RDF/XML ...) and split the triples over 50 turtle files. >> I repeated the same experiement again for the third time (with what >> I thought was the same protocol I had followed), but the bug did not occur. >> I repeated the same experiment again but I remembered that I had >> hit Conductor-->Linked Data-->Graphs while it was loading and conductor >> (at least the session I was in) locked. I ran >> DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() in isql and it locked my isql >> session (apparently) but eventually this came out: >> SQL> DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS(); >> GRAPH_IRI >> VARCHAR >> _______________________________________________________________________________ >> >> http://www.openlinksw.com/schemas/virtrdf# >> >> ======================================= >> I ran: >> select count(*) as ?cc where {?s ?p ?o} >> in a sparql session and it came back quick (ie the system is still loading) >> I did a status() in another isql and caught what looked like a bunch of >> errors in the form: >> 24498: IER NO OWNER >> 24499: IER NO OWNER >> 24500: IER 1 >> 24501: IER NO OWNER >> 24502: IER NO OWNER >> 24503: IER NO OWNER >> 24504: IER 1 >> 24505: IER 1 >> 62: ISR NO OWNER >> 24506: IER NO OWNER >> 24507: IER 1 >> 24508: IER NO OWNER >> 24509: IER NO OWNER >> 24510: IER NO OWNER >> 24511: IER 1 >> 24512: IER 1 >> 40: ISR NO OWNER >> 38: ISR NO OWNER >> 39: ISR NO OWNER >> 24513: IER NO OWNER >> 24514: IER NO OWNER >> 24515: IER 1 >> 79: ISR NO OWNER >> 24516: IER NO OWNER >> 24518: IER NO OWNER >> 24519: IER NO OWNER >> 24520: IER 1 >> 74: ISR NO OWNER >> 24521: IER NO OWNER >> 24522: IER NO OWNER >> 24523: IER 1 >> 40: ISR NO OWNER >> 41: ISR NO OWNER >> 24524: IER NO OWNER >> 24525: IER NO OWNER >> 24526: IER 1 >> 50: ISR NO OWNER >> 24527: IER NO OWNER >> 24528: IER 1 >> 41: ISR NO OWNER >> 24529: IER 1 >> 20: ISR NO OWNER >> 19: ISR NO OWNER >> 24530: IER NO OWNER >> 24531: IER NO OWNER >> 24532: IER 1 >> 50: ISR NO OWNER >> 51: ISR NO OWNER >> 24533: IER 1 >> 47: ISR NO OWNER >> >> Client 1111:1: Account: dba, 384 bytes in, 544 bytes out, 1 stmts. >> PID: 32488, OS: unix, Application: unknown, IP#: 127.0.0.1 >> Transaction status: PENDING, 1 threads. >> Locks: 24382: IE, 24343: IS, 24404: IE, 24422: IE, 24483: IE, 24359: IE, >> 24347: IS, 24410: IE, 24372: IE, 24520: IE, 24351: IE, .... >> >> Client 1111:10: Account: dba, 550 bytes in, 942792 bytes out, 1 stmts. >> PID: 32510, OS: unix, Application: unknown, IP#: 127.0.0.1 >> Transaction status: PENDING, 1 threads. >> Locks: >> >> >> Running Statements: >> Time (msec) Text >> 165 status() >> 418830 DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() >> >> >> Hash indexes >> >> >> 244 Rows. -- 167 msec. >> >> >> but most got clipped because my putty didn't show history. Once the >> load finished, my conductor session had finally flipped to another >> screen (I had clicked on a different menu, but when I went back to the >> graph list it froze again. I ran: >> >> select distinct ?g where {graph ?g {?s ?p ?o}} >> >> and it timed out like trials #1 and #2. The currently "locked" isql >> session just spitted out the loader completions and then spit out two >> more lines of the DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() function: >> http://localhost:8890/DAV/ >> http://www.w3.org/2002/07/owl# >> >> It seems, if you hit the graph listing during the 8 threaded load. >> something gums up, but, when you don't, it works fine. I hope this >> helps. - Erich >> >> >> >> On 09/23/13 7:26 AM, Hugh Williams wrote: >>> 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 <er...@ebremer.com> 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 <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 >>>> ------------------------------------------------------------------------------ >>>> 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 >> ------------------------------------------------------------------------------ >> 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 > > ------------------------------------------------------------------------------ > 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 ------------------------------------------------------------------------------ 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
