Hi Hugh, indeed changing the checkpoint interval solved the problem. The triple being updated via a SPARQL UPDATE were around 86 millions.
Thank you, Nicola Il 08/11/2013 13:41, Hugh Williams ha scritto: > 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 > > ------------------------------------------------------------------------------ Shape the Mobile Experience: Free Subscription Software experts and developers: Be at the forefront of tech innovation. Intel(R) Software Adrenaline delivers strategic insight and game-changing conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
