Hi Hugh.
I tried once more with the bulk loading procedure and everything worked
smoothly, or at least no error occurred. Therefore, I consider the issue
solved. Perhaps after restarting the virtual machine, the transaction
rolled back and the problem with the indexes has been resolved.
Thank you for your time.
Kind regards,
Pantelis Natsiavas
PS Regarding the integrity check you suggested, I run backup '/dev/null/'
but I got no response yet. I will send the results in the other email
thread, trying to keep a cohesive reference for other users too.
2016-07-17 3:04 GMT+03:00 Hugh Williams <hwilli...@openlinksw.com>:
> 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
>
> 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
>
> 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
>
>
>
------------------------------------------------------------------------------
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
