Hi Nicola, Sounds like your "big" UPDATE has possibly encountered a database checkpoint during the load. Thus what is your checkpoint interval in the INI file and how are you actually performing the load as if you use the RDF Bulk loader for loading large datasets it will handle this for your automatically:
http://www.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader
What is the size of the data being loaded in terms of triple counts and what
sort of memory is available on the system ?
Please also provide the output of running the "status('');" command from isql
when the load it complete or when this error condition occurs for review ...
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 8 Nov 2013, at 09:52, Nicola Vitucci <nicola.vitu...@gmail.com> wrote:
> Hi everyone,
>
> I got this error while doing a "big" UPDATE in Virtuoso 7:
>
> "Transaction aborted due to a database checkpoint or database-wide
> atomic operation. Please retry transaction"
>
> I've tried changing the logging settings using log_enable but I couldn't
> complete the update anyway. I guess this is a sort of "general" error
> related to DB settings rather then the query itself. What might be the
> cause? What do you suggest?
>
> Thank you,
>
> Nicola
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models. Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ November Webinars for C, C++, Fortran Developers Accelerate application performance with scalable programming models. Explore techniques for threading, error checking, porting, and tuning. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
