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 <[email protected]> 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
> [email protected]
> 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 [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
