"log_enable(3,1);" mentioned in 2nd link did the trick. I am able to delete
large graph without any issue.
Thank you .
--sumit purohit
From: Hugh Williams [mailto:hwilli...@openlinksw.com]
Sent: Saturday, April 05, 2014 2:44 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Virtuoso crash when try to delete a huge graph
Hi Sumit,
Firstly, why are you using a build from 07.00.3203 build from August 2013, as
the latest open source builds are 07.10.3208 from Feb 2014 as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSNews#2014-02-17%20--%20Virtuoso%20Open-Source%20Edition%207.1.0%20Released
Please also refer to the following tip on deleting large graphs:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs
Also, how much memory do you have available and has your Virtuoso instance been
tuned to make use of this available memory for best performance as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning
Please check with the "status(''); command to ensure the "buffers" indicated as
available matches the "NumberOfBuffers" set in the INI file, in fact please
provide the output of running the command ...
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 3 Apr 2014, at 00:59, "Purohit, Sumit"
<sumit.puro...@pnnl.gov<mailto:sumit.puro...@pnnl.gov>> wrote:
Hi All,
I have a virtuoso (open source Version: 07.00.3203 Build: Aug 5 2013) server
with around 1.4 B triples.
Recently i tried to delete a named graph which has 285566 triples but on all 3
attempts virtuoso crashed after few minuets.
I used following command on isql prompt to delete the graph:
DROP SILENT GRAPH <qq>
I can delete smaller graphs using same command.
If anyone has a better(i.e. efficient) way of deleting huge graph please
suggest.?
Are there any configuration changes that help, OR should i attempt few triples
at a time till graph size become small enough to deleted.
Thanks
Sumit Purohit
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net<mailto:Virtuoso-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
