Hi Please confirm the version of Virtuoso you are using by running the command β./virtuoso-t -?β from you βbinβ directory of Virtuoso installation directory.
Also, what is the name of the graph it reports these unexpected triples that
should have been removed to be in, using the following corrected and amended
query you were running below:
select distinct ?g ?r where { graph ?g {?u ?r ?s}}
pointing out which triple(s) should have been removed, as I am curious to know
where they are located ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
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 29 Feb 2012, at 14:28, aliki aliki wrote:
> Thank you for the replies.
> The triples returned are some of the ones I have loaded with rdf_loader_run()
> (Triples from dbpedia dumps). I can also see the ones from the system graphs
> but not only them.
> Subject: Re: [Virtuoso-users] Problem concenring deleting triples
> From: [email protected]
> Date: Wed, 29 Feb 2012 12:58:26 +0000
> CC: [email protected]
> To: [email protected]
>
> Hi
>
> The best methods for deleted graphs in Virtuoso, particularly large ones are
> detailed at:
>
>
> http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs
>
> The best methods for deleting all graphs which includes the RDF_GLOBAL_REST()
> method is detailed at:
>
> http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtRemoveTriples
>
> This will not remove anything from the load_list table which is just a
> reference for loaded datasets and should be cleaned manually before the
> rdf_loader_run() is run if no longer valid.
>
> When you say triples are still returned are these from those you know have
> been loaded with rdf_loader_run() or other method or are these just the
> default system graphs Virtuoso maintains ? What is the actual triple count
> after deleting all the graphs ?
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> 10 Burlington Mall Road, Suite 265, Burlington MA 01803
> 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 29 Feb 2012, at 10:58, aliki aliki wrote:
>
> Hello!
>
> I have great trouble while trying to delete data (rdf triples) from my
> virtuoso database. First I tried to delete everything by using the
> RDF_GLOBAL_RESET() function. When finished, I searched for the remaining
> graphs using the sparql command:
>
> select distinct ?g
> from <http://localhost:1111/> {graph ?g {?s a ?t} };
>
> which gave the result: http://www.openlinksw.com/schemas/virtrdf#
>
>
> However, the db.dba.load_list was still full with all the graphs I had
> previously loaded. So I deleted everything from the load_list thinking that
> the data had been erased from the database and not from the load_list. Then I
> performed the query:
>
> select distinct ?r from {?u ?r ?s}
>
> hoping not to find any of the triples deleted. Unfortunately some of the
> triples are still loaded and probably not belonging to any graph as there is
> no graph loaded on the system.
>
> I'm not quite sure that I understand how virtuoso works and I cannot find any
> logical explanation on my own. Could you please tell me how can I solve the
> problem? And if I manage to solve it, which is the right way to delete data
> from graphs or to delete entire graphs?
>
> Thanks in advance!!
> ------------------------------------------------------------------------------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
> ------------------------------------------------------------------------------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
