Hi Nirmala, I am slightly confused, back in July you where getting "Transaction aborted because it's log after image size went above the limit" errors performing SPARUL insert queries and advised to the the RDF_LOAD_RDFXML_MT function for loaded large datasets or increase the "TransactionAfterImageLimit" ini file param which controls the log size limit, are you not hitting this issue again here ?
How many triples are you attempting to insert and what if any errors are occurring when attempting this ? Do check the virtuoso.log file to see if any errors are being logged their also ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 18 Nov 2009, at 12:32, Nirmala Seehappan wrote: > Hi Hugh, > > i don't face any problem with the load of the data,but my problem is with the > insert statements. > > INSERT INTO GRAPH <http://test/graph1> {....}; > > The result of this is broken into groups of 100001 triples(instead of a > single insert result statement) > > cheers, > Nirmala > > > -----Original Message----- > From: Hugh Williams [mailto:[email protected]] > Sent: Tuesday, November 17, 2009 3:23 PM > To: Nirmala Seethappan > Cc: [email protected] > Subject: Re: [Virtuoso-users] Upper Limit of triples inserted > > Hi Nirmala, > > Their should be no limits to the number of triples that can be loaded. For > large datasets however we do recommend the use of the rdf_load_rdfxml_mt > function which is a multi-threaded variant of the function you are using as > detailed at: > > http://docs.openlinksw.com/virtuoso/fn_rdf_load_rdfxml_mt.html > > What is the actual number of triples in the dataset being loaded ? Assuming > their is one per line you can use the following to determine this: > > wc -l <dataset_file_name> > > I note you are running the Virtuoso 5.0.8 build, and would thus recommend you > also try with the latest 5.0.12 archive available for download as their have > been some fixes for loading RDF data in this build: > > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload > > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 17 Nov 2009, at 13:21, Nirmala Seehappan wrote: > >> Hi, >> >> I'm working in virtuoso 5.0.8 and trying to upload data into the graphs >> using DB.DBA.RDF_LOAD_RDFXML. >> The output of the insert statement is as follows: >> _______________________________________________ >> Insert into <http://test/graph1>, 100001 triples -- done >> >> 1 Rows. -- 10846 msec. >> callret-0 >> VARCHAR >> _______________________________________________ >> >> The datafile has more triples(>100001), but i doubt if the insert statement >> is limited to 100001 triples per insert statement. This same line gets >> repeated more often when the input file size is bigger. >> >> Is there any limit for the insert statements ? >> If so, are there any parameters in the virtuoso.ini file that controls this >> limit? >> >> Please do provide me more understanding on this issue. >> >> cheers, >> Nirmala >> >> >> ---------------------------------------------------------------------- >> -------- Let Crystal Reports handle the reporting - Free Crystal >> Reports 2008 30-Day trial. Simplify your report design, integration >> and deployment - and focus on what you do best, core application >> coding. Discover what's new with Crystal Reports now. >> http://p.sf.net/sfu/bobj-july >> _______________________________________________ >> Virtuoso-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
