Hi, Nirmala --
On 7 Jul 2009, at 14:58, Nirmala Seethappan wrote:
I try to run a query to upload into the virtuoso triple store.
I get the following error when i do so.
_______________________________
SQLState: 40005
Message: SR325: Transaction aborted because it's log after image size
went above the limit
-------------------------------------------------
This error is caused due to the size of the graph which is huge.
what is
the possible solution to resolve this.
scenario:
1) I try to upload 15 graphs in the virtuoso store using virtuoso
isql.
2) all the queries work except 2 of them
3) The query is "INSERT INTO GRAPH "
On Jul 7, 2009, at 11:17 AM, Hugh Williams wrote:
Are the graphs available in RDF/XML or N3 /Turtle forms/datasets ?
If so you can use one of the following functions for loading large
RDF datasets into Virtuoso locally:
<http://docs.openlinksw.com/virtuoso/fn_ttlp_mt.html>
<http://docs.openlinksw.com/virtuoso/fn_rdf_load_rdfxml_mt.html>
Depending on your environment, this may also be a useful function --
<http://docs.openlinksw.com/virtuoso/fn_ttlp_mt_local_file.html>
If not then you would need to split the insertion of the graph data
into smaller chunks such as to not exceed the transaction log file
limit.
... or you can increase the log size limit through the INI file setting
TransactionAfterImageLimit, as discussed in the docs --
<http://docs.openlinksw.com/virtuoso/dbadm.html>
(Search the page for the setting name.)
Do note that the required log size is likely to be substantially greater
than the space for the graph or the originating data file, so this last
option is not always the best choice, though it may be considered
easiest.
Regards,
Ted
--
A: Yes. http://www.guckes.net/faq/attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?
Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support // mailto:tthibod...@openlinksw.com
OpenLink Software, Inc. // http://www.openlinksw.com/
http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/
http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers
