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

Attachment: 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

Reply via email to