%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}%


---+How to Update Large SPARQL Data avoiding due to database checkpoint abortion?


Assume while performing large SPARQL update, for example of triples around 80 millions in total, one gets the following error which aborts the update:
<verbatim>
"Transaction aborted due to a database checkpoint or database-wide
atomic operation. Please retry transaction" .
</verbatim>

The error means that the SPARQL update has possibly encountered a database checkpoint during the load. 
Thus one should check the [[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ini_Parameters][CheckpointInterval]] in the INI file and possible increase its value:

<verbatim>
;
;  Server parameters
;
[Parameters]
...
CheckpointInterval       = 60
...
</verbatim>

<b>Note:</b> The [[VirtBulkRDFLoader][RDF Bulk loader]] can be used for loading large datasets, and it will handle the checkpoint matter automatically.


---++Related

   * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
   * [[http://docs.openlinksw.com/virtuoso/rdfsparql.html][Virtuoso Documentation]]