Hi Bharath, I would suggest rebuilding the index and then see if the delete from graph is still causing a crash. Also do confirm you are running the latest 6.1.3 open source release, use the “virtuoso-t -?” command to determine the version.
If a core file being produced when a crash occurs you can use gdb to create a stacktrace to determine the cause if nothing is being written to the log. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 3 May 2011, at 06:19, Bharath V wrote: > Thanks Hugh for the reply i will check the virtuoso's index . > > I have one more doubt when ever we use the delete query : > -- SPARQL DELETE FROM GRAPH <http://examp.org> { ?s ?p ?o } FROM > <http://examp.org> WHERE { ?s ?p ?o.}) > the whole virtuoso crashes and there is no log also to know about the issues > or why its crashing. > > Regards, > Bharath > > > From: Hugh Williams <hwilli...@openlinksw.com> > To: Bharath V <bhar...@metaome.com> > Cc: Virtuoso-users@lists.sourceforge.net; Ramkumar Nandakumar > <r...@metaome.com>; a...@metaome.com > Sent: Tue, 3 May, 2011 4:54:53 AM > Subject: Re: [Virtuoso-users] Primary key not found in delete error cause > > Hi Bharath, > > I doubt the data is being loaded incorrectly but sounds as an index on the > RDF_QUAD table might be corrupt, which case you could try dropping and > recreating them as detailed at: > > > http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfrdfscheme > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 2 May 2011, at 08:14, Bharath V wrote: > >> Hi, >> I am using the below code snippet to load a rdf/xml file into virtuoso. It >> loads the data correctly, but while deleting(clear graph >> <http://www.load.org>) the graph gives >> >> Error : " SQLState: 42S12 Message: SR201: Primary key not found in delete" >> .Is this a problem with the way the data is being loaded into virtuoso or a >> different problem. >> >> Code: >> Model model = ModelFactory.createDefaultModel(); >> model.read("file:\\load.xml"); >> StmtIterator stmtIterator = model.listStatements(); >> List<Triple> triples = new LinkedList<Triple>(); >> while (stmtIterator.hasNext()) { >> triples.add(stmtIterator.nextStatement().asTriple());} >> VirtGraph virtGraph = new VirtGraph("http://www.load.org";, DB_URL, "dba", >> "dba"); >> BulkUpdateHandler bulkUpdateHandler = virtGraph.getBulkUpdateHandler(); >> TransactionHandler transactionHandler = virtGraph.getTransactionHandler(); >> transactionHandler.begin(); >> bulkUpdateHandler.add(triples); >> transactionHandler.commit(); >> >> >> Thank You, >> Bharath >> >> ------------------------------------------------------------------------------ >> WhatsUp Gold - Download Free Network Management Software >> The most intuitive, comprehensive, and cost-effective network >> management toolset available today. Delivers lowest initial >> acquisition cost and overall TCO of any competing solution. >> http://p.sf.net/sfu/whatsupgold-sd_______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > >
