[Virtuoso-users] Exception Violating unique index RDF_QUAD_POGS
Dear all, I've started testing version 6.1.4 but I've having the same problems with transactions when doing a bulk update. Concretely I get the following exception: com.hp.hpl.jena.shared.JenaException: Couldn't create transaction:com.hp.hpl.jena.shared.JenaException: rethrew: java.sql.BatchUpdateException: SR175: Uniqueness violation : Violating unique index RDF_QUAD_POGS on table DB.DBA.RDF_QUAD. Transaction killed. This is the code I use for the upload: VirtGraph graph = new VirtGraph (DATA_URI, DB_URL, DB_USER, DB_PASSWD); ... graph.getTransactionHandler().begin(); graph.getBulkUpdateHandler().add(jenaModel.getModel().getGraph()); graph.getTransactionHandler().commit(); ... It seems to work well at the beginning but as I'm trying to load a quite big dataset (I'm regenerating the Semantic XBRL dataset) at some point it starts throwing this exception for most of the attempts to load an RDF model. Best, Roberto García http://rhizomik.net/~roberto
Re: [Virtuoso-users] Exception Violating unique index RDF_QUAD_POGS
No, I don't have transactions turned off. Should I do so and remove the begin() and commit() calls from my code then? Roberto García http://rhizomik.net/~roberto 2011/11/11 Hugh Williams hwilli...@openlinksw.com: Hi Roberto, Do you have transactions turned of when performing this bulk load operation, using the Virtuoso “log_enable” function as SPARUL operations are no transactional as detailed at: http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfsparul http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideTransactionLogControl Hence the transaction errors you are encountering ... 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 11 Nov 2011, at 11:25, Roberto García wrote: Dear all, I've started testing version 6.1.4 but I've having the same problems with transactions when doing a bulk update. Concretely I get the following exception: com.hp.hpl.jena.shared.JenaException: Couldn't create transaction:com.hp.hpl.jena.shared.JenaException: rethrew: java.sql.BatchUpdateException: SR175: Uniqueness violation : Violating unique index RDF_QUAD_POGS on table DB.DBA.RDF_QUAD. Transaction killed. This is the code I use for the upload: VirtGraph graph = new VirtGraph (DATA_URI, DB_URL, DB_USER, DB_PASSWD); ... graph.getTransactionHandler().begin(); graph.getBulkUpdateHandler().add(jenaModel.getModel().getGraph()); graph.getTransactionHandler().commit(); ... It seems to work well at the beginning but as I'm trying to load a quite big dataset (I'm regenerating the Semantic XBRL dataset) at some point it starts throwing this exception for most of the attempts to load an RDF model. Best, Roberto García http://rhizomik.net/~roberto -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Exception Violating unique index RDF_QUAD_POGS
Hi Roberto, Yes, you can remove these as there is nothing to commit ... 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 11 Nov 2011, at 15:27, Roberto García wrote: No, I don't have transactions turned off. Should I do so and remove the begin() and commit() calls from my code then? Roberto García http://rhizomik.net/~roberto 2011/11/11 Hugh Williams hwilli...@openlinksw.com: Hi Roberto, Do you have transactions turned of when performing this bulk load operation, using the Virtuoso “log_enable” function as SPARUL operations are no transactional as detailed at: http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfsparul http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideTransactionLogControl Hence the transaction errors you are encountering ... 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 11 Nov 2011, at 11:25, Roberto García wrote: Dear all, I've started testing version 6.1.4 but I've having the same problems with transactions when doing a bulk update. Concretely I get the following exception: com.hp.hpl.jena.shared.JenaException: Couldn't create transaction:com.hp.hpl.jena.shared.JenaException: rethrew: java.sql.BatchUpdateException: SR175: Uniqueness violation : Violating unique index RDF_QUAD_POGS on table DB.DBA.RDF_QUAD. Transaction killed. This is the code I use for the upload: VirtGraph graph = new VirtGraph (DATA_URI, DB_URL, DB_USER, DB_PASSWD); ... graph.getTransactionHandler().begin(); graph.getBulkUpdateHandler().add(jenaModel.getModel().getGraph()); graph.getTransactionHandler().commit(); ... It seems to work well at the beginning but as I'm trying to load a quite big dataset (I'm regenerating the Semantic XBRL dataset) at some point it starts throwing this exception for most of the attempts to load an RDF model. Best, Roberto García http://rhizomik.net/~roberto -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users smime.p7s Description: S/MIME cryptographic signature