Hi Hasan, See the following tech note tip which details issues deleting large graphs in Virtuoso and how to avoid them:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs 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 30 May 2016, at 18:22, S.M.Shamimul Hasan <shamimul.ha...@gmail.com> wrote: > > Hello, > > I am using Virtuoso (7.1.0). It is installed on a server machine. I am trying > to remove a large RDF graph from my Virtuoso. It contains 2,590,994,053 > triples. I was trying to delete the graph with the following command. > > SPARQL DROP SILENT GRAPH <http://ndssl.bi.vt.edu/chicago/ > <http://ndssl.bi.vt.edu/chicago/>> > > However after running for a long time, Virtuoso is giving me following error. > > *** Error 08S01: [Virtuoso Driver]CL065: Lost connection to server at > line 6 of Top-Level:SPARQL DROP SILENT GRAPH > <http://ndssl.bi.vt.edu/chicago/ <http://ndssl.bi.vt.edu/chicago/>> > > This delete command down my Virtuoso server as well. I also try with SPARQL > "CLEAR" command. After running for a long time, it also terminates. > > BTW I have increase memory size to 128 GB and MaxCheckpointRemap. I have > used following values. However, it does not work. > > NumberOfBuffers = 10900000 > MaxDirtyBuffers = 8000000 > MaxCheckpointRemap = 650000000 > > > Please let me know how can I remove this large graph from my Virtuoso triple > store. I have some other graphs in Virtuoso as well. I do not want to remove > those. > > Thank you. > > Regards, > S.M.Shamimul Hasan > > ------------------------------------------------------------------------------ > What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic > patterns at an interface-level. Reveals which users, apps, and protocols are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity > planning reports. > https://ad.doubleclick.net/ddm/clk/305295220;132659582;e_______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users