Thank you Mitko. At first glance I think that solved my problem. For future reference I dropped these indexes and recreated them as described here: http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning
On 4 June 2012 19:22, Mitko Iliev <[email protected]> wrote: > Hi Alex, > > What version of Virtuoso Open-source you are using? Also how much triples > you have in RDF repository ? > If you have not so big database you can drop RDF_QUAD_POGS index and > re-create ditto RDF_QUAD_GS, then try to drop graph again. > > Best Regards, > Mitko > > On Jun 4, 2012, at 12:52 PM, Alex wrote: > > Hello, > trying to delete a graph I get the error SR201: Primary key not found in > delete. > > I have tried, I think, almost everything such as drop, delete all triples > and the following queries for resyncronization: > > log_enable (2); > INSERT SOFT DB.DBA.RDF_QUAD (G,S,P,O) SELECT G,S,P,O FROM DB.DBA.RDF_QUAD > TABLE OPTION (INDEX RDF_QUAD_POGS); > > SELECT COUNT(*) FROM DB.DBA.RDF_QUAD TABLE OPTION (INDEX RDF_QUAD_POGS) ; > > SELECT COUNT(*) FROM DB.DBA.RDF_QUAD TABLE OPTION (INDEX RDF_QUAD); > > I do not get the same numbers for the two last queries. > > Even though the graph is shown using: > DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS(); > > Is there anything else I could try? > > Thanks. > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > -- > Mitko Iliev > Developer Virtuoso Team > OpenLink Software > http://www.openlinksw.com/virtuoso > Cross Platform Web Services Middleware > >
