Hi Pantelis, The database integrity check indicated in my post in your previous email may be relevant here as there may be some database corruption causing this error.
It is unlikely to be the dataset being loaded that is the cause of the error.
The RDF_OBJ table indexes can be dropped and recreated as detailed at:
http://docs.openlinksw.com/virtuoso/rdfdatarepresentation.html#rdfquadtables
<http://docs.openlinksw.com/virtuoso/rdfdatarepresentation.html#rdfquadtables>
Also, do ensure you have a backup (online or other) of the database, such that
you can recover to a known good state if need be …
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#backup
<http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#backup>
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
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 14 Jul 2016, at 08:54, Pantelis Natsiavas <natsia...@gmail.com> wrote:
>
> Hi everybody.
>
> I am trying to load a rather big ttl file (contains more than 90 million
> triples).
>
> However, I get the error
>
> File <file_path> error 23000 SR175: Uniqueness violation : Violating unique
> index RDF_OBJ on table DB.DBA.RDF_OBJ. Transaction killed.
>
> Please note that this ttl file got shaped by a custom java parser that
> converted raw data to ttl. Therefore, there could be a mistake like repeating
> the same triple over and over again due to some logical mistake or some
> mistake in raw data.
>
> My questions:
>
> 1. Could a repetition of a triple (due to wrong data contained in ttl file)
> cause such an error?
> 2. I have searched for other similar errors in the internet and seen that
> rebuilding some index tables is suggested. Is there a standard procedure to
> do it for this RDF_OBJ table?
>
> Kind regards,
> Pantelis Natsiavas
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
> patterns at an interface-level. Reveals which users, apps, and protocols are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity planning
> reports.http://sdm.link/zohodev2dev_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
