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
smime.p7s
Description: S/MIME cryptographic signature
